Possible to create nested arrays? Array of arrays?

(1) Share

Report

Posted on by NicolásN

I'm trying to transpose an HTML table by splitting it into rows and columns, like this:

'Get items' action with a filter, the amount of items fetched can be anywhere between 1-4.
'Create HTML table' action.
Turn HTML table into string and erasing/replacing every tag that is not </tr> or </td>.
'Split' string with '</tr>' delimiter, resulting in an array of rows.
'Apply to each' and loop thorugh the array of rows splitting each element with '</td>' delimiter, resulting in inner arrays of columns.

I thought I could then 'Append to array variable' into an array of arrays so I can later figure how to loop through it an recompose the HTML table. Turns out Power Automate doesn't handle nested arrays?

Is there any way I can store the inner arrays into the outer array? I can't join them or use union because I loose the table original dimensions.

Or better yet: is there a simpler way yo transpose an HTML table without using a third-party app?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

ivan_apps 2,189 Moderator on at

Like (0)

Report
Copy link

Link copied!

You can use an append to a string variable and add a json string from your extract. You’d be building a long string but then you can use the ParseJSON action to recreate the object/array that you will iterate.

Was this reply helpful? Yes No
Chriddle 8,672 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I'm not sure if I understood that, is that what you're looking for?

https://community.powerplatform.com/forums/thread/details/?threadid=6fc448d0-723d-496e-8674-b9d79a5775aa

Otherwise an example would help ;)

In general, converting HTML with string manipulation is tedious and error-prone and XML could be a way out.

Was this reply helpful? Yes No