Answered

Gallery Filter

(0) Share

Report

Posted on by Robert2

Sorry if this is a stupid question. I'm just starting to play with PowerApps and I want to only show records in my gallery that have the answer No in the column SaleRepApproved. The app created itself and gave the coding below.

SortByColumns(Filter('Sales Hand off', StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

I've tried editing it a bunch of different ways and no such luck

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

timl 36,785 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Robert2

Assuming that SaleRepApproved is a text field, the following modification should work:

SortByColumns(Filter('Sales Hand off', SaleRepApproved="No"),
"Title",
If(SortDescending1, Descending, Ascending)
)

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @Robert2

Can you try to use the below expression to embed both the conditions if the SharePoint column is a single line text field:

SortByColumns(Filter('Sales Hand off', StartsWith(Title, TextSearchBox1.Text) && SaleRepApproved = "No"), "Title", If(SortDescending1, Descending, Ascending))

If this field is a Yes/No type sharepoint column then you can try out the below expression:

SortByColumns(Filter('Sales Hand off', StartsWith(Title, TextSearchBox1.Text) && SaleRepApproved = "false"), "Title", If(SortDescending1, Descending, Ascending))

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Robert2 5 on at

Like (0)

Report
Copy link

Link copied!

That worked perfectly!

It was a yes/no field. I pasted that into the fx bar and it did exactly what I was hoping for.

Thank you.

Was this reply helpful? Yes No