cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dippa
Frequent Visitor

Create flow csv to xml

Hi All,

 

We need to convert a csv file from from one-drive into a xml file and post back to one-drive. Is this possible in flow.

 

1.) User saves file to one-drive location

2.) Flow detects new file

3.) Flow converts csv to xml

4.) Flow saves file back to one-drive location

 

The csv file will be the same format for every itteration, the XML is static as well

 

It would be great to do all the work in flow and or power apps.

 

The alternative is to have flow inject the data into an sql table, then with the next step the flow can extract the data with a sql select xml, thus returning the data in xml.

 

Thanks 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi!

 

You can use Parse CSV action from Plumsail Documents connector. It allows you to convert CSV into an array and variables for each column. Please read this article demonstrating how it works.

 

In your case you will need to parse CSV and then generate an XML from a template using this data. For this task you can use Create HTML from template action from the same connector. This action can generate XML as well. Please review this article to learn how to generate HTML (XML in your case) from template.

View solution in original post

3 REPLIES 3
v-yuazh-msft
Community Support
Community Support

Hi @Dippa.,

 

There is no any function in microsoft flow could convert csv file to xml file in microsoft flow currently.

I afraid that there is no direct way to achieve your needs in Microsoft Flow currently.

 

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Best regards,

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi!

 

You can use Parse CSV action from Plumsail Documents connector. It allows you to convert CSV into an array and variables for each column. Please read this article demonstrating how it works.

 

In your case you will need to parse CSV and then generate an XML from a template using this data. For this task you can use Create HTML from template action from the same connector. This action can generate XML as well. Please review this article to learn how to generate HTML (XML in your case) from template.

View solution in original post

Has anyone successfully used the HTML template connector to create XML? 

 

I am in a very similar situation where I need to: 

1. FTP pull a CSV

2. Parse the CSV Data

3. Create an XML payload from the CSV Data

4. Send the XML payload via HTTP POST to a receiving endpoint. 

 

If the XML cannot be created, that is a show stopper. 

 

Thanks, 

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,032)