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 it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand