web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter browsegallery u...

Power Apps

Answered

Filter browsegallery using checkbox

(0) Share

Report

Report

Posted on by jdeitell

41

Have been trying to find this in the forum but haven't quite found the exact solution, so apologies if this is a common question.

I have a browsegallery which is set up to display Items using the following function:

SortByColumns(Filter([@'List Name'], StartsWith(Title, TextSearchBox1_1.Text)), "Priority", SortOrder.Ascending, "Title", SortOrder.Ascending)

I have added a checkbox called New and would like, when the box is checked, to only show titles that have the text "(New)" in a column called 'New'.

Could anyone please help me nest that checkbox filter within the existing browsegallery Items function?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

v-jefferni on at

Like (0)

Report
Hi @jdeitell ,

Please try below formula:

SortByColumns(Filter(Search([@'List Name'], If(CheckBoxNew.Value, "New", ""), "New"), StartsWith(Title, TextSearchBox1_1.Text)), "Priority", SortOrder.Ascending, "Title", SortOrder.Ascending)

Best regards,

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,059 Most Valuable Professional on at

Like (0)

Report
Hi @jdeitell

Firstly I suggest you rename your checkbox to something other than the field name as this can cause Ambiguity - I have given an example below as ckNew

SortByColumns( Filter( [@'List Name'], StartsWith( Title, TextSearchBox1_1.Text ) && ( !ckNew.Value || New = "(New)" ) ), "Priority", SortOrder.Ascending, "Title", SortOrder.Ascending )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No

Join the conversation