cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AndreiCiurea
Advocate I
Advocate I

Can Flow find Teams group's Group ID based on group's name?

Hi everyone,

 

Say I've got an Excel table with two columns: one has a user's e-mail and the other the name of a Teams group's name that the user needs to be added to. This gets exported periodically by a separate tool and automatically uploaded to SharePoint.

 

Now, I know Flow has the Office 365 Group connector which is able to add users to a Teams group, however it can only do that based on a group's ID. I know how to manually get a Teams group's Group Id from its URL, but is there any way that Flow can get it automatically based on a the group's name?

 

The way I'm envisioning the process is:

1. the Excel report automatically gets uploaded to Sharepoint periodically

2. each time Flow accesses the file and goes through the lines

3. it gets the Teams group's Group ID based on the Teams Group's Name column

4. uses that Group Id and the User's email column to add the user to the Teams group

 

I only have an issue with number 3 there, which I haven't managed to find a solution to. Would anybody have a soultion or any suggestions?

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @AndreiCiurea,

 

If this is the case, I am afraid that relying on the current action will not be able to achieve your needs.

If you want to feature that you mentioned to be supported in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-bacao-msft
Community Support
Community Support

Hi @AndreiCiurea,

 

If all Teams group's name in your Teams is unique, your needs are achievable.

You could list all the Teams first, and then determine if the Teams group name is equal to the value in the Excel table.

Then add the user to the corresponding group.

The premise of this method is that all Teams group names are unique.

78.PNG

Please take a try.

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Bary, the "List teams" action says that it "retrieves a list of all the Teams (Office 365 Groups) you are a member of.". Unfortunately I won't be a member of the any of the teams I'll be looking for.

Hi @AndreiCiurea,

 

If this is the case, I am afraid that relying on the current action will not be able to achieve your needs.

If you want to feature that you mentioned to be supported in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

For us, we actually have the group object pulled in from a People field in SharePoint called "O365Group".  Since the object doesn't contain the ID by itself, we parsed it out using the compose method.


last(split(item()['O365Group']['Claims'], '|'))

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,265)