Filter PowerApp Gallery if a user exists in Azure AD Group

[muzzamal]

Is it possible to filter a gallery in Power App based on the Azure AD security goup? I am currently using email addresses stored in sharepoint list column to filter the gallery. Now, I want to filter the gallery based on Ad group. How should it work? Sharepoint list name is Orders. List column that stores email addresses is called Approvers. I can store the group names or group IDs in the approvers column. If the current user exists in AD Group A, it should filter the orders where AD group A is stored for orders. If the current user exists in AD Group B, it should filter the data where AD Group B is stored for orders.

I have already assigned different screens based on the groups but unable to get an idea of how the gallery should be filtered based on the groups.

This checks if the user exists in a specific group and return true or false. If true it takes the user to a specific view otherwise the standard view.

Set(varGlobalUser,AzureAD.GetUser(User().Email).userPrincipalName); Set(varMemberAzureADGroup,!IsEmpty(AzureAD.CheckMemberGroupsV2(varGlobalUser,["AD group ID"]).value));

But couldn't build logic to apply on the power app gallery.

Thanks in advance

[JohnM86]

Can you try : Filter(Orders, If(IsEmpty(AllowedApproversGroups), true, AllowedApproversGroups in Split(Lower(User().Groups), ";")))

[JohnM86]

Filter(Orders, If(IsEmpty(AllowedApproversGroups), true, AllowedApproversGroups in Split(User().Groups, ";")))

[muzzamal]

no luck ... same issue 😞 

[JohnM86]

Add this to your on visible:

ClearCollect( GroupCollection, Office365Groups.ListGroups().value )

This expression uses the ClearCollect function to create a new collection called GroupCollection and populate it with the results of the ListGroups function from the Office365Groups connector. The ListGroups function returns an array of all the Office 365 groups that the current user has access to, and the .value property is used to extract just the array of groups from the response object.

Once this expression is executed, the GroupCollection collection should contain all the Office 365 groups, which you can then use in your app as needed.

then on the items of your gallery add: 

Filter( MyGalleryDataSource, GroupIdColumn = First(GroupCollection).id )

In this expression, MyGalleryDataSource should be replaced with the name of your data source for the gallery, and GroupIdColumn should be replaced with the name of the column in your data source that contains the group ID.

The First(GroupCollection).id expression retrieves the ID of the first group in the GroupCollection collection. If you want to filter based on a different group in the collection, you can modify this expression accordingly.

Once this expression is applied to the Items property of your gallery, it should only show items from the data source that have a GroupIdColumn that matches the ID of the selected group in the GroupCollection collection.

[JohnM86]

to filter on a specific group - you can use something like:

Filter( MyGalleryDataSource, GroupIdColumn = "groupid" ) where "grouped" is in this format : bb3fee9e-4b14-46ec-8a01-a90ef100e8c6. make sure to change the name of your datasource and groupidcolumn to the corresponding table/columns

[JohnM86]