Check, whether Teams/SharePoint user exists in Office 365 Group, using Power Automate

Question

I have a sharepoint site that was automatically generated when a Team was created in MS Teams. I am an owner of the Team and therefore also of the sharepoint site. In the sharepoint site I made a list in which all Team members can add new rows. In Power Automate I made a flow that interacts with this list. In this flow I want to check if the person who runs the flow is an owner of the Teams site.

I found the following REST call to do this. Where I of course substitute <user email> with my email address and <group name> with the owner group name (a Sharepoint Group).

_api/web/sitegroups/getByName('<group name>')/Users?$filter=Email eq '<user email>'

Unfortunately the output is empty, while I really should be a member of the group because I am listed as owner in Teams!

Now, apparently there is a difference between Sharepoint Groups and Office 365 Groups (created with Teams). So my question would be: is there a non-premium way within Power Automate to check whether a user is part of an Office 365 Group? Because checking if the user is part of a Sharepoint Group does not work for me..

You can fetch the group members using Graph API by passing the Group ID — Trinetra-MSFT

Hilton Giesenow Hilton Giesenow · Accepted Answer · 2020-08-28T12:23:21

You should be able to check this using the graph, using this endpoint: https://docs.microsoft.com/en-us/graph/api/group-list-members?view=graph-rest-1.0&tabs=http

Check, whether Teams/SharePoint user exists in Office 365 Group, using Power Automate

2 Answers