How to combine filter and search function，I have a gallary filertered by a search box. Now i would like to add three checkbox for STATUS (PENDING ,ACTIVE and Closed ) to filter the gallery. How can i combine these two function together？ Thanks

(0) Share

Report

Posted on by GUOGUO

389

Dear all

I have a gallary filertered by a search box. Now i would like to add three checkbox for STATUS (PENDING ,ACTIVE and Closed ) to filter the gallery. How can i combine these two function together？ Thanks

the current code for the search box

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Re: How to combine filter and search function，I have a gallary filertered by a search box. Now i would like to add three checkbox for STATUS (PENDING ,ACTIVE and Closed ) to filter the gallery. How can i combine these two function together？ Thanks

Hi @GUOGUO,

Do you want to filter the Gallery based on the search result?

Could you please share a bit more about your scenario?

I am confused that since you want to filter Gallery based on Status checkbox, why there is a STATUS field in your Search() function? Also, you have added a text field to save the status value, why you reference to the STATUS column within your Sort() function?

If you write this function within your Teams app, I think you should use the If() function to define the checkbox checked value.

Actually, you could directly add the Filter() function outside of the Search() function as below:

Sort(Filter(<Search_Formula>,STATUSVALUE=If(Checkbox1.Checked,"Pending",If(Checkbox2.Checked,"Active",If(Checkbox3.Checked,"Closed")))),STATUS.Value,Descending)

Was this reply helpful? Yes No