cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Helper V
Helper V

Re: Create flow csv to xml

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
Highlighted
Community Support
Community Support

Re: Create flow csv to xml

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.

Highlighted
Helper V
Helper V

Re: Create flow csv to xml

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

Highlighted
New Member

Re: Create flow csv to xml

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
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (6,030)