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
Solved! Go to Solution.
Using a compose action, I was able to convert the array to xml. The expression I'm using is:
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
To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.
Have you already turned up the concurrency for your Apply to each to speed it up?
Pat
To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.
Using a compose action, I was able to convert the array to xml. The expression I'm using is:
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
48 | |
17 | |
16 | |
13 | |
13 |
User | Count |
---|---|
79 | |
40 | |
27 | |
22 | |
18 |