Unanswered

Concatenate column values - new designer

(1) Share

Report

Posted on by ___G___

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.

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

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.

All responses (8)

Answers (0)

__G__ 2 on at

Like (1)

Report

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 8,295 Most Valuable Professional on at

Like (1)

Report

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___ 6 on at

Like (1)

Report

Re: Concatenate column values - new designer

bump
___G___ 6 on at

Like (1)

Report

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:

In case it helps, this is what the output JSON looks like from the original query:
CFernandes 8,295 Most Valuable Professional on at

Like (1)

Report

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'])

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 8,295 Most Valuable Professional on at

Like (1)

Report

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___ 6 on at

Like (1)

Report

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.

Here is the formatting for my 'Assigned To' column in case it helps.
CFernandes 8,295 Most Valuable Professional on at

Like (1)

Report

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).

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.