cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
35457698R
New Member

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
v-litu-msft
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
v-litu-msft
Community Support
Community Support

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.

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (1,963)