Answered

Get distinct values from multi-select combobox Sharepint field

Like (0) Share

Report

Posted on 24 Feb 2024 23:15:59 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.

All responses (2)

Answers (1)

Florida712 78 on 27 Feb 2024 at 19:16:47

Like (0)

Report

Re: Get distinct values from multi-select combobox Sharepint field

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

Ami K 15,665 Super User 2024 Season 1 on 24 Feb 2024 at 23:25:29

Like (1)

Report
Re: Get distinct values from multi-select combobox Sharepint field

@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 )