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

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
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

Was this reply helpful? Yes No
Verified answer

Sara Freitas 70 on at

Like (0)

Report

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

Sort(Filter(WorkCenter, ProjectGrp = true), WrkCtr, Ascending or Descending)

Was this reply helpful? Yes No
RJF61 1,265 on at

Like (0)

Report

@sfreitas thank you

Was this reply helpful? Yes No