Is it possible to sort and filter a gallery with an if statement? There are two filters currently. One is for location, and that one filters the other one which is for Asset. I want the defualt of the gallery to show all items, but when the user selects the asset I want it to filter the items for that asset.
I have tried the following, but it errors out:
HELP!!!! Thank you.
Solved! Go to Solution.
You could try incorporating your If condition into your call to Filter like so:
Sort( Filter(Machine_Projects, Facility.Selected.Value="All" || Asset=Line.Selected.Value
), 'Date Down'
Could you confirm how the formula is not working? If the user does not select either of the filters, does your gallery show no records, or does it show more records than you expect?
With none of the filters selected, can you add a label and set the text property to the following:
Can you confirm that this resolves to true?
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.