cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sanket7030
Frequent Visitor

Export report to excel and mail to user.

Hi.

I have created a flow to export my report to excel and the flow is running properly with a mail being sent to the user.

The issue which is arising is that the exported file is giving an error as "excel cannot open the file because the file is corrupted".

Sanket7030_0-1632401651342.png

Sanket7030_1-1632401704306.png

 

If anybody can provide any input, then it would be of great help.

 

Regards,

Sanket Bhagwat

4 REPLIES 4
MichaelAnnis
Super User
Super User

Hi Sankey,

 

Unfortunately, this is a Power Automate Flow issue and you posted to Power Automate Desktop.  I am not as familiar with the flows as they do not correlate.  The "\Excel.xlsx" looks suspicious.

 

Are you able to open this file on your own computer after it is created?

Hi @MichaelAnnis .

I have created that flow in Power Automate Desktop, so I posted it here.

The flow is running perfectly in one drive file.

But when I add 'Send an email' flow, the file which I am getting in mail is not opening.

And I am getting the below error;

Sanket7030_0-1632465842244.png

 

 

Regards,

Sanket Bhagwat

I have added the below steps in my 'send to mail' action.

Sanket7030_1-1632466369634.pngSanket7030_0-1632466345631.png

VJR
Super User
Super User

Hi @Sanket7030 

 

What is in the Power Bi data of Attachment Content

 

VJR_0-1632472519718.png

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (4,388)