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
Solved! Go to Solution.
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.
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,