Convert array to xml without apply to each ?

[bouillons]

Hi, I have a simple array of items that I want to convert to XML in power automate. The xml() function does not allow arrays as input. Has anybody found a way to workaround this limitation ? There's an example using apply to each which is too slow for my scenario.

Stephane

[mahoneypat]

I didn't have time to finish but I adapted the approach used in this article (perhaps the one you saw).  Basically you use two Selects.  The first packages each JSON object in your array into a single-element object (for the XML function to work); I called mine Result but you can substitute.  The second Select extracts the $content of the created XML and converts that binary to a string.

Solved: convert json output into xml - Power Platform Community (microsoft.com)

Here is what the above looks like.  From here you can do the join step and add the header as described in the solution above.

Pat

[mahoneypat]

Have you already turned up the concurrency for your Apply to each to speed it up?

Pat

[bouillons · Accepted solution]

Using a compose action, I was able to convert the array to xml. The expression I'm using is:

xml(json(concat('{"list": {"item": [',join(body('Result Array of Select'),','),']}}')))