Power Automate - Run PowerShell script & convert CSV onto Excel

[javierruidiaz]

Dear community,

I have a PowerShell script that returns a .CSV - So far we've been running this manually and then uploading it to our SharePoint.

• Is there a way we could automate the run of the script?
• Also, do you happen to know a way to convert a CSV onto Excel with Power Automate?

Thank you so much!
Javier

[yashag2255]

Hi @javierruidiaz 

You can use Power Automate Desktop (UI Flows) to run a PS script to convert CSV to Excel or you can also create a function app and call it in Power Automate to perform this action. 

Apart from this there are some third part services like Plumsail/ Encodian that can be used for converting/ parsing CSV data. 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[javierruidiaz]

Thanks for the swift reply @yashag2255 - I'll try your advice and will let you know how it goes! 🙂

[Jay-Encodian]

@yashag2255 - Thanks

@javierruidiaz - You can convert 'CSV to XLSX' with the 'Convert Excel' action - https://blog.encodian.com/2020/09/convert-excel-and-csv-files-in-power-automate/#2

HTH

Jay