Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Remove Double Comma from Array

(0) ShareShare
ReportReport
Posted on by 1,278 Super User 2025 Season 1

I am building an HTML table with Arrays with an Apply to All within an Apply to All.

My final output looks like this

<table>,<tr>,<td colspan=\"7\">Franklin</td>,</tr>,,
<tr>,<td>Cristhian</td>,<td></td>,<td></td>,<td></td>,<td></td>,<td></td>,<td>Sep 12 01:20 PM</td>,</tr>,,
<tr>,<td>Isaac</td>,<td>1</td>,<td>Lorem</td>,<td></td>,<td></td>,<td>Nam eget dui quis nibh maximus efficitur.</td>,<td>Sep 13 07:50 AM</td>,</tr>,,
<tr>,<td>Vivaldo</td>,<td>1</td>,<td>ipsum</td>,<td></td>,<td></td>,<td>Aliquam quis lacus lacus.</td>,<td>Sep 13 02:25 PM</td>,</tr>,,
<tr>,<td>Cristhian</td>,<td>1</td>,<td>ipsum</td>,<td></td>,<td></td>,<td>Mauris vitae urna vitae neque.</td>,<td>Sep 13 02:29 PM</td>,</tr>,,
<tr>,<td>Nicole</td>,<td>1</td>,<td>Lorem</td>,<td></td>,<td></td>,<td>Quisque nec fermentum magna.</td>,<td>Sep 13 02:32 PM</td>,</tr>,,
</table>

Using Join comma (,) I can turn it into this

<table>
<tr><td colspan="7">Franklin</td></tr>","<tr><td>Cristhian</td><td></td><td></td><td></td><td></td><td></td><td>Sep 12 01:20 PM</td></tr>","
<tr><td>Isaac</td><td>1</td><td>Lorem</td><td></td><td></td><td>Nam eget dui quis nibh maximus efficitur.</td><td>Sep 13 07:50 AM</td></tr>","
<tr><td>Vivaldo</td><td>1</td><td>ipsum</td><td></td><td></td><td>Aliquam quis lacus lacus.</td><td>Sep 13 02:25 PM</td></tr>","
<tr><td>Cristhian</td><td>1</td><td>ipsum</td><td></td><td></td><td>Mauris vitae urna vitae neque.</td><td>Sep 13 02:29 PM</td></tr>","
<tr><td>Nicole</td><td>1</td><td>Lorem</td><td></td><td></td><td>Quisque nec fermentum magna.</td><td>Sep 13 02:32 PM</td></tr>","
</table>

I'm trying to get rid of the remaining commas. I thought using a Join again, but I got an error:

 

InvalidTemplate. Unable to process template language expressions in action 'Join_2' inputs at line '0' and column '0': 'Error setting value to 'From' on 'Microsoft.Azure.Workflows.Data.Operations.JoinActionInput'.'.

 

How can I get rid of the remaining commas?

  • Airbusacft Profile Picture
    6 on at
    Re: Remove Double Comma from Array

    I’m no expert by any means. I had the same issue after using multiples from a form. I removed the quotes and then used a return line to but the next option below the previous.

    1) compose <br>

    2) compose expression - json(click on the form option / question to remove quotes from

    3) compose expression - join(output from json),output(from #1)

    make sure that #2/3 end with ))

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June 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 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1