Get an array of all security groups a Sharepoint site has

(0) Share

Report

Posted on by Volt26

179

Hello!

I'm doing great so far with PA scripts but I have a challenge I can't find the solution to. I want to get a list (preferably an array) of all security groups within a single Sharepoint site. I know I can find the ID of a group if I do a "Send an HTTP request to Sharepoint" if I provide the name of this group and vice versa.

But in a scenario where I want to extract all these security groups. What can PA do? Please help 🙂

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Did you mean SharePoint groups or AD Security Groups?
You can get SharePoint groups using the /_api/web/sitegroups endpoint.
To query security groups, you need the GRAPH API

Was this reply helpful? Yes No
Volt26 179 on at

Like (0)

Report
Copy link

Link copied!

It looks like a perfect answer but may I ask you how to get the site value variable?
I trigger the flow manually.. I'll mark it accepted as soon as I can get this one working 🙂

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You need to simply provide the displayName of the group after that.
https://graph.microsoft.com/v1.0/groups returns all groups and I am simply filtering out the one with a specific display name.

Was this reply helpful? Yes No
Volt26 179 on at

Like (0)

Report
Copy link

Link copied!

To be honest, I couldn't figure out how to use what you tried to show me...

I got the list of groups by doing this instead :

Can your solution achieve the same goal in a quicker way? A bigger sample would be appreciated because right now, only my way works, yours returns a ton of information but none of it is a Sharepoint security group...

Was this reply helpful? Yes No
SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You are on the right track @Volt26 ! I would have used the same logic if I were you.
Your logic is returning SharePoint Groups, while the one I demonstrated via GRAPH API returns Azure AD Groups.

Was this reply helpful? Yes No