cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Dippa
Level: Powered On

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
Super User
Super User

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

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.

Super User
Super User

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

jvarughese
Level: Power Up

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

Power Platform Online Conference

Speakers, submit your sessions now! Call for speakers ends Feb. 10!

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!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,588)