Unanswered

Get distinct values from multi-select combobox Sharepint field

(0) Share

Report

Posted on by Florida712

Hi,
I have a multi-select combo-box that saves into a column from a Sharepoint list record delimited by comma (This is for visitor management).

Possible entries for the column "Location" are e.g.

Location 1,
Location 1, Location 3, Location 5,
Location 3, Location 6

On a different screen I would now like to have a combo-box with items = the distinct items present in the column "Location", i.e.

Location 1,
Location 3,
Location 5,
Location 6,

I tried DISTINCT, but that gets me the "original" entries as each entry is distinctly different, which is what I would expect.
I tried to work with Split and Concat but get into issues with Record vs Text vs Table. How can I take all te entries, split them up into their components and then run a distinct over them?

Any help is appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Ami K 15,674 Super User 2024 Season 1 on at

Like (1)

Report
@Florida712 -

If the Location field is a multi-select choice column, try:

Distinct( ForAll( Ungroup( ForAll( 'Your SharePoint List', Split( Concat( Location, Value, "," //replace with your delimiter ), "," //replace with your delimiter ) ), "Value" ), Trim(Value) ), Value )

If the Location field is a Single Line Text column (with "," as the delimiter), try:

Distinct( ForAll( Ungroup( ForAll( 'Your SharePoint List', Split( Location, "," //replace with your delimiter ) ), "Value" ), Trim(Value) ), Value )

Was this reply helpful? Yes No
Florida712 78 on at

Like (0)

Report

Thank you @Amik , this worked like a charm. I had not used Ungroup before.

Was this reply helpful? Yes No