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.

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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,399)