sharepoint user groups

(2) Share

Report

Posted on by Damitha

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

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Damitha 30 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Daniel_Pipe 57 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
ssvk 145 on at

Like (0)

Report
Copy link

Link copied!

hi @v-micsh-msft

any update so far ?

Was this reply helpful? Yes No
MiraGhaly 34 on at

Like (4)

Report
Copy link

Link copied!

@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 🙂

Was this reply helpful? Yes No