Answered

comma separated column to one value per row

(0) Share

Report

Posted on by asdfasdfasfdasf

I'm having a dataverse table with a column "countries" (a single line of text column). People can add multiple countries as comma separated values in this column.

I would like to show all distinct countries from the "countries" column and use those in a combobox for filtering. I can't figure out how to create a table/list of the distinct countries from the "countries" column and would appreciate any hints.

Best regards

Markus

edit: changed "single row text column" to "single line of text column"

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@asdfasdfasfdasf Use the following example and replace the countries string with the value from your countries column,

Distinct(Split("UK, USA, India, Australia, UK, Tanzania, Romanina, India", ","), Value)

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@asdfasdfasfdasf Did you get it to work???

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
asdfasdfasfdasf 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear CNT

Thanks for your reply.

I'm able to split a single string value. I wonder how I can do this with the whole column of a table.

Best regards
Markus

Was this reply helpful? Yes No
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@asdfasdfasfdasf Follow this example and replace myTable with your table.

ClearCollect(myTable, {Countries:"UK, USA, India, Australia, UK, Tanzania, Romanina, India"}, {Countries:"Poland, Argentina, Maldives, Denmark, UK, Poland, Romanina, Denmark"}); ClearCollect(colSplit, Distinct(Ungroup(ForAll(myTable, Split(ThisRecord.Countries, ",")), "Value"), Value))

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
asdfasdfasfdasf 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear CNT

Thanks again for your reply.

I'm struggling with the string values in your formula. How can I replace those with the column from my table?

Best regards
Markus

Was this reply helpful? Yes No
asdfasdfasfdasf 15 on at

Like
a
(0)

Report
Copy link

Link copied!

got it to work

Was this reply helpful? Yes No
asdfasdfasfdasf 15 on at

Like
a
(0)

Report
Copy link

Link copied!

The actual formula I used is:

ClearCollect(myTable, dataversetable.columnname);
ClearCollect(colSplit, Distinct(Ungroup(ForAll(myTable, Split(ThisRecord.columnname, ",")), "Value"), Value))

dataversetable is the name of the dataversetable
columnname is the name of the column
myTable and colSplit can be anything

Was this reply helpful? Yes No