Deepthi M's Blog

Get SharePoint Groups in PowerAutomate

Deepthi M's photo
Deepthi M
·

2 min read

How to fetch SharePoint default groups?

Default groups:

  • Site owners
  • Site members
  • Site visitors

Property used to obtain default groups via REST API call : AssociatedOwnerGroup , AssociatedMemberGroup , AssociatedVisitorGroup

  1. REST API call:

    Syntax: https:// sharepoint domain/sites/siteName/_api/web?$expand=AssociatedOwnerGroup,AssociatedMemberGroup,AssociatedVisitorGroup 


https://contoso.sharepoint.com/sites/contosoSite/_api/web?
$expand=AssociatedOwnerGroup,AssociatedMemberGroup,AssociatedVisitorGroup

output :


{
    "AssociatedMemberGroup": {
        "Id": 5,
        "IsHiddenInUI": false,
        "LoginName": "Contoso Site Members",
        "Title": "Contoso Site Members",
        "PrincipalType": 8,
        "AllowMembersEditMembership": true,
        "AllowRequestToJoinLeave": false,
        "AutoAcceptRequestToJoinLeave": false,
        "Description": null,
        "OnlyAllowMembersViewMembership": false,
        "OwnerTitle": "Contoso Site Owners",
        "RequestToJoinLeaveEmailSetting": ""
    },
    "AssociatedOwnerGroup": {
        "Id": 3,
        "IsHiddenInUI": false,
        "LoginName": "Contoso Site Owners",
        "Title": "Contoso Site Owners",
        "PrincipalType": 8,
        "AllowMembersEditMembership": false,
        "AllowRequestToJoinLeave": false,
        "AutoAcceptRequestToJoinLeave": false,
        "Description": null,
        "OnlyAllowMembersViewMembership": false,
        "OwnerTitle": "Contoso Site Owners",
        "RequestToJoinLeaveEmailSetting": ""
    },
    "AssociatedVisitorGroup": {
        "Id": 4,
        "IsHiddenInUI": false,
        "LoginName": "Contoso Site Visitors",
        "Title": "Contoso Site Visitors",
        "PrincipalType": 8,
        "AllowMembersEditMembership": false,
        "AllowRequestToJoinLeave": false,
        "AutoAcceptRequestToJoinLeave": false,
        "Description": null,
        "OnlyAllowMembersViewMembership": false,
        "OwnerTitle": "Contoso Site Owners",
        "RequestToJoinLeaveEmailSetting": ""
    }
}
  1. REST API call- by Group ID

Syntax: https:// contoso.sharepoint.com/sites/contosoSite _api/Web/SiteGroups(GroupID)/users 

https://pandoranet.sharepoint.com/sites/ATHENATest/_api/Web/SiteGroups(3)/users      ----Owners

https://contoso.sharepoint.com/sites/contosoSite/_api/Web/SiteGroups(5)/users       ----Members

https://contoso.sharepoint.com/sites/contosoSite/_api/Web/SiteGroups(4)/users       ----Visitors
  1. REST API call-by Group name

Syntax: pandoranet.sharepoint.com/sites/ATHENADev3 _api/Web/SiteGroups/GetByName('GroupName')/users 

https://contoso.sharepoint.com/sites/contosoSite/_api/Web/SiteGroups/GetByName('Approvers')/users

For Example: Assume domain as Jwery,site name as JweryDevProd

https://Jwery.sharepoint.com/sites/JweryDevProd/_api/Web/SiteGroups/GetByName('JweryDevProd Owners')/users

https://Jwery.sharepoint.com/sites/JweryDevProd/_api/Web/SiteGroups/GetByName('JweryDevProd Members')/users

https://Jwery.sharepoint.com/sites/JweryDevProd/_api/Web/SiteGroups/GetByName('JweryDevProd Visitors')/users

Space will be filled by %20 after hit enter, which will appear as below

https://Jwery.sharepoint.com/sites/JweryDevProd/_api/Web/SiteGroups/GetByName('JweryDevProd%20Visitors')/users

Tip: If you see error message as Group cannot be found,issue might be because of spaces in group Name,check once

image.png

4.REST API call- Query for specific details

  • Place these query params in above REST API calls but make sure the params associated with specific query

QueryParams:

          "Id": UserID,
            "IsHiddenInUI": false,
            "LoginName": "i:0#.f|membership|abcd@domain.net",
            "Title": "Philips",
            "PrincipalType": 1,
            "Email": "abcd@domain.net",
            "Expiration": "",
            "IsEmailAuthenticationGuestUser": false,
            "IsShareByEmailGuestUser": false,
            "IsSiteAdmin": false,
            "UserId": {
                "__metadata": {
                    "type": "SP.UserIdInfo"
                },
                "NameId": "1234567acd",
                "NameIdIssuer": "urn:federation:microsoftonline"
            },
            "UserPrincipalName": "abcd@domain.net"

https://contoso.sharepoint.com/sites/contosoSite/_api/Web/SiteGroups/GetByName('Approvers')/users?select=email,Title,LoginName
Web Development