Answered

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

(0) Share

Report

Posted on by CU04021832-1

171

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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

CU04021832-1 171 on at

Like (0)

Report
Copy link

Link copied!

Any suggestions here would be greatly appreciated. Thanks!

Was this reply helpful? Yes No
Verified answer

mmbr1606 14,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Microsoft Power Platform Community Forum Thread

thanks

Was this reply helpful? Yes No
Verified answer

CU04021832-1 171 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Nandit 1,568 Moderator on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No