Answered

Converting column of text values to single multi-select choice

(0) Share

Report

Posted on by HelloThereAll

My challenge is a peculiar one: I have a collection with a column of string values. I would like to convert each of the string values to choices, and combine all the choices into one multi-select choice.

Visual Example:

ColOne	ColTwo
X	"ChoiceA"
Y	"ChoiceB"
Z	"ChoiceA"

I would like to combine them and convert them into a single choice of ["ChoiceA", "ChoiceB"] that would go into another field. This is part of a larger command to do a multiple-select lookup on one field, and then auto-populate a choice field with the respect to the table above. In other words, if I select "X","Y" and "Z" for the lookup field, the choice field should have ["ChoiceA","ChoiceB"] as the selection.

I'm still new to PowerApps, and I apologize if I haven't explained this completely clearly and correctly.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @HelloThereAll :
First of all,If you just want users to freely choose "ChoiceA" or "ChoiceB" according to the collection you provide.Just try:
Add a combo box and set it's items property to:

Distinct(yourcollecton,ColTwo)

Secondly,If my understanding is incorrect.Could you provide a more specific description.
Best Regards,
Bof
HelloThereAll 82 on at

Like
a
(0)

Report
Copy link

Link copied!

Not the available options, the selected ones. What would be entered into the list entry would be ["Choice1","Choice2"].

ListCol1 ListCol2
[X,Y,Z] ["Choice1","Choice2"]
HelloThereAll 82 on at

Like
a
(0)

Report
Copy link

Link copied!

I changed the title of this thread to hopefully be more clear.
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @HelloThereAll :
Do you want to get a table like this?
Please try this code:
Table( { ListCol1: "[" & Concat( Distinct( yourcollecton, ColOne ), Result, "," ) & "]", ListCol2: "[" & Concat( Distinct( yourcollecton, ColTwo ), Result, "," ) & "]" } )
Best Regards,
Bof