Unanswered

Filter gallery by choice

(0) Share

Report

Posted on by EMA03356

221

Hello, I have an app gallery going. I'd like to maintain the code I have here. How do I add a filter in the code to show only the entries with the status, "requested".

SortByColumns(Filter([@'Issues Log'], StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Mike2500 1,247 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
I assume you want to combine the filters, so items that start with the text in the text box and also have a status of requested?

SortByColumns(Filter([@'Issues Log'], StartsWith(Title, TextSearchBox1.Text) && Status.Value="Requested"), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

The && means "and". The .value is needed for choice columns.

Was this reply helpful? Yes No
EMA03356 221 on at

Like (0)

Report
Copy link

Link copied!

Yes, but with that code I get this error.

Was this reply helpful? Yes No
Mike2500 1,247 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Your source is a sharepoint list, and the status column is a single-select choice field?

Was this reply helpful? Yes No
EMA03356 221 on at

Like (0)

Report
Copy link

Link copied!

Yes

Was this reply helpful? Yes No
Mike2500 1,247 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Please post your updated code. I tested what I provided above and it is working with no issues.

Was this reply helpful? Yes No
EMA03356 221 on at

Like (0)

Report
Copy link

Link copied!

SortByColumns(Filter([@'Issues Log'], StartsWith(Title, TextSearchBox1.Text) && IssueStatus.Value="Requested"), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

Was this reply helpful? Yes No
Mike2500 1,247 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I copied and pasted your code and it's working fine in my environment. When you look at the formula, where specifically is the run underline showing up?

Was this reply helpful? Yes No
EMA03356 221 on at

Like (0)

Report
Copy link

Link copied!

Under the IssueStatus.Value=

Was this reply helpful? Yes No