Answered

Filter gallery based on in-app value

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hey everyone,

I am a Powershell beginner and have kind of a complicated issue that I am struggling to find anything about.

I have created status bubbles for my app that change from green -> yellow -> red based on certain specifications. I have now been asked to add filter by status color buttons in my app. I have easily created filters based on data from the sharepoint list but creating a filter based on something that is natively only in the app is a different issue.

I was helped by this forum to create my status bubbles and for reference, that can be referenced here.

My browse gallery is within a container on the browse screen and I am trying to create the filter buttons in a separate container along the top of the browse screen.

I truly have no idea how I would begin to solve this. If any more information is needed, I can surely provide it.

Thanks!

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

DavidZoon 738 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @Anonymous ,

At this point, you should consider to add a calculated column to your source, it will be easier to have the matching score for all your records

IF function - Microsoft Support

You'll have to set the calculation like : (in sharepoint)

IF([DaysUp] < 10, 1) + IF([Off], 1) + IF([Rebooted], 1)

Not sure for the syntax, a sharepoint Expert can correct if needed 🙂

Then you'll have a column with values from 0 to 3

Back in Power Apps, you can add a ComboBox with in it's .Items :

[{Name : "Green", Score:1 }, {Name : "Yellow", Score:2 }, {Name : "Red", Score:3 }]

Then you can filter on the comboBox selected value :

Filter('Your Source', 'Calculated Column Name' = ComboBox.Selected.Score || IsBlank(ComboBox.Selected.Score) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @DavidZoon,

Thanks for your response. I will ask the sharepoint list owners if we are able to add another column, that will make everything so much easier.