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

Like (0) Share

Report

Posted on 16 Oct 2024 14:33:10 by CedarTree72

153

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

For Item/Row #1 (Person A), they have chosen Blue and Green in the Choice field -- this should concatenate into a string field (multi-line b/c Len might be more than 255) as "Blue; Green"

For Item/Row #2 (Person B), they have chosen Red and Yellow in the Choice field -- this should concatenate into a string field (multi-line b/c Len might be more than 255) as "Red; Yellow"

Etc.

So, in other words, for every single row in Sharepoint, once an hour, I want to take the Choice field of favorite colors and use that to clear out and freshly populate a text field with a concatenated text.

Thanks!

Categories:

Business Process Flows

All responses (2)

Answers (0)

Nandit 1,563 Super User 2025 Season 1 on 31 Oct 2024 at 09:25:55

Like (0)

Report

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

Hi,

Following up to check if you were able to solve this issue using my suggestion?

Kind regards,
Nandit
Suggested answer

Nandit 1,563 Super User 2025 Season 1 on 17 Oct 2024 at 09:13:17

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!