Skip to main content

Notifications

Power Automate - Using Flows
Unanswered

[HELP!] Converting .xls attachments from outlook email to .xlsx and saving to sharepoint

Posted on by 8

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-1638994380606.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?

  • AnjelikaCh Profile Picture
    AnjelikaCh 78 on at
    Re: [HELP!] Converting .xls attachments from outlook email to .xlsx and saving to sharepoint

    Greetings @SKCData 👋

     

    Have you managed to solve the issue? I think something is wrong with the flow configuration. Could you send the screenshot? 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,297

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,890

Leaderboard

Featured topics

Restore a deleted flow