How to Convert XML to CSV using Power Automate?

In this Power Automate tutorial, we will see how to convert xml to csv using Power Automate.

For example, we will take the below XML data, and then we will convert it to the csv table, and we will send it with an email attachment.

<root>
  <person>
    <name>John Doe</name>
    <age>30</age>
    <email>[email protected]</email>
  </person>
  <person>
    <name>Jane Smith</name>
    <age>25</age>
    <email>[email protected]</email>
  </person>
  <person>
    <name>Michael Johnson</name>
    <age>35</age>
    <email>michael.j[email protected]</email>
  </person>
</root>

For this, we will create an Instant cloud flow that will trigger manually. Then we will parse the above XML and create an array of data. By using this array of data, we will create a csv table. At last, we will send an email to the recipients, with the attachment; the content will be the output of csv table action

Convert XML to CSV file using Power Automate

Here we will create an Instant cloud flow and convert xml to csv file using Power Automate.

Step 1: Log in to Power Automate and click +Create -> select Instant Cloud Flow.

Then provide the flow name, and select the Manually trigger a flow. Then click on Create.

Now, you can see the Manually trigger a flow action is the flow page.

Step 2: Next, click the +New step -> select Compose action. Then provide the below information:

• Inputs: In inputs provide the below xml code

<root>
  <person>
    <name>John Doe</name>
    <age>30</age>
    <email>[email protected]</email>
  </person>
  <person>
    <name>Jane Smith</name>
    <age>25</age>
    <email>[email protected]</email>
  </person>
  <person>
    <name>Michael Johnson</name>
    <age>35</age>
    <email>michael.j[email protected]</email>
  </person>
</root>

Step 3: Next, we will parse the XML and get all the person nodes. After parsing the XML it returns the output in base64 to get it in a string, we will use the text().

So, click on the +New step and select compose actions. Then provide the below information:

• Inputs: Provide the following expressions:

xpath(xml(outputs('Compose_-XML')), '/root/person')

Step 4: Next, we will initialize a variable, and later we will use to create an array of person details. So, click on the New step -> select Initialize variable action. Then provide the below information:

• Name: Provide the variable name.
• Type: Select the type as Array from the dropdown.

Step 5: Next, we will loop through person nodes to get the details, so click on the +New step -> select Apply to each action. Provide the below information:

• Select an output from previous steps: Select the output, from the dynamic content.

Next, we will Add an action -> select Compose action, then provide the below information:

• Inputs: Provide the below expression

@{items('Apply_to_each')?['$content']}

After that, click on Add an action -> select Compose action to convert base64 to string, then provide the below information:

• Inputs: Provide the below expression:

base64ToString(outputs('Compose_4'))

Step 6: Now to get the name, age, and email of the Person. So, click on the Add an action, and select Append to array variable action. Then provide the below information:

• Name: Provide the variable name
• value: Provide the below expression

{
"Name":@{join(xpath(xml(outputs('Compose_5')), '/person/name/text()'),'')},
"Age": @{join(xpath(xml(outputs('Compose_5')), '/person/age/text()'),'')},
"Email":@{join(xpath(xml(outputs('Compose_5')), '/person/email/text()'),'')}
}

Step 7: Next, we will create a csv table, so, click on the +New step -> select Create CSV table action. Then provide the below information:

• From: Select the Person details variable from dynamic content.

Step 8: Next, we will send an email with csv file attachments. So, click on the +New step -> select ‘Send an email (V2)’ action. Then provide the below information:

• To: Provide the recipient of email
• Subject: Provide the subject of an email
• Body: Provide the body of an email
• Attachment name: Provide the file name
• Attachment content: Provide the file content

Step 9: Now run the flow manually; for this, save the flow, click on the Test icon ->select the Manually option, -> click on the Test button. You can see the flow run successfully.

You can see the csv file is attached to an email using Power Automate.

Conclusion

In this Power Automate tutorial, we saw an example of converting XML to CSV files using Power Automate.

You may also like:

• Import Data from Excel to a SharePoint list using Power Automate
• How to Merge Word Documents in Power Automate?
• Format date to iso 8601 in Power Automate
• How to Check if a field exists in Power Automate?