web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : EQbwv6q9yYmuCKTS09aV0U
Power Automate - Building Flows
Unanswered

Remove Double Comma from Array

Like (0) ShareShare
ReportReport
Posted on 15 Sep 2022 20:00:09 by 1,374 Moderator

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?

I have the same question (0)
  • Airbusacft Profile Picture
    6 on 15 Sep 2022 at 22:17:28
    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 666 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 382 Moderator

#3
developerAJ Profile Picture

developerAJ 254

Last 30 days Overall leaderboard
Loading complete