cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
golfnutt82
Super User
Super User

Getting Text Values from Multi Select Lookup Field

Hello,
Been struggling to make this work and posted this a couple times.
I am trying to get the text values of a Multi Select Lookup field and then pass those values to another field that is string type.

golfnutt82_0-1668783898279.png

golfnutt82_2-1668784252431.png

golfnutt82_3-1668784286568.png

 

 

This only grabs the first value from the Lookup.
My hope is to duplicate exactly what is in the lookup and put it in the text field "Assigned Software".

 

1 ACCEPTED SOLUTION

Accepted Solutions

The extra characters seem to be a side effect of it being a choice column.  Try the following instead. Use a Data Select to map the value you want to a simple array with no key labels.  Then us Join on the output of the select to convert that array to a string with a delimiter. 

image.png



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

11 REPLIES 11
Pstork1
Dual Super User
Dual Super User

Add the multiselect field to a Compose and then use Concat() to turn it into a string.

concat(outputs('Compose'),';')


-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Hello Mr. Pstork
Im not sure if this is correct because it seems to return the same result.

golfnutt82_0-1668795094460.png

golfnutt82_2-1668795173398.png

 

 

Unless you are trying to append multiple records together you don't need the Append to string.  Just use the concat to update the string field with the multiple values.  They will now be in a semicolon delimited string.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

golfnutt82_1-1668798895174.png

 

golfnutt82_0-1668798823510.png

Still only getting one value from the lookup

 

I can see the three values are showing in the Apply to Each 10 container

As I said, if its a multi-select field and all you want is those values are a string then you don't need to loop through the values.  concat() will take all the values and turn them into a delimited string based on the delimiter you supply.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Good morning,
Is there anything that can be done about the added special characters?
Here is what I am trying to achieve.
When a new item is created, software is chosen from the multiselect dropdown and passes those same values to a text field. When an item is modified and the LU_AssignedSoftware field is changed pass those values to another text field then somehow do a comparison between the two text fields, in an effort to determine what is changed. 
If software has been removed or added, then update the license count in the list showing those licenses for a that piece of software.
isMy objective is to 

golfnutt82_0-1669035331577.png

 

Can you show me how you are doing the concat()? That shouldn't normally add those special characters.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

WHen I attempt to use my LU_AssignedSoftware field in a compose action it automatically puts it in an Apply to Each loop. Below that loop I use your concat function.

golfnutt82_0-1669045303299.png

The concat function builds an array of items separated by a "," and each value is in "<value>" quotes
When I update the text field "AssignedSoftware" the values are displayed as previously shown.
Very frustrating that I cant just pass the output from the Lookup field to the text field. 

The extra characters seem to be a side effect of it being a choice column.  Try the following instead. Use a Data Select to map the value you want to a simple array with no key labels.  Then us Join on the output of the select to convert that array to a string with a delimiter. 

image.png



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Thank you,
I worked on this yesterday and did the following.

golfnutt82_0-1669120398663.png

The result was as follows, which gets me where I need to be.
I really appreciate your help.

golfnutt82_1-1669120455880.png

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,428)