Answered

Power automate concatenation of a Choice field into a string field, for each Row

(0) Share

Report

Posted on by CedarTree72

153

Hello. I have a Sharepoint list that has a Choice field (say the user can choose any number of favorite colors). Once an hour (or day), I'm looking to Power Automate the following:

For Row #1 (Person A), they have chosen Blue and Green -- this should concatenate into a Multiline string field (b/c Len might be more than 255) as "Blue; Green"
For Row #2 (Person B), they have chosen Red and Yellow -- this should concatenate into a Multiline string field (b/c Len might be more than 255) as "Red; Yellow"
Etc.

Thanks!

Categories:

General Questions

All responses (4)

Answers (2)

Suggested answer

Nandit 1,563 Super User 2025 Season 1 on at

Like (0)

Report

Power automate concatenation of a Choice field into a string field, for each Row

Hi CedarTree72,

Here's how you can achieve this:

1. Initialise a Variable of type string: varValues

2. Add For Each with body/value as output from previous step

3. Add "Append to string Variable", add the variable you initialised, and value of your column from SP with ; at the end or this expression instead: @{item()?['Value']};

4. Add compose action outside of this loop, with varValues as Inputs

5. Add "Update file properties" action and add Compose outputs as the input for your string column

6. Lastly, set the variable to null.

Here's how it looks:

Initialise

Append

Compose

Populate field

Set to null

Final result:

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!
Verified answer

CedarTree72 153 on at

Like (0)

Report

Power automate concatenation of a Choice field into a string field, for each Row

I reposted here: https://community.powerplatform.com/forums/thread/details/?threadid=14b78c8e-cb8b-ef11-ac21-7c1e520da679
Thanks.
Verified answer

mmbr1606 11,991 Super User 2025 Season 1 on at

Like (0)

Report

Power automate concatenation of a Choice field into a string field, for each Row

please open a topic in the power automate section to be found here:

Microsoft Power Platform Community Forum Thread

thanks
CedarTree72 153 on at

Like (0)

Report

Power automate concatenation of a Choice field into a string field, for each Row

Any suggestions here would be greatly appreciated. Thanks!