Sorting gallery by choice column

(1) Share

Report

Posted on by Amber_L

181

I have a screen with three galleries, each filtered to show items based on stage.

Each gallery has the following on the items property:

Filter(

'Manufacturing Pack Planner',

Stage.Value = "To Do",

'SearchBar (CFR)_1'.Text in Title || 'SearchBar (CFR)_1'.Text in Suite.Value || 'SearchBar (CFR)_1'.Text in Details

)

I have another column for each item that determines the priority of the task (high, medium and low). How can I sort my galleries so that they show in order of high priority at the top and then medium and then low?

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Michael E. Gernaey 53,932 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Amber_L

If you wanted to make it super easy on yourself, you would have another Column, and assign priority by Number

So High = 1

Medium = 2

Low =3

Then wrap your Filter in the Sort

SortByColumns Filter( 'Manufacturing Pack Planner', Stage.Value = "To Do", 'SearchBar (CFR)_1'.Text in Title || 'SearchBar (CFR)_1'.Text in Suite.Value || 'SearchBar (CFR)_1'.Text in Details ), NumericPriorityColumn, SortOrder.Ascending );

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
Verified answer

rzaneti 4,395 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @Amber_L ,

Another way to solve this problem is to create the column inside your gallery:

Sort( AddColumns( [your filter expression here], order, Switch(Priority, "High", 1, "Medium", 2, "Low", 3) ), order, SortOrder.Ascending )

Just add your current expression into the [your filter expression here] 🙂

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/
https://www.linkedin.com/in/raphael-haus-zaneti/

Was this reply helpful? Yes No
Amber_L 181 on at

Like (1)

Report
Copy link

Link copied!

This worked perfectly, thank you!

Was this reply helpful? Yes No