Corrupted .XLSX or CSV File When Being Saved From Outlook

(0) Share

Report

Posted on by 72Zib

Hi,

I am getting corrupted file error when saving to OneDrive or SharePoint from outlook, I did try

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

but the template will not let me save, please help

Thanks Z

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report

Try the following expressions to get the file content and save to SharePoint:

Ellis

____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
72Zib 68 on at

Like (0)

Report

Hi I am getting error message with this string, any idea why?

Was this reply helpful? Yes No
Verified answer

Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (1)

Report

Let's start at the beginning when a new email arrives containing one or more file attachments. We will ensure that the attachments are properly save to OneDrive and SharePoint:
We will use a loop to save each file attachment to OneDrive and SharePoint. We use two loops, one for Value (Apply to each) because it is an array and stores the Outlook message, and another loop (Apply to each 2) to iterate through all the attachments in the email:
The above content can be entered as dynamic content, from the When a new email arrived (V3) action:

Try the above and let me know how you get one.

Ellis

____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
72Zib 68 on at

Like (0)

Report

Thanks for this excellent explanation. This works great.

Was this reply helpful? Yes No
PBOBOP 2 on at

Like (0)

Report

Hello Ellis @ekarim2020,

I am trying to follow the steps you have laid out, but I can't seem to select "value" in the first loop. I only have the option to select "Attachments". Is there any reason why? How will it affect the end result?
This is the first step
and the loop:

Was this reply helpful? Yes No
Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (0)

Report

Hi @PBOBOP ,

The fist thing to try is to enter the text Value into the Search box as shown. This should find the Value dynamic content:

Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No