Excel file of paginated report exported via logic app doesnt open/is corrupt

Nimisha Vernekar 131 Reputation points
2022-09-28T14:41:55.073+00:00

I am trying to export paginated reports through logic apps in the PDF and Excel formats. While the PDF formats are generated as expected, the excel files which are generated from the logic app dont open.
245603-image.png

I first use this action and then send via mail the reports.
245623-image.png

In the Send Email action, I have this as an attachment. 245614-image.png

What could be the reason for this?

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 30,126 Reputation points Microsoft External Staff
    2022-09-29T07:40:38.957+00:00

    Hi @Nimisha Vernekar ,
    Did you download the file to local?
    What version of Excel did you use?
    If the file is download in the local, I suggest you right click the File- Properties- under General tab- you can confirm if there is "unblock" option, check it:
    245963-image.png

    You can also try to open and repair the file, maybe the file has come corrupt or damaged:
    https://support.microsoft.com/en-gb/office/repairing-a-corrupted-workbook-7abfc44d-e9bf-4896-8899-bd10ef4d61ab

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.