cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SKCData
Regular Visitor

Converting .xls attachments from outlook email to .xlsx and saving to sharepoint

I receive automated financial reports on a daily basis. They are sent to my Outlook inbox as .xls spreadsheets which cannot be used in Power BI the way I have it setup. So I decided to run a flow to convert the .xls into a .xlsx via plumsail documents. 

 

The program that is sending me these automated reports also includes a "report.html" file in the attachments that is causing some trouble in my flow.

SKCData_0-1638994250270.png

 

 

I have a condition set so that if the attachment does not contain "report" then it will go through plumsail documents and be converted to a .xlsx and then stored in my sharepoint folder. 

The .xls files are successfully being converted and saved in my sharepoint folder, but the issue comes with the "report.html" attachment. It completely negates the condition and tries to run through plumsail documents .xls to .xlsx anyway causing my report to come back as "failed"

Any idea how to work around this?

SKCData_1-1638994250276.png

 

0 REPLIES 0

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,845)