Power Automate

Power Automate Corrupts Email (Excel) Attachments Saved or Copied to SharePoint

(0) Share

Report

Posted on by TR-11092140-0

I'm running into an issue with a Power Automate flow and hoping someone here has seen this before or has a workaround.

Here's what my flow does:

It monitors a shared inbox for incoming emails with attachments.
It filters attachments by name and saves them to a SharePoint folder using the Create File connector.
In the screenshot of my flow, there's a Delay action currently acting as a placeholder to mark where additional tasks will be added later.
After the delay, the flow includes a step that copies the file to another folder.

The problem: When I try to open the Excel file after this process, it shows an error and won’t open properly. Here's the screenshot of the error message:

The complete flow with Create File parameters:

Any tips on how to avoid this? Thanks!

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Michael E. Gernaey 53,963 Moderator on at

Like (1)

Report
Copy link

Link copied!

HI @TR-11092140-0

A couple of things.

Primary questions / thoughts

You need loop through attachments

You need to have a Get Attachment (where is that at?) as I expect your Dynamic names to be in Caps

What is the file attachment?

How long is your Delay? Make sure its 10 minutes

Here is a good walkthrough I would verify as I see missing items in yours

Power Automate: Save Email Attachments To SharePoint Library

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

1 people found this reply helpful.

Was this reply helpful? Yes No
Michael E. Gernaey 53,963 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @TR-11092140-0

Just checking in on this.

Was this reply helpful? Yes No
TR-11092140-0 2 on at

Like (0)

Report
Copy link

Link copied!

@Michael E. Gernaey The file attachment is a mix of different file types. The flow filters a target file having ".xlsx" as the extension.

After several attempts in running the same flow, it seems like the error has something to do with Excel and not the flow. In the current flow, it does loop through the attachments in the Foreach block.

In some iterations, the output attachment file opens without throwing this error but sometimes it does popup. Not sure if something happens "in-memory" that causes Excel to show that error sometimes.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Ellis Karim 12,122 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @TR-11092140-0

Here is another option to try:

See: How to Save Files to SharePoint Without Corruption Using Power Automate – Ellis Karim's Blog

Ellis Karim
elliskarim.com | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
Building with Why 351 Moderator on at

Like (0)

Report
Copy link

Link copied!

@TR-11092140-0 is this in production? I ask because when testing it is common (I do this all the time) to re-run the flow until it passes.

The problem is that the Power Automate connector for Outlook does not save the file correctly/well. This is to say, if you are re-running the flow the flow will work, but the file will be corrupted. Trigger the flow fresh and see if the file is corrupted.

If this helped, please mark as answered and like this response.

Was this reply helpful? Yes No