Unanswered

Multiple filters for Gallery objects

(0) Share

Report

Posted on by TheresaPapanton

I have a gallery that I want to filter which is a list in sharepoint. I want to filter it based on if any value in a collection called adgroups matches any value in the sharepoint column called 'Shared With' (which is a people and groups column) then display that row from the sharepoint list.

Breaking it down further. I have list in sharepoint called Power BI Permissions:

Dashboard Name | Shared With

Dashboard 1 | DBAdmin, IDdev, RAadmin

Dashboard 2 | IDdev, RAadmin

Dashboard 3 | DBAdmin, SASteam

I have a collection called adgroups:

Value
DBAdmin

SASteam

ITMgrs

How do I filter the sharepoint list above to only display the dashboards that have any of the items in the adgroups collection

Example Gallery:

Dashboard 1 -> because DBAdmin is in shared with column

Dashboard 3 -> because DBAdmin and SASteam

I have been trying with the FIlter and using column in column but it wont let me and gives me errors with Table

Filter('Power BI Permissions', adgroups.Value in 'Shared With').Dashboard

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

WarrenBelz 156,768 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@TheresaPapanton ,

Free-typed and I cannot test it, but I think this is the direction you need to head with a collection

Clear(colMatch); ForAll( adGroups As aValue, Collect( colMatch, Filter( 'Power BI Permissions', aValue.Value in 'Shared With' ).Dashboard ) )

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!

@WarrenBelz so I had to modify your script slightly, and this is what gives no errors:
Clear(colMatch);
ForAll(adgroups As aValue, Collect(colMatch,Filter('Power BI Permissions', aValue.Value in 'Shared With'.DisplayName).Dashboard))

However I am having some issues filtering the gallery objects to Display the Dashboards then the 2nd gallery to display the Title that each dashboard has under it.

Title | Dashboard | Shared With | Link to Report
Astrea Test Report | Astrea Analysis | DBAdmin, Jane Doe, Jon Doe | www.google.com/url
Astrea Demo Report | Astrea Analysis | DBAdmin, Jane Doe, Jon Doe | www.google.com/url2
Support Test Report | Support Analysis | Jane Doe, Jon Doe, Tom Doe | www.google.com/url3
IT Test Report | IT Analysis | DBAdmin | www.google.com/url4

so if Tom Doe is apart of DBAdmin group

Astrea Analysis
- Astrea Test Report
- Astrea Demo Report

Support Analysis
- Support Test Report

IT Analysis:
- IT Test Support

and when you click the name it goes to the link off the sharepoint list.
WarrenBelz 156,768 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@TheresaPapanton ,

Have you looked in colMatch to see what is in it? Also If you have a Person field there, try

ForAll( adgroups As aValue, Collect( colMatch, Filter( AddColumns( 'Power BI Permissions', "SharedWith", 'Shared With'.DisplayName ), aValue.Value in SharedWith ).Dashboard ) )

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.
WarrenBelz 156,768 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @TheresaPapanton ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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!

@WarrenBelz i was able to piece together something a little different to help get what I was looking for