web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to combine filter ...

Power Apps

Answered

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

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 Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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

Join the conversation