Answered

Export Paginated Report to sharepoint cause error in the file

(2) Share

Report

Posted on by ML-27061621-0

Hi and thx's for reading this.

I have a flow where i use "Export to File for Paginated Report" and after that i have "create file".
The flow runs and create an Excel file on the right URL but the file when i open it on sharepoint gives and "error message".

The strange part is if i download the file that gives the "error message" to (my download folder) it works as it should
Anyone have any good solution for this

/Thanks so much.

Create file parameter

The Flow:

The "error"

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

nmantzarea 20 on at

Like
a
(1)

Report
Copy link

Link copied!

In your Create File action, try to change the File Content to the following expression:

base64ToBinary(body('Export_To_File_for_Paginated_Reports')['$content'])

This ensures the file is written as proper binary rather than base64-encoded text, which is likely causing the corruption error.

Hope it works.

Was this reply helpful? Yes No
Suggested answer

Haque 3,653 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ML-27061621-0,

Apart from the base64ToBinary suggestion above, in the "Create file" action we need to make sure the file name parameter is valid string ending with chosen extension (say .xlsx). Its good that you have used body output for file content.

From integrity point of view - can you please download the file from SP and open localy to verify integrity?

Accidental point of view: Please double-check you are not accidentally passing the file content as the file name.

Though its bit of PowerBI related, can you please check this thread if you have followed the right approach to create file action?

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No
ML-27061621-0 4 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks both for the help and suggestions.

Worked with this suggesion , Thanks @nmantzarea fo the help.

base64ToBinary(body('Export_To_File_for_Paginated_Reports')['$content'])

Was this reply helpful? Yes No