Can't open the excel sheets my flow sends to my Onedrive folder

(1) Share

Report

Posted on by j1700

The goal of my flow is to send the excel sheet content of an automatic email sent to my shared mailbox every Friday into my personal onedrive folder called Source Data as seen above. The File name (fx) is: concat(formatDateTime(utcNow(), 'yyyy-MM-dd'), '_', items('Apply_to_each')?['name'])

The File Content is: Attachments Content

The flow seems to detect the email fine and automatically sends an excel sheet to my Onedrive folder, however when i try to open it - it says:

Is there any way to fix this? Thanks

Categories:

Building flows

AI Builder

Power Automate Desktop

Using flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

Valantis 6,735 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @j1700,

The issue is that the Create file action saves the attachment using Attachments Content directly, but Power Automate passes this as base64 encoded binary. OneDrive saves it correctly but Excel cannot open it because the file content does not match the extension.

The fix is to wrap the file content with the base64ToBinary() function instead of using Attachments Content directly.
In the File Content field of your Create file action, replace Attachments Content with this expression:

base64ToBinary(items('Apply_to_each')?['contentBytes'])

This converts the attachment from base64 to proper binary before saving, which is what OneDrive needs to store the file in a format Excel can open correctly.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

Was this reply helpful? Yes No
Suggested answer

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

Like
a
(0)

Report
Copy link

Link copied!

@j1700,

See also: How to Save Files to SharePoint Without Corruption Using Power Automate – Ellis Karim's Blog which shows the following method:

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
Suggested answer

chiaraalina 2,425 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

In my opinion, this should work without any extra steps.

Microsoft docs say that with “Include Attachments = Yes”, the trigger already provides the attachment content, so using “Attachments Content” directly is supported.

https://learn.microsoft.com/en-us/troubleshoot/power-platform/power-automate/flow-run-issues/issues-triggering-emails-with-attachments-from-shared-mailbox

Maybe check:

Open the original attachment from the email -> does it work?
Check file size -> is it very large?
Check you’re not picking the wrong attachment
Test with another file first

Check if the email/attachment is encrypted

Was this reply helpful? Yes No
Valantis 6,735 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @j1700,

Just wanted to check in and see if everything is working now. If you still need any help, feel free to let me know.

Also, if the issue is resolved, it would be great if you could mark the answer as solved so others with the same question can find it easily.

Thanks and have a great day!

Was this reply helpful? Yes No