cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Damitha
Level: Powered On

sharepoint user groups

I want to get the list of users belonging to a perticular SharePoint group in Flow. Is this possible?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: sharepoint user groups

Hi @Damitha,

 

SharePoint group column type currently is not supported.

 

Office 365 User connection reference could be found under:

Office 365 Users connection in PowerApps

There is no function could give the group membership.

Please consider submit this as an idea under Microsoft Flow idea forum, to allow Microsoft Flow to work with Office 365 Group membership.

A related idea

Flow to work with Office 365 Group feature such as Calendar

Regards

Community Support Team _ Michael Shao
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

5 REPLIES 5
Highlighted
Damitha
Level: Powered On

Re: sharepoint user groups

In case if it is not possible to access SharePoint group with Flow, my fallback option is O365 groups.

I could not find a action for that as well. Please let me know the possibility of accessing users belonging to a O365 group with Flow also.

Community Support Team
Community Support Team

Re: sharepoint user groups

Hi @Damitha,

 

SharePoint group column type currently is not supported.

 

Office 365 User connection reference could be found under:

Office 365 Users connection in PowerApps

There is no function could give the group membership.

Please consider submit this as an idea under Microsoft Flow idea forum, to allow Microsoft Flow to work with Office 365 Group membership.

A related idea

Flow to work with Office 365 Group feature such as Calendar

Regards

Community Support Team _ Michael Shao
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

Daniel_Pipe
Level: Powered On

Re: sharepoint user groups

You can't filter a powerapps gallery by sharepoint group, Office365 group or AD group, you also can't filter by a people column in sharepoint if multiple selections is turned on and can't filter by a lookup column. Calc columns can't reference people or lookup columns (in case you want to try to convert a people or lookup column to a text string and then use a search expression to filter a gallery). This is a major roadblock.

ssvk
Level: Powered On

Re: sharepoint user groups

hi @v-micsh-msft

 

any update so far ?

MiraGhaly
Level: Powered On

Re: sharepoint user groups

@ssvk

Hello SSVK,

 

i have managed to get the users sharepoint groups using flow by using send HTTP Request to sharepoint:

 


_api/web/SiteUsers/getbyemail('@{triggerBody()?['Author']?['Email']}')

 

Then using also Send HTTP Request to Sharepoint, get the users group as below:

 

_api/Web/GetUserById('@{variables('CreatedBy')}')/Groups

 

 

And HYG you get all the groups the user belongs to 🙂

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 82 members 4,931 guests
Please welcome our newest community members: