How to add bulk users to Microsoft Teams

Step 1: Create a excel file with name and email address

Create an Excel table with the email addresses. Save it in OneDrive in our example.

Step 2: Create an Instant Power Automate Flow

  1. Go to Power Automate by going to https://flow.microsoft.com or https://make.powerautomate.com/
  2. Click on Create in the left pane.
  3. Select the flow, for example Scheduled cloud flow.

4. Enter the flow name and edit the Run this flow date and time. Then click on Create.

5. Click on + to an action.

6. In the search bar, type list row and select List rows present in a table under Excel Online (Business).

7. Select OneDrive for Business in Location.

8. Select OneDrive in Documents Library.

9. Select the excel file saved in step 1.

10. Select Table, for example Table1 n our example.

11. Click New step.

12. Click + to choose an operation.

13. Type get a row in the search bar. Select Get a rowExcel Online (Business).

14. Select he column and value.

15. If you don’t see Key Value, type /.

16. Add another action for add a member.

17. Select Team and A user principle name or AAD ID.

18. Principle name could be Email address.

19. Now save the settings.

20. For demo, please check the Team’s member.

21. You should have just created flow in My flows.

22. You can test it, run it, edit it and turn it off.

Published by

Bob Lin

Bob Lin, Chicagotech-MVP, MCSE & CNE Data recovery, Windows OS Recovery, Networking, and Computer Troubleshooting on http://www.ChicagoTech.net How to Install and Configure Windows, VMware, Virtualization and Cisco on http://www.HowToNetworking.com