Unanswered

Filter gallery Results based on Current User and AD Groups

(0) Share

Report

Posted on by TheresaPapanton

I am making a powerapp thats filters a sharepoint list based on a "Shared With" column. Its a nested gallery where the parentDashboard gallery groups the Dashboard Categories, adnt he child gallery displays the reports associated to that dashboard but only shows the reports that the current user is part of the shared with column in sharepoint. The Shared With column is people and groups in Sharepoint, and we use with with inidividual users along with AD groups. What I am trying to do in Powerapps is Filter the list based on If the User().email is in the Shared With columns email, but also need the capability to determine if the current user is a part of any AD groups in that column as well. I got the first portion to filter based on this:

Filter('Power BI Permissions',DashboardString = ThisItem.DashboardString && User().Email in 'Shared With'.Email) How do I add the capability for searching if current user is a member of any AD groups that are listed int he Shared With Column?

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @TheresaPapanton ,

I have a blog on using Office365 Groups - this may be helpful to yo to detect membership.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
TheresaPapanton 27 on at

Like
a
(0)

Report
Copy link

Link copied!

How would I use this to see if current user is a member of any group, add groups to a collection to compare to? I cant list out by name every single group we have, so if current user is a member of a group in the shared with People and Groups column, display list items from sharepoint, else dont display list items.
WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@TheresaPapanton ,

I cannot see any way other than to list the Groups, otherwise how can you possibly to a query on the content of the Group? You cannot refer to elements (such as Groups) dynamically, so you would have to hard-code the query.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.