Answered

Create a flow to convert XLS to XLSX, change data format to Table and rename file?

(1) Share

Report

Posted on by 35457698R

I am using an ODBC connection from our ERP software to upload an XLS report to a subfolder within our Sharepoint site. IE: https://abcbiz.sharepoint.com/sites/sales and folder Documents/Sales/Data

I need the flow to:

Identify a new file has been uploaded to Documents>Sales>Data of our sites/sales sharepoint
Check if the uploaded file name starts with "ABChistoricalsales" or "ABCforecastedsales" and start a different process for each
If "ABChistrocialsales" is matched, convert the file from XLS to XLSX
Also convert the excel data on the only sheet in the file to a Table
Rename the file to "ABC Historical Sales"
Delete the original file
Do the same steps 3-6 for "ABCforecastedsales" matches as well

Is this possible? If Flow can't convert from XLS to XLSX or create the Table within the file, can it do the rename and then use Power Query in Excel to edit the excel file?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @35457698R,

There is no action that could convert xls file to xlsx file, but you could use UI Flow to do it. There is a template you could do it:

https://preview.flow.microsoft.com/en-us/galleries/public/templates/8925727cb4f044e9b577f5ae111f2947/convert-xls-files-to-xlsx-using-ui-flows/

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
RobFischer 123 on at

Like (15)

Report
Copy link

Link copied!

This is not an acceptable solution! There needs to be a way to do this in an automatic flow. Microsoft needs to address this!!

Was this reply helpful? Yes No