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 @Anonymous ,
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.
Check out new user group experience and if you are a leader please create your group
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Don't miss the call this month on June 16th - 8a PDT