cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Filter Gallery based of a column value

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.

17 REPLIES 17
Highlighted

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
Highlighted

there was no item shown on gallery

Highlighted
Skilled Sharer
Skilled Sharer

Hi @ramielm

 

If your status column is Choice type, then please use below formula in items properties of gallery:-

 

Filter(listname,Status.Value="completed")

 

Thanks,

Prashant

 

Please mark this solution if it fulfill your requirement

Highlighted

See attached screenshot. Where do I have to add the Filter command?

Highlighted

@ramielm 

 

Use - 

 

Filter(testing,StartsWith(Title,"test 1") && (Status.Value="one"))

 

Highlighted

Highlighted

@ramielm

 

SortByColumns(Filter(testing,StartsWith(Refrence,txtSearchField.Text) && (Status.Value="one")),"Title",Ascending)

 

Above formula is working at my end, you just needs to change the DSN and fields.

 

View solution in original post

Highlighted

@panand99 

 

Perfect. Thanks

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,322)