Power Platform Community Forum Thread Details

Hi All,

I have a gallery which is filtered by the following things :

A texbox filter to find business.
couple of checkboxes to filter Status, Progress and Risk.

For example working fine while selecting Not Started + 0-Escalated + Moderate.

Until now this way is working fine, but i'm not able to filter for example Status Not Started + In progress together, each time it is showing blank gallery result.

Status is coming from SP List choice column, same for progress.

and for Risk it is a SP List number column

Here the code i'm currently using, but wanted to know if there is a simple way to give user opportunity to filter at same time for example the Status Not Started + In progress

Filter(
 Search('ESCALATION TRACKING',
 Txtnamefilter.Text,"Business")
 //
 , !NotStartedCheckbox.Value || Status.Value = "Not Started"
 , !InProgressCheckbox.Value || Status.Value = "In Progress"
 , !DeferredCheckbox.Value || Status.Value = "Deferred"
 , !CompletedCheckbox.Value || Status.Value = "Completed"
 , !EscalatedCheckbox.Value || Progress.Value = "0 - Escalated"
 , !InvestigationCheckbox.Value || Progress.Value = "1 - Investigation"
 , !PrototypeCheckbox.Value || Progress.Value = "2 - Prototype"
 , !ValidationCheckbox.Value || Progress.Value = "3 - Validation"
 , !ImplementationCheckbox.Value || Progress.Value = "4 - Implementation"
 , !BroadlyAcceptableCheckbox || 'Result risk' >= 1 && 'Result risk'<= 4
 , !ModerateCheckbox || 'Result risk' >= 5 && 'Result risk'<= 9
 , !UnacceptableCheckbox || 'Result risk' >= 10 && 'Result risk'<= 20

)

thanks anyone that could give a hand.

Categories:

Building Power Apps