Forum Discussion

Krishna09's avatar
Krishna09
Icon for Helper III rankHelper III
3 years ago

External table is not in the expected format --- while import .XLS file from sharepoint

    Hello all,   I have power automate flow, it trigger on email received and saves attahments from ZIP file to sharepoint. The file in zip file is in .xls.      below image Advanced editor:-...
General Comment
Need Help
Show and Tell
Tips and Tricks
Krishna09's avatar
Krishna09
Icon for Helper III rankHelper III
3 years ago

Hi BA_Pete ,

I have tried it as well. 

then in power query below error is shown.

In PA, I converted to .csv then the data is converted to html and html code is saved in csv file.

 

Below is my PA flow,

extracting the file from zip and saving this file as .xls