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

Nimisha Vernekar 126 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.
2,839 questions
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.
2,798 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 21,626 Reputation points Microsoft Vendor
    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.