Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

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

Posted on by 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!
  • Nandit Profile Picture
    Nandit 1,530 on at
    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 Profile Picture
    Nandit 1,530 on at
    Power automate concatenation of a Choice field into a string field, for each Row
     
    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!
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,685

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,750

Leaderboard