Sort and Filter gallery with Search

(0) Share

Report

Posted on by StaceyGriffeth

I have a gallery with a Sharepoint List data source. There is a search box for the gallery, as well. The gallery Items property is currently set to the following and works perfectly:

SortByColumns(Search([@'Employee Onboarding'], SearchInput1_1.Text, "Title", "Title"),"Title")

I have a column in my Sharepoint List called 'OnboardingComplete' with values of "Yes" and "No". I want to filter the gallery to only show records where 'OnboardingComplete' is "No". I'm struggling with how to incorporate this filter into the current Items property. I tried the following and it did not work:

SortByColumns(Filter([@'Employee Onboarding'], 'OnboardingComplete' = "No"), ([@'Employee Onboarding'], SearchInput1_1.Text, "Title", "Title"),"Title")

I appreciate any suggestions!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

cchannon 4,702 Moderator on at

Like (0)

Report
Copy link

Link copied!
PowerFx supports arbitrary nesting; you just have to make sure you're not breaking your old syntax as you go and your change to Filter broke your previous Search. Try this instead:

Filter(SortByColumns(Search([@'Employee Onboarding'], SearchInput1_1.Text, "Title", "Title"),"Title"), 'OnboardingCOmplete' = 'No')

Was this reply helpful? Yes No
StaceyGriffeth 76 on at

Like (1)

Report
Copy link

Link copied!

@cchannon That did it! Thanks so much!

Was this reply helpful? Yes No