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

(0) Share

Report

Posted on by CU04021832-1

171

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:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

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
Nandit 1,568 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

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

Kind regards,
Nandit

Was this reply helpful? Yes No