Answered

Combo Box Value Sort

(0) Share

Report

Posted on by RJF61

1,265

I have a Combo Box in a gallery where the Items property is based on a separate SP list. The SP list name is WorkCenter and I am filtering where a column named ProjectGrp = true. I want to sort column WrkCtr in the Combo Box. Do I need a Filter/Sort combination?

Filter(WorkCenter, ProjectGrp = true)

Categories:

Building Power Apps

All responses (3)

Answers (2)

Sort by

Verified answer

WarrenBelz 156,725 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @RJF61 ,

It should be (assuming Ascending) - you also do not need = true for a Boolean field.

Sort( Filter( WorkCenter, ProjectGrp ), WrkCtr )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Verified answer

Sara Freitas 70 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello.
Yes, you need to combine the sort with the filter expression.

Sort(Filter(WorkCenter, ProjectGrp = true), WrkCtr, Ascending or Descending)
RJF61 1,265 on at

Like
a
(0)

Report
Copy link

Link copied!

@sfreitas thank you