{"id":72272,"date":"2023-08-03T08:00:00","date_gmt":"2023-08-03T12:00:00","guid":{"rendered":"https:\/\/www.spguides.com\/?p=72272"},"modified":"2023-08-02T08:03:52","modified_gmt":"2023-08-02T12:03:52","slug":"convert-xml-to-array-in-power-automate","status":"publish","type":"post","link":"https:\/\/www.spguides.com\/convert-xml-to-array-in-power-automate\/","title":{"rendered":"How to Convert XML to Array in Power Automate?"},"content":{"rendered":"\n<p>This Power Automate tutorial will show how to <strong>convert XML to an array in Power Automate<\/strong> or Microsoft Flow.<\/p>\n\n\n\n<p>For example, we will create a flow that will convert the given XML file content to an array, by parsing the XML file content, like below.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"539\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-convert-xml-file-to-Array-using-Power-automate-1024x539.jpg\" alt=\"How to convert xml file to Array using Power automate\" class=\"wp-image-72275\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-convert-xml-file-to-Array-using-Power-automate-1024x539.jpg 1024w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-convert-xml-file-to-Array-using-Power-automate-300x158.jpg 300w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-convert-xml-file-to-Array-using-Power-automate-768x404.jpg 768w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-convert-xml-file-to-Array-using-Power-automate.jpg 1410w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>For this, we will create an Instant cloud flow in Power Automate, that will take an XML file as user input. Then parse the file content of that XML file, loop through each node of XML data, and append to an array.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_69_1 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.spguides.com\/convert-xml-to-array-in-power-automate\/#How_to_convert_XML_to_an_array_using_Power_Automate\" title=\"How to convert XML to an array using Power Automate\">How to convert XML to an array using Power Automate<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.spguides.com\/convert-xml-to-array-in-power-automate\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_convert_XML_to_an_array_using_Power_Automate\"><\/span>How to convert XML to an array using Power Automate<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Here we will see how to convert an XML to an array using Power Automate.<\/p>\n\n\n\n<p>Let&#8217;s create an Instant cloud flow, that will convert XML to an array using Power Automate.<\/p>\n\n\n\n<p><strong>Step 1:<\/strong> Log in to Power Automate and click\u00a0the <strong>+Create<\/strong> icon in the left navigation\u00a0-> select\u00a0<strong>Instant Cloud Flow<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"793\" height=\"501\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/Microsoft-Power-Automate-xml-to-Array.jpg\" alt=\"Microsoft Power Automate xml to Array\" class=\"wp-image-72276\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/Microsoft-Power-Automate-xml-to-Array.jpg 793w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/Microsoft-Power-Automate-xml-to-Array-300x190.jpg 300w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/Microsoft-Power-Automate-xml-to-Array-768x485.jpg 768w\" sizes=\"(max-width: 793px) 100vw, 793px\" \/><\/figure><\/div>\n\n\n<p>Then provide the flow name, and select the<strong>&nbsp;Manually trigger a flow<\/strong>. Then click on&nbsp;<strong>Create<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img decoding=\"async\" width=\"1008\" height=\"636\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/Power-Automate-xml-to-Array.jpg\" alt=\"Power Automate xml to Array\" class=\"wp-image-72277\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/Power-Automate-xml-to-Array.jpg 1008w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/Power-Automate-xml-to-Array-300x189.jpg 300w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/Power-Automate-xml-to-Array-768x485.jpg 768w\" sizes=\"(max-width: 1008px) 100vw, 1008px\" \/><\/figure><\/div>\n\n\n<p>Next, you can see Manually trigger a flow is added to the flow page. Then we will add the file as user input, so click on the +Add an input -> select File options. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"753\" height=\"222\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/MS-flow-xml-file-to-Array.jpg\" alt=\"MS flow xml file to Array\" class=\"wp-image-72278\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/MS-flow-xml-file-to-Array.jpg 753w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/MS-flow-xml-file-to-Array-300x88.jpg 300w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 2:<\/strong> Now we will convert the base64 to string using Power Automate, so, click on the +New step -> select\u00a0<strong>Compose\u00a0<\/strong>action. Then provide the below information:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Inputs<\/strong>: Provide the below expression:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>base64ToString(triggerBody()?&#91;'file']?&#91;'contentBytes'])<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"747\" height=\"133\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/MS-flow-xml-file-to-Array-1.jpg\" alt=\"MS flow xml file to Array\" class=\"wp-image-72287\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/MS-flow-xml-file-to-Array-1.jpg 747w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/MS-flow-xml-file-to-Array-1-300x53.jpg 300w\" sizes=\"(max-width: 747px) 100vw, 747px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 3:<\/strong> Next, click on the +New step, and select\u00a0<strong>Initialize variable<\/strong>\u00a0action. Then provide the below information:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Name<\/strong>: Provide the variable name.<\/li>\n\n\n\n<li><strong>Type<\/strong>: Select the type as an Array.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"752\" height=\"218\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/MS-Power-Automate-xml-file-to-Array-1.jpg\" alt=\"MS Power Automate xml file to Array\" class=\"wp-image-72281\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/MS-Power-Automate-xml-file-to-Array-1.jpg 752w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/MS-Power-Automate-xml-file-to-Array-1-300x87.jpg 300w\" sizes=\"(max-width: 752px) 100vw, 752px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 4:<\/strong> Now, we will parse the XML data, so, click on the\u00a0<strong>+New step<\/strong>\u00a0-> select\u00a0<strong>Compose\u00a0<\/strong>action. Then provide the below information.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Inputs<\/strong>: Provide the below information:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>xpath(xml(outputs('Compose_-_base_64_to_string')), '\/products\/product')<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"127\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-xml-file-to-Array-MS-flow.jpg\" alt=\"How to xml file to Array MS flow\" class=\"wp-image-72282\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-xml-file-to-Array-MS-flow.jpg 750w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-xml-file-to-Array-MS-flow-300x51.jpg 300w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 5:<\/strong> Now we will loop through person nodes to get the details, so click on the\u00a0<strong>+New step<\/strong>\u00a0-> select\u00a0<strong>Apply to eac<\/strong>h action. Provide the below information:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Select an output from previous steps<\/strong>: Select the output of the previous compose, from the dynamic content.<\/li>\n<\/ul>\n\n\n\n<p>Next, we will Add an action -&gt; select&nbsp;<strong>Compose&nbsp;<\/strong>action, then provide the below information:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Inputs<\/strong>: Provide the below expression<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>items('Apply_to_each')?&#91;'$content']<\/code><\/pre>\n\n\n\n<p>After that, click on Add an action -&gt; select&nbsp;<strong>Compose&nbsp;<\/strong>action to convert base64 to string, then provide the below information:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>base64ToString(outputs('Compose_4'))<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"796\" height=\"478\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-xml-file-to-Array-Microsoft-flow.jpg\" alt=\"How to xml file to Array Microsoft flow\" class=\"wp-image-72283\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-xml-file-to-Array-Microsoft-flow.jpg 796w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-xml-file-to-Array-Microsoft-flow-300x180.jpg 300w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-xml-file-to-Array-Microsoft-flow-768x461.jpg 768w\" sizes=\"(max-width: 796px) 100vw, 796px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 6:<\/strong> Now, click the +New step -> selec<strong>t Append to array variable<\/strong>\u00a0action. Then provide the below information:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Name: Select the variable name.<\/li>\n\n\n\n<li>Value: Provide the below information:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>{\n  \"id\": @{join(xpath(xml(outputs('Compose_5')), '\/product\/id\/text()'),'')},\n  \"name\": @{join(xpath(xml(outputs('Compose_5')), '\/product\/name\/text()'),'')},\n  \"description\": @{join(xpath(xml(outputs('Compose_5')), '\/product\/description\/text()'),'')},\n  \"price\": @{join(xpath(xml(outputs('Compose_5')), '\/product\/price\/text()'),'')},\n  \"quantity\": @{join(xpath(xml(outputs('Compose_5')), '\/product\/quantity\/text()'),'')}\n}<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"796\" height=\"513\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-xml-file-to-Array-using-Microsoft-flow.jpg\" alt=\"How to xml file to Array using Microsoft flow\" class=\"wp-image-72284\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-xml-file-to-Array-using-Microsoft-flow.jpg 796w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-xml-file-to-Array-using-Microsoft-flow-300x193.jpg 300w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-xml-file-to-Array-using-Microsoft-flow-768x495.jpg 768w\" sizes=\"(max-width: 796px) 100vw, 796px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 7:<\/strong> Now we will use compose action to check the result so, click on the +New step -> select Compose action and then provide the below information:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Inputs: Select the variable person details from dynamic content.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"763\" height=\"153\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-xml-file-to-Array-using-Microsoft-Power-automate.jpg\" alt=\"How to xml file to Array using Microsoft Power automate\" class=\"wp-image-72285\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-xml-file-to-Array-using-Microsoft-Power-automate.jpg 763w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-xml-file-to-Array-using-Microsoft-Power-automate-300x60.jpg 300w\" sizes=\"(max-width: 763px) 100vw, 763px\" \/><\/figure><\/div>\n\n\n<p><strong>Step 8<\/strong>: Now, to test the flow, click on Save and then click on the Test icon ->select the Manually option -> click on the Test button. Then click Import and select the XML file -> click on Run flow. You can see your flow run successfully.<\/p>\n\n\n\n<p>The XML data is converted to an array in Power Automate.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"535\" src=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-xml-file-to-Array-using-Power-automate-1024x535.jpg\" alt=\"How to xml file to Array using Power automate\" class=\"wp-image-72286\" title=\"\" srcset=\"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-xml-file-to-Array-using-Power-automate-1024x535.jpg 1024w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-xml-file-to-Array-using-Power-automate-300x157.jpg 300w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-xml-file-to-Array-using-Power-automate-768x401.jpg 768w, https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-xml-file-to-Array-using-Power-automate.jpg 1410w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>This is how we can convert XML to an array using Power Automate.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In this Power Automate tutorial, we will see how to <strong>convert XML to an array using Power Automate<\/strong>.<\/p>\n\n\n\n<p>You may like the following Power Automate tutorials:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.spguides.com\/loop-through-xml-data-and-insert-into-excel-using-power-automate\/\">How to loop through XML data and insert into Excel using Power Automate?<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.spguides.com\/send-email-from-excel-using-power-automate\/\">How to send email from excel using Power automate?<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.spguides.com\/send-an-email-with-options-in-power-automate\/\">Send an email with options in Power Automate<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>This Power Automate tutorial will show how to convert XML to an array in Power Automate or Microsoft Flow. For example, we will create a flow that will convert the given XML file content to an array, by parsing the XML file content, like below. For this, we will create an Instant cloud flow in &#8230; <a title=\"How to Convert XML to Array in Power Automate?\" class=\"read-more\" href=\"https:\/\/www.spguides.com\/convert-xml-to-array-in-power-automate\/\" aria-label=\"Read more about How to Convert XML to Array in Power Automate?\">read more&#8230;<\/a><\/p>\n","protected":false},"author":2,"featured_media":72286,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"rank_math_lock_modified_date":false,"ub_ctt_via":"","footnotes":""},"categories":[210],"tags":[3002],"class_list":["post-72272","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-automate","tag-convert-xml-to-array-in-power-automate","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-50"],"featured_image_src":"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-xml-file-to-Array-using-Power-automate.jpg","author_info":{"display_name":"Bijay Kumar","author_link":"https:\/\/www.spguides.com\/author\/fewlines4biju\/"},"jetpack_featured_media_url":"https:\/\/www.spguides.com\/wp-content\/uploads\/2023\/07\/How-to-xml-file-to-Array-using-Power-automate.jpg","_links":{"self":[{"href":"https:\/\/www.spguides.com\/wp-json\/wp\/v2\/posts\/72272"}],"collection":[{"href":"https:\/\/www.spguides.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.spguides.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.spguides.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.spguides.com\/wp-json\/wp\/v2\/comments?post=72272"}],"version-history":[{"count":5,"href":"https:\/\/www.spguides.com\/wp-json\/wp\/v2\/posts\/72272\/revisions"}],"predecessor-version":[{"id":72461,"href":"https:\/\/www.spguides.com\/wp-json\/wp\/v2\/posts\/72272\/revisions\/72461"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.spguides.com\/wp-json\/wp\/v2\/media\/72286"}],"wp:attachment":[{"href":"https:\/\/www.spguides.com\/wp-json\/wp\/v2\/media?parent=72272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.spguides.com\/wp-json\/wp\/v2\/categories?post=72272"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.spguides.com\/wp-json\/wp\/v2\/tags?post=72272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}