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

[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:

1. Identify a new file has been uploaded to Documents>Sales>Data of our sites/sales sharepoint
2. Check if the uploaded file name starts with "ABChistoricalsales" or "ABCforecastedsales" and start a different process for each
3. If "ABChistrocialsales" is matched, convert the file from XLS to XLSX
4. Also convert the excel data on the only sheet in the file to a Table
5. Rename the file to "ABC Historical Sales"
6. Delete the original file
7. 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?

[v-litu-msft · Accepted solution]

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... 

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.

[RobFischer]

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