web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Create a flow to conve...
Power Automate
Unanswered

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

(1) ShareShare
ReportReport
Posted on by 2

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?

Categories:
I have the same question (0)
  • Verified answer
    v-litu-msft Profile Picture
    on at
    Re: Create a flow to convert XLS to XLSX, change data format to Table and rename file?

    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.

  • RobFischer Profile Picture
    119 on at
    Re: Create a flow to convert XLS to XLSX, change data format to Table and rename file?

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard