Answered

Combining Search with Sort and Filter Gallery Controls

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I am struggling to combine my gallery search with my existing filter and sort controls in my gallery. Here are the below formulas in the 'Item's control of the Gallery.

Sort(
 Filter('Staff Change Control System', Approved.Value="Yes", If(Toggle2.Value=false, 'Full Access'.Value="No", 'Full Access'.Value="Yes")),
 Created, Ascending
)

Search('Staff Change Control System', SearchBox.Text, "First_x0020_Name")

I'd appreciate any help.

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@timl @RandyHayes @WarrenBelz @Drrickryp @rubin_boer @Pstork1 - would really appreciate your help. Thanks guys

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@Anonymous

Give this a go:

Sort( Search( Filter('Staff Change Control System', Approved.Value="Yes", 'Full Access'.Value = If(!Toggle2.Value, "No", "Yes") ), SearchBox.Text, "First_x0020_Name" ), Created )

I hope this is helpful for you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

That worked perfectly, thanks again @RandyHayes 🙂

Was this reply helpful? Yes No