Unanswered

Gallery View Filter and Sort

(0) Share

Report

Posted on by powersportcp

Firstly, thanks for your help.
I'm loving learning, playing and creating in PowerApps.
But sometimes, no amount of googling helps you crack what no doubt is a real basic issue.

I have a SharePoint List connected to a Canvas PowerApp.

Column 1 = Description

Column 2 = Status

I have a Gallery View with a Sort and Filter button at the top of the screen.

Gallery code is
SortByColumns(Filter([@'Sports Equipment Log'], StartsWith(Description, TextSearchBox1.Text)), "Title")

Column name Description is the list of items.
But if I change the "Title" to "Description" my gallery goes blank.

My Sort button doesn't work
SortByColumns('Sports Equipment Log',"Description",SortOrder.Ascending)

Neither does my Filter button

Filter([@'Sports Equipment Log'],Status="Available")

I've tried adding various code to the Fx box for the Gallery, but any change just seems to send the gallery blank.

Stuck. And would love some hint to unlock the issue.

THANK YOU

Categories:

Building Power Apps

I have the same question (1)

All responses (5)

Answers (1)

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (1)

Report

@powersportcp

Can you please clarify your filters etc by showing your Items property of your Gallery. You cannot simply have filter and sort buttons as they won't have an impact on the Gallery, unless they are being done to a collection or directly in the Items property of the collection.

Also, do you have any errors or red squiggles? Can you validate that its Description and the name isn't description (name versus the display name)

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
powersportcp 40 on at

Like (0)

Report

Cheers Michael, really appreciate you reaching out.
Apologies for my confusing terminology.

So, i have 2 ICONS.
And the actions attached to them have Red Circle Crosses next to them.

The 'action on select' being
SortByColumns('Sports Equipment Log',"Description",SortOrder.Ascending)
and
Filter([@'Sports Equipment Log'],Status="Available")

The Gallery itself doesn't have an error unless in the Data Items Property i change the "Title" to "Description", when it then goes blank and I get the red cross:
SortByColumns(Filter([@'Sports Equipment Log'], StartsWith(Description, TextSearchBox1.Text)), "Title")

The column name in the List Settings is shown as Description. There is no column called Title.

THANK YOU

Was this reply helpful? Yes No
Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (1)

Report

Hi @powersportcp

Please share the errors. Also, you still cannot simply have buttons with filters and sorts and it do anything. per my original message.

Again, share the code in your Galleries, Items property.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
powersportcp 40 on at

Like (0)

Report

Hi Michael, sorry I thought I'd done that.
The app was a Canvas template. It appears to be an Icon with an action for filtering. Error message below.

Gallery doesn't have an error currently, just the code as shared.

Was this reply helpful? Yes No
Verified answer

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (1)

Report

@powersportcp

The issue there is that you are trying to compare a Choice column which is a record to Text.

Try doing either
1. Text(Status) = "Available"
2. "Available" in Status
3. Status.Value = "Available"

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No