Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Concatenate column values - new designer

(1) ShareShare
ReportReport
Posted on by 6

Hi All,

 

I'm trying to concatenate a multi-choice list column so I can add it to a HTML table. I've found plenty of examples using the classic designer, but none using the new designer, and I can't figure it out.

 

Most of the flow (screenshot below) should be self explanatory, but the 'for each ' loop was automatically created. I found an example that used a 'select' component to get all items from the particular row of the table, then use a 'join' later (not yet included in mine) to concatentate them.

 

In my case, the automatically created 'for each' loop fails.

 

Here's the flow, and the error I get.

So far, the flow work except for the 'For Each' loop below.

 

___G____2-1720420203004.png

 

For what it's worth, the select (that I created) was intended to extract the values from the 'Assigned' column.

___G____1-1720420196409.png

 

Additionally, when I tried to just add the 'assigned' column to the 'Create HTML Table' component, then it added it to a 'for each' loop just like the 'Select' component above - but this also failed.

 

Any help would be greatly appreciated. 

 

 

  • __G__ Profile Picture
    2 on at
    Re: Concatenate column values - new designer

    Hi, Unfortunately that didn't work either (same result).

     

    I've decided to make the 'Assigned' column no longer multiple select. It's less than ideal, but it will have to do.

  • CFernandes Profile Picture
    8,295 Most Valuable Professional on at
    Re: Concatenate column values - new designer

    @___G___ - Hey Mate, looking at the results it seems that it returns "null" always and evaluates for true. I need to test but not Infront of computer so typing from mobile, perhaps using empty()

     

    if(empty(item()?['Value']),'-',item()?['Value'])

     

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

     

    P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

  • ___G___ Profile Picture
    6 on at
    Re: Concatenate column values - new designer

    bump

  • ___G___ Profile Picture
    6 on at
    Re: Concatenate column values - new designer

    There are some blank (null) values in my table, but those are filtered out in the 'Get List Item' component - so the resulting data object has one or more values in all cases.

     

    I tried the error handling option, and initially it still wanted to put it in a 'for each' loop, but I dragged it out and deleted the loop - this time it didn't error when I did that.

     

    Here's my modified error handling function: 

    if(equals(item()?['Value'], null),'-',item()?['Value'])

     

    It still didn't work, but the result was different. This time, the finished table looked like this:

    ___G____0-1720433970583.png

     

    In case it helps, this is what the output JSON looks like from the original query:

    ___G____1-1720434033017.png

     

     

  • CFernandes Profile Picture
    8,295 Most Valuable Professional on at
    Re: Concatenate column values - new designer

    Hey @___G___ -

     

    I did not get the apply to each loop on choice column, for the select action

     

    You maybe you can use error handling.

     

    if(equals(item()?['Test'], null),'somedummyvalue',item()?['Test'])

     

    CFernandes_0-1720428543096.png

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

     

    P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

     

  • CFernandes Profile Picture
    8,295 Most Valuable Professional on at
    Re: Concatenate column values - new designer

    @___G___ - Do you have empty values for the Choice column for SharePoint? I see its not required column

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

     

    P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

  • ___G___ Profile Picture
    6 on at
    Re: Concatenate column values - new designer

    Thanks for the respose.

    My "Assigned To" column is a Choice datatype with "Allow multiple selection" enabled (see image below). I suspect this is why it adds a 'for loop'.

    I tried changing the 'select' component to use the Key Value pair as you suggested, but it automatically added the for loop again.

    ___G____0-1720426439677.png

     

     

    Here is the formatting for my 'Assigned To' column in case it helps.

    ___G____1-1720426461678.png

     

     

  • CFernandes Profile Picture
    8,295 Most Valuable Professional on at
    Re: Concatenate column values - new designer

    @___G___ - Your select does not look correct. It should have a key value pair and it should not have a loop(screenshot below).

     

    CFernandes_0-1720421985489.png

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

     

    P.S. take a look at my blog here and like & subscribe to my YouTube Channel 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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492