Error opening Excel workbook from Sharepoint

Like (0) Share

Report

Posted on 20 May 2024 16:01:34 by johnnykeesh

Hello all,

I am very new to the power automate world and have been tasked with creating a simple flow that grabs an excel file from our org sharepoint and scheduled sends to parent company. I have been testing for a few day and have not been able to get around this error - once the email is sent, the attachment is added into the email but once I preview the file, I receive the error "We're sorry, we couldn't open your workbook. It's possibly corrupt or using a file format that's not supported."

I thought this would be a pretty basic flow but have not been able to solve. I can open the excel file from SharePoint, OneDrive, and local directory without any issues. I attempted sending the file by itself to myself, and could preview/open without any issues, just once it sends through my flow I cannot open file.

Attached is the body of my flow as well as the email sent via send email action and the file preview error. Anything helps, TIA !!!

I have the same question (0)

All responses (4)

Answers (1)

v-yueyun-msft on 21 May 2024 at 01:30:43

Like (0)

Report

Re: Error opening Excel workbook from Sharepoint

Hi , @johnnykeesh

Can you re-create the action in classic mode in Power Automate.

In the new mode, there is currently a problem with file content.

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
johnnykeesh 7 on 21 May 2024 at 13:37:10

Like (0)

Report

Re: Error opening Excel workbook from Sharepoint

Hi @v-yueyun-msft ,
Thanks for the help, I re-create the action in classic mode and still getting the corrupt file error 😕 .
I'm wondering if I am using the correct actions? - it is just a basic excel file. Almost every tutorial I watched had a Get file meta data and get file content, but I may be using the wrong ones??

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft on 22 May 2024 at 01:59:42

Like (1)

Report

Re: Error opening Excel workbook from Sharepoint

Hi , @johnnykeesh

Thanks for your response! I test it in my side , it works good :

You can refer to my test flow:

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
johnnykeesh 7 on 22 May 2024 at 13:30:13

Like (0)

Report

Re: Error opening Excel workbook from Sharepoint

@v-yueyun-msft this was it!! Thank you kindly 🙂 I was using the wrong identifier on my send email action, much appreciated and thank you again!

Was this reply helpful? Yes No