Get Users Or Members From The AD Security Group In PowerApps

In this blog, we will discuss how we can get the users' information from the specific Security Group in Power Apps.

We came across a requirement wherein we need to fetch the information from AD Security Group and need to display it within Power Apps for business logic implementation.

Below is one of the Security Groups created in Microsoft 365.

Here, there are two members added to that Security Group.

In Power Apps, I need information about those two users.

Open your Power Apps Canvas App.

First, we need to add Office 365 Groups Connector. For that,

Go to View Menu, select Data sources.

Search for “Office 365 Groups”. Select the highlighted one. Add that connector in your App.

Once the Connector is added, it will look like this.

Open your Power Apps screen and add a button.

Write the following line of code for “OnSelect” event of the button.

Now, here we will store Group member information to the Power Apps collection named – “MembersfromSG”.

The function:

Office365Groups.ListGroupMembers(“Group ID”) returns the information about all the members from that security group.

Now, how can we find that Group ID for the Security Group?

There are two ways to find this.