Forum Discussion
Error when combining excel files from sharepoint
Hello Yass91 - you are getting this error because your have a step in the transform sample file query that explicitly mentioning a column named CLIENT. It must exist in the file used as the sample file but it is not present in the new file. This is why you get the error when the function is invoked. If the column is not needed, you can edit the transform sample file query to eliminate the reference to the CLIENT column. If the column is needed then you must add it to the new files.
It might be caused due to the formula you have wrtien in the custom column.
you should convert the Binary file into table using the following fomrula first then can handle some cleaning process
Excel.Workbook([Content], null, true)
Hi Yass91 ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithra.