Answered

Getting Text Values from Multi Select Lookup Field

(0) Share

Report

Posted on by golfnutt82

1,360

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.

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".

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (1)

Pstork1 68,717 Most Valuable Professional on at

Like (1)

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

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

Was this reply helpful? Yes No
golfnutt82 1,360 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
golfnutt82 1,360 on at

Like (0)

Report

Still only getting one value from the lookup

Was this reply helpful? Yes No
golfnutt82 1,360 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
golfnutt82 1,360 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
golfnutt82 1,360 on at

Like (0)

Report

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.

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.

Was this reply helpful? Yes No
Verified answer

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No