web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Remove characters from...

Power Automate

Answered

Remove characters from Array to just leave a value

(0) Share

Report

Report

Posted on by Jduggins

44

Hi, I currently have an array that I want to use in a URL parameter.

The Array output is like this:

{"body":{"id":"0;"},{"id":"1;"},{"id":"2;"}}

If I try and store this in a variable and put it in a URL, it composes fine but when the URL is used in an email, this data is cut off. The end of the URL looks like:

&Qs=[{

Is there a way to remove all of the excess characters from this to just leave the numbers, so I can get something like

&Qs=1,2,3

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Suggested answer

Fredrik_A 3,570 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello,

try this. You input your array as input to the select action, and then map it to the column you want (In this case id).

Then you simply join it, like the action shown last in the image below.

If my response solved your issue, please mark it as ✅ Accepted Answer and give it a like.

Was this reply helpful? Yes No
Verified answer

Chriddle 8,672 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
In just one expression using xpath:

join( xpath( xml( addProperty( json('{}'), 'Root', addProperty( json('{}'), 'Item', outputs('Compose').body ) ) ), '//Item/id/text()' ), ',' )

Was this reply helpful? Yes No

Join the conversation