Powerapps WebPart, display members of sharepoint site/group

[JimmyWork]

Hi

Im wondering if anyone can point me in the right direction or maybe created a similiar solution.

What im trying to achive is a Powerapp that displays the members of a SharePoint site or 365 group.

I want to use this powerapp on multiple SharePoint pages and i dont want an app for each site.

So using powerapps or with flow i would like to the powerapps webaprt to display the users on the site it loads from.

I would provisiong a site with the powerapp/webpart and then add the groupid for that specific site.

So when the powerapp runs i would like it to get the members from the groupid connected to the sharepoint site or the members of the sharepoint site.

[v-xida-msft · Accepted solution]

Hi @JimmyWork ,

Do you want to embed an canvas app into SP Site Page?

If you want to retrieve members from a SP Site within your embedded app, I afraid that there is no way to achieve your needs in PowerApps currently.

Currently, within PowerApps, there is no way or functions supported to retrieve members from a SP Site.

If you want to retrieve members from a specific O365 group within your embedded app, you must provide the group id (e.g. '57efb8ae-2d32-4b04-807c-73550848af7b') of the specific group.

Based on the needs that you mentioned, I think the PowerApps web part could not achieve your needs. As an alternative solution, I think the <Embed> web part could achieve your needs:

I have made a test on my side, and don't have the issue that you mentioned. Please take a try with the following workaround:

1. Add a <Embed> web part in your SP Site Page.

2. Set the "Website address or embed code" box to following:

<iframe width="1200" height="800" src="https://apps.powerapps.com/play/4af8a6f8-8fd8-4064-8e8f-d3b8d3ee1c74?tenantId=9e51064f-xxxx-41a2-xxxx-9785a9d6c706&GroupId=57efb8ae-2d32-4b04-807c-73550848af7b&source=website&screenColor=rgba(165,34,55,1)" allow="geolocation; microphone; camera"></iframe>

Note: The 'https://apps.powerapps.com/play/4af8a6f8-8fd8-4064-8e8f-d3b8d3ee1c74?tenantId=9e51064f-xxxx-41a2-xxx...' represents the web url of your canvas app. The '57efb8ae-2d32-4b04-807c-73550848af7b' represents the Group Id of the specific group.

More details about embedding canvas app into a Site Page, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/embed-apps-dev#embed-your-app-in-a-webs...

You could find the web url of your canvas app as below:

The App's configuration as below:

Please take a try with above solution, check if the issue is solved.

Best regards,

[JimmyWork]

@v-xida-msft This works perfect

I just hope Microsoft updates the People picker webpart to auto populate and display from groups. But for now the soltuoin you provided us awesome. Thank you very much for this.

I also found this, currenlty it does not support displaying memebrs from groups inside a sharepoint group but it works exactly as i want if you have the users in the sharepoint group.

https://gitlab.lsonline.fr/SharePoint/sp-dev-fx-webparts/group-people/-/releases