I'm having a bit of trouble filtering a gallery for on of my apps. Basically, I have a dropdown with names that already filters my gallery. But I also want to filter with an other condition coming from a SharePoint list that I have trouble coding. In my app, every name is linked with tasks and each tasks with 7 prerequisites (just yes or no conditions). Maybe you guessed it, I want to add another filter that allows me to display only the tasks in my gallery when at least 1 of the prequisites has not been met.
I tried with "and" and "or" but I cannot make it work.
Does someone has an idea on how to do this?
Solved! Go to Solution.
Hi @Devildez ,
Could you please share more details about the Filter formula you used in your app?
Does these 7 prerequisites represents 7 individual Yes/No type column in your SP List?
I suppose that these 7 prerequisites represents 7 individual Yes/No type column in your SP List, and you want to display only the tasks in your gallery when at least 1 of the prequisites has not been met (PrerequisiteColumn set to No), is it true?
I have made a test on my side, please consider take a try with the following Filter formula:
Filter( 'YourSPList', NameColumn = Dropdown1.Selected.Value, PrerequisiteColumn1 = false || PrerequisiteColumn2 = false || PrerequisiteColumn3 = false || PrerequisiteColumn4 = false || PrerequisiteColumn5 = false || PrerequisiteColumn6 = false || PrerequisiteColumn7 = false )
Filter( 'YourSPList', NameColumn = Dropdown1.Selected.Value, PrerequisiteColumn1 = 0 || PrerequisiteColumn2 = 0 || PrerequisiteColumn3 = 0 || PrerequisiteColumn4 = 0 || PrerequisiteColumn5 = 0 || PrerequisiteColumn6 = 0 || PrerequisiteColumn7 = 0 )
Please consider take a try with above solution, then check if the issue is solved.
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