Forum Discussion
Krishna09
Helper III
3 years agoExternal 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:-...
BA_Pete
Super User
3 years agoHi Krishna09 ,
You can update your PA Flow to convert the .xls file to .xlsx.
IIRC, I've done something similar in the past with flow steps like this:
Get File Metadata (<Identifier>)
Get File Content (<Identifier>)
Create File (as ~.xlsx) (<File Content>)
Delete File (<Identifier>)
Pete