Answered

filtering gallery textbox + checkboxes SP list

(0) Share

Report

Posted on by carltoune33

Hello,

I'm currently trying to filter a gallery (from sharepoint list) where users will be able to display what they need, then select the record to open and review.

I have a textbox to filter by business, which is working fine with the following code.

Search('ESCALATION TRACKING',Txtnamefilter.Text,"Business")

The complete gallery is displayed, and user is able to search by business text.
When i'm adding code to have the checkbox filter, the gallery contents disapear, and when check the checkbox, the record with the selected status is displayed.

Filter(Search('ESCALATION TRACKING',Txtnamefilter.Text,"Business"),NotStartedCheckbox.Value,Status.Value="Not Started")

NOTE : I only start with the checkbox "Not Started" for trials, then i will add the 3 others.

here what is displayed with the complete code

and when checking the checkbox

I'm for sure missing something, but not able to see what.

Thanks a lot for the help here.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

LaurensM 12,516 Moderator on at

Like (0)

Report
Hi @carltoune33,

You will need to change the filter slightly:

Filter( Search('ESCALATION TRACKING', Txtnamefilter.Text, "Business") //Ignore filter when not checked, else filter by Not Started , !NotStartedCheckbox.Value || Status.Value = "Not Started" )

You can extend the filter with other CheckBoxes in a similar fashion:

Filter( Search('ESCALATION TRACKING', Txtnamefilter.Text, "Business") //Ignore Not Started filter when not checked, else filter by Not Started , !NotStartedCheckbox.Value || Status.Value = "Not Started" //Ignore Second Checkbox filter when not checked, ... , !SecondCheckbox.Value || Status.Value = "Second Status" )

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!

Was this reply helpful? Yes No
carltoune33 45 on at

Like (0)

Report

@LaurensM
many thanks for the help, it is working fine as expected...
Thanks

Was this reply helpful? Yes No
carltoune33 45 on at

Like (0)

Report
Hi @LaurensM,

In addition to these filters that are working perfectly, I'm trying to filter another result, which is risk result (in a number column in the SP list) but not able to filter it.
the values stored into the SP List column are like this :
Between 1 and 4 => Broadly Acceptable
Between 5 and 9 => Moderate
Between 10 and 20 => Unacceptable

i've added 3 checkboxes

and tried the following code, but no success :

!'Broadly AcceptableCheckbox'.Value || 'Result risk' = "3"

I can't add a . here as not supported.
Goal here is to be able to filter using the 3 checkboxes.

What am I again missing in the formula?
thanks a lot

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (0)

Report
Hi @carltoune33,

Since you are using checkboxes, I assume that you can select multiple at a time to extend the filter. Selecting 'Broadly Acceptable' and 'Moderate' would result in a filter from 1 to 9.

In order to achieve this I used the filter below:
Filter( DataSource, (Checkbox1.Value && number > 0) || (Checkbox1_1.Value && number > 4) || (Checkbox1_2.Value && number > 9) || (!Checkbox1.Value && !Checkbox1_1.Value && !Checkbox1_2.Value), (Checkbox1_2.Value && number < 21) || (Checkbox1_1.Value && number < 10) || (Checkbox1.Value && number < 5) || (!Checkbox1.Value && !Checkbox1_1.Value && !Checkbox1_2.Value) )

Change the checkboxes to your specific case:
Checkbox1 = Broadly Acceptable
Checkbox1_1 = Moderate
Checkbox1_2 = Unacceptable
If you only want users to make 1 selection at a time, you might want to use a Radio Button control instead.

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!

Was this reply helpful? Yes No
carltoune33 45 on at

Like (0)

Report
@LaurensM
Thanks a lot for your reply,
unfortunetly i've tried, and it is not working.
on my hand i've tried the following way which is working
Filter( Search('ESCALATION TRACKING', Txtnamefilter.Text,"Business") // , !NotStartedCheckbox.Value || Status.Value = "Not Started" , !InProgressCheckbox.Value || Status.Value = "In Progress" , !DelayedCheckbox.Value || Status.Value = "Delayed" , !CompletedCheckbox.Value || Status.Value = "Completed" , !EscalatedCheckbox.Value || Progress.Value = "0 - Escalated" , !InvestigationCheckbox.Value || Progress.Value = "1 - Investigation" , !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 )

by the way i'm not able to do the following, regarding the checkboxes Status and Progress. I want to have the user able to click at least 2 checkboxes to have the result, but not able to perform that, do you have an idea?
When clicking 2 checkboxes at same time the gallery is empty,

When only one of the 2 checkboxes, it is working fine..

thanks for the help

Was this reply helpful? Yes No