Append 3 xls files to one file and save to sharepoint.

[Krishna09]

Hello all,

is there any way to append 3 xls files in power automate?

the flow triggers- when an email is received. ( everey day three emails are received at same time).

actions - these emails contains zip file on extract gives xls file froom each.  this is my flow

please suggest way to append xls files.

[trice602]

Hi @Krishna09 ,

Yes, I am doing this a on regular basis and here's my process.  With Dataflows in PowerApps, you essentially have the same tool as PowerQuery in Excel.  From here, you can bring all your Excel files together (just like in Excel) and merge them into a single table and then do other things you need/want.

There are a two key Power Automate options, an action When a Dataflow Refreshes - which will wait until you flow refreshes the launch actions 

Or you can use the trigger When a Dataflow Refresh Completes

You also have the option to do a scheduled refresh directly in Dataflows.

Please mark as a solution if this helps you get started!  Always glad to help! Tom

[trice602]

HI @Krishna09 ,

Here's a sample workflow to consider also:

When an email arrives, save each file to OneDrive or SharePoint.  I make it easy for automation building by renaming these files at this step as File1.xlsx, File2.xlsx, File3.xlsx.

In your Dataflows, you can scoop up those files from that location by the names (since you already have the names and can skip additional steps), then merge into a single table and bring the data back to your flow and save the merged file in OneDrive or SharePoint. 

[Krishna09]

Hello, xls file is not opening in dataflow.

how to save appended file in sharepoint?

[Krishna09]

Hi,

if i convert xls to xlsx, the file is not opening . if i convert to csv data is convert to html in excel file. so please guide me how to append these files

[trice602]

Hi @Krishna09 ,

There are some options to consider.  One is to create a mini flow that gets your data and resaves as a .xslx file or .csv.  I've had a security issue with an older .htm file that is emailed to me and that's the exact process I use, I take the older format and save to SharePoint as a .csv.  Is that an option for your?  Always glad to help! Tom

[Krishna09]

Hello @trice602 , 

when I convert xls to xlsx format and save in sharepoint folder using power automate it gives an below error to open.

and i do not know to bring back appended file from data flow to power automate can you please explain in steps?

below is the way i am saving xls to xlsx file. is it correct way? if not please suggest me. 

[trice602]

Hi @Krishna09 ,

Changing the file extension doesn't change the file content type; you have to go through the process of changing the file.

Here's a template to implement.  Please mark as a solution!  Always glad to help! Tom

Convert .xls files to .xlsx using UI flows | Microsoft Power Automate

[Krishna09]

Hi @trice602 ,

 thank you for your support. 

is there any other alternate way with out UI flow to convert xls to xlsx or csv?

or can you suggest any way to append xls files ?