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
)
or
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.
Best regards,
