Flow Action to add a member to a MS Teams team

[SandyU]

I have this in mind particularly for teams which include external users, such as on a construction project. The external folks might fill out a Forms form requesting access to the Team, or perhaps there would be a spreadsheet sent from a partner org, listing people who should have access. Then the Flow would add members to the project Team without an admin needing to do that for each person - maybe the admin would just approve them as they come in.

Thanks for your consideration!

Sandy

[Laskewitz]

Hi @SandyU,

Wouldn't this action do the trick? 

- Daniel

[mlai2]

Within [User's Email] how would I go about adding a Distribution List, which the Group members can be updated to add any new members of the DL not currently in the Group?

[EricL]

Another important feature would be for the flow not to fail when the member is already in the group, the groups add mentioned above failed when I tested myself and I had to make some ugly branching for each logic to make it work for future steps.

[earlya]

Just to add on, I really like the idea of filling out a MS Form that would add a member to a Team. Saves the owner time. People fill out a quick form and get access to Team materials.

[Laskewitz]

@earlya I think filling out a MS Form is not the right way to go since it doesn't have a people picker. This makes it error-prone. Instead, I would suggest using a PowerApp. 

[claydevin]

@EricL  Good point about failing when member is already in the group.  We have the same requirement, user fills out sharepoint form, requests to be in certain groups, Flow puts them in.   Has anyone got this working??

[Artizeng]

Has anyone had success getting this setup with a SharePoint list? 

[cardraft]

There will be a lot to think about to do that. At first you need to check the mail. I would do something like 1.)fill out form 2.)add to SharePoint list 3.) depending on who he to give free I would sent email with options to approve the user 5.) add to group a member  4.)user get success mail. The biggest issue in my opinion is to select the team the user should be into.  Maybe you also think about an active flag and when you set the flag to deactivated the user should be divided from the group. Do you have a few more information about the exact process who is filling out the form... Who will give free users... How can the user select a group or how do you know where the user is going? 

[sdombrowski]

This solution worked for me.

I used the O365 Connector "User Principal Name" is equal to the Forms Connector "Responders Email".

For SharePoint it should work with the Field "Created by" or you can add a custom Field with the E-Mail Address.

In the end I send them an Invitation E-Mail with the Teams Link.

It is important so set the quotation marks.