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 154,424 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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.

Was this reply helpful? Yes No
WarrenBelz 154,424 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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 154,424 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@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
Copy link

Link copied!

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

Was this reply helpful? Yes No