Filter Gallery based of a column value

(0) Share

Report

Posted on by ramielm

Hello,

I'm a beginner in PowerApps. Id like to know how to filter my gallery based of a value in a column.

The column I created (Status) has 3 options - I only need to show in the gallery values that is not equal to "Completed"

Hoping for you help. Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (1)

Sort by

PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Try something like this:

Filter(SPList, Status = "Completed")

Or Status.Result or Status.Value

Let me know if it doesnt work.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com

Was this reply helpful? Yes No
ramielm 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Where to I have to put the filter command?

Was this reply helpful? Yes No
ramielm 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Completed is still included in the gallery.

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

This should be the Items property of the gallery?

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ramielm ,

Do you want to filter your Gallery Items where Status column is not equal to "Completed"?

I have made a test on my side, please consider take a try with the following workaround:

Set the Items property of the Gallery to following:

Filter('YourSPList', Status.Value <> "Completed")

Please consider take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
ramielm 21 on at

Like
a
(0)

Report
Copy link

Link copied!

It's not working

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @ramielm ,

Could you please share a bit more about the "Status" column in your SP List? Is it a Text type column or Choice type column?

Could you please share a bit more about your data source? Is it a SP List or a CDS Entity?

1. If the "Status" column is a Text type column in your SP List, please set the Items property of the Gallery to following:

Filter('YourSPList', Status <> "Completed")

or

Filter('YourSPList', Not(Status = "Completed"))

2. If the Status column is a Option Set type column in your CDS Entity, please consider modify above filter formula as below:

Filter('CDS Entity', Not(Status = [@OptionSetName].Completed)) // OptionSetName represents the Option Set your "Status" column related to within your CDS Entity

or

Filter('CDS Entity', Status <> [@OptionSetName].Completed)

If the OptionSetName the "Status" column related to is "Status", please modify above formula as below:

Filter('CDS Entity', Not(Status = [@Status].Completed))
Filter('CDS Entity', Status <> [@Status].Completed)

Please consider take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
ramielm 21 on at

Like
a
(0)

Report
Copy link

Link copied!

The List is named "Maintenance Request"
The column name is "Status" and type is "Choice"

Gallery should only show entry/records that status is not equal to "Completed"

Was this reply helpful? Yes No
ramielm 21 on at

Like
a
(0)

Report
Copy link

Link copied!

Anybody?

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Do you get any errors with the above suggested expressions?

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit Bhatia
https://thepoweraddict.com

Was this reply helpful? Yes No