Answered

Filter gallery search results

(0) Share

Report

Posted on by JPiercefield

Hello,

I have an app connected to a sharepoint list. I would like to filter search results in a gallery based on a specific field being empty. I want to show ONLY search results that do not have a value in that field. I've tried numerous IF ISBLANK tutorials I've seen online but most are wanting the opposite outcome.

SortByColumns(Filter([@'Driver Check-In'], StartsWith('Driver Name', TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

Thanks.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@JPiercefield

Keep in mind that searching for Blanks is not delegable. So, if your list exceeds record limits of your app, then data could be missing.

However, you would put such a thing directly in your current formula:

SortByColumns( Filter('Driver Check-In', StartsWith('Driver Name', TextSearchBox1.Text) && IsBlank(yourColumnOfInterest) ), "Title", If(SortDescending1, Descending, Ascending) )

I hope this is helpful for you.
JPiercefield 85 on at

Like
a
(1)

Report
Copy link

Link copied!

Phenomenal, I was severely overthinking this.

Thank you!
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@JPiercefield

Number one rule in PowerApps - Keep It Super Simple!! 😁