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!

All responses (2)

Answers (1)

StaceyGriffeth 76 on at

Like (1)

Report

Re: Sort and Filter gallery with Search

@cchannon That did it! Thanks so much!
Verified answer

cchannon 4,702 Super User 2025 Season 1 on at

Like (0)

Report
Re: Sort and Filter gallery with Search

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')