Filter and sort gallery based on Priority value like "High, Medium, Low"

(0) Share

Report

Posted on by powerappsrooki

Hello,

I want to filter and sort the data based on Priority value like High medium and low.

Currently I am able to sort the data ascending using below code.

My code is - SortByColumns(Filter('Test SharePoint list', 'Approval Status'. Value = "Pending" Or 'Approval Status'. Value = "New Request" Or 'Approval Status'. Value = "Rejected"), " Request Priority ", Ascending, "ID", Ascending)

Please can you help on this.

Thanks!!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!
SortByColumns( Filter('Test SharePoint list', 'Request Priority'. Value = "High" Or 'Request Priority'. Value = "Medium" Or 'Request Priority'. Value = "Low"), "Request Priority", Ascending, "ID", Ascending )

Was this reply helpful? Yes No
powerappsrooki 12 on at

Like (0)

Report
Copy link

Link copied!

Nope it is not working, I want to Sort the data based on priority. Filter condition is working fine. Thanks for your prompt response.

Was this reply helpful? Yes No
timl 36,713 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @powerappsrooki

I suspect this is what you're looking for:

Sort( Filter('Test SharePoint list', 'Approval Status'. Value = "Pending" Or 'Approval Status'. Value = "New Request" Or 'Approval Status'. Value = "Rejected" ) , Switch('Request Priority', "High", 1, "Medium", 2, "Low", 3, 4) )

Was this reply helpful? Yes No
powerappsrooki 12 on at

Like (0)

Report
Copy link

Link copied!

@timl thanks for your reply . It not working as expected.
I want to sort the gallery based on Priority first as mentioned above and then by ID column. All the High priority record come on top then medium, low. After that based on ID, oldest record show on top.

Was this reply helpful? Yes No
timl 36,713 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@powerappsrooki

If you want to sort by multiple columns, this is the syntax you would use.

SortByColumns( AddColumns( Filter('Test SharePoint list', 'Approval Status'. Value = "Pending" Or 'Approval Status'. Value = "New Request" Or 'Approval Status'. Value = "Rejected" ), "PriorityValue", Switch('Request Priority', "High", 1, "Medium", 2, "Low", 3, 4) ), "PriorityValue", Ascending, "ID", Ascending )

Was this reply helpful? Yes No