When creating a modern team site, it will connect to Microsoft 365 group. This gives your site a shared notebook, group email address, and team calendar. Moreover, it allows owners to add members directly in the main home page, which basically adds users in the Office 365 group associated with the site.

So, how do you retrieve Owners and Members specifically in the SharePoint Team's group site using Power Automate?


URI : https://graph.microsoft.com/v1.0/groups/?$filter=mail eq '@{variables('GroupEmail')}'

Parse output in JSON of the above request in this format:

{
    "type": "object",
    "properties": {
        "@@odata.context": {
            "type": "string"
        },
        "value": {
            "type": "array",
            "items": {
                "type": "object",
                "properties": {
                    "id": {
                        "type": "string"
                    },
                    "mail": {
                        "type": "string"
                    }
                },
                "required": ["id", "mail"]
            }
        }
    }
}

Create another "Send an HTTP Request". This is where we need to retrieve lists of owners or members. In our case, we are retrieving owners.

Result:

Attachment ZIP Added

I have attached the power Automate zip for reference.

Thanks!