Corrupted .XLSX or CSV File When Being Saved From Outlook

[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

[ekarim2020]

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.

[72Zib]

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

[ekarim2020 · Accepted solution]

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.

[72Zib]

Thanks for this excellent explanation. This works great.