Sort values in Combo box

(0) Share

Report

Posted on by Sri

559

Hi All,

I have a Combo box which gets values of a column in SharePoint. I am using a with function to get the values from SharePoint which is getting displayed properly. But the values in the Combo box are not sorted alphabetically.

The code in the item's property is:

With (
{
Items: Ungroup (
For All (
Customer Accounts,
'Account Manager'
),
"Value"
),
Distinct Email: Distinct(
Ungroup (
For All (
Customer Accounts,
'Account Manager'
),
"Value"
),
Email
)
},
Sort(
For All (
Distinct Email,
First (
Filter(
Items,
Email = Result
)
)
),
!IsBlank(DisplayName)
)
)

Any help on this would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report
Hi @Uthhra ,

I cannot get the code you posted to validate, however if you are wanting the Distinct values of the (I assume) Person field 'Account Manager' in the List CustomerAccounts, with the two fields of Item and Email, this should do and Sort as well

Sort( AddColumns( RenameColumns( GroupBy( AddColumns( CustomerAccounts, "EmailAdd", 'Account Manager'.Email, "Staff", 'Account Manager'.DisplayName ), "EmailAdd", "Data" ), "EmailAdd", "Email" ), "Item", First(Data).Staff ), Item )

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
Sri 559 on at

Like (0)

Report

Hi @WarrenBelz ,
I tried applying the above code and got error Sort has invalid arguments. Account Manager is a person or group field in SharePoint which allows multiple selections. I have a shared a screenshot of the error.

Screenshot (87).png

Screenshot (86).png

Was this reply helpful? Yes No
WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report
Hi @Uthhra ,

OK - it would have been good to mention that - try this

With( { Items: Ungroup ( ForAll ( 'Customer Accounts', 'Account Manager' ), "Value" ) }, With( { DistinctEmail: Distinct( Items, Email ) }, Sort( ForAll( DistinctEmail, LookUp( Items, Email = Result ) ), DisplayName ) ) )

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
Sri 559 on at

Like (0)

Report

Hi @WarrenBelz ,
Thanks a lot. It worked perfectly. But I am getting a Blank value at the end.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,051 Most Valuable Professional on at

Like (0)

Report
@Uthhra ,

If that really matters, do this

With( { Items: Ungroup ( ForAll ( 'Customer Accounts', 'Account Manager' ), "Value" ) }, With( { DistinctEmail: Distinct( Items, Email ) }, Sort( Filter( ForAll( DistinctEmail, LookUp( Items, Email = Result ) ), !IsBlank(DisplayName) ), DisplayName ) ) )

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
Sri 559 on at

Like (0)

Report

Hi @WarrenBelz,
It worked perfectly. Thank you so much.

Was this reply helpful? Yes No