Unanswered

Save file attachment to Sharepoint Library causing file format not matching extension error

(1) Share

Report

Posted on by RhysWilliams

Hi,

I'm sure I am missing something simple. I have set up an automation that identifies a regular email that I receive with data in an xlsx format file. This then saves the attachment to the correct folder I have set up. However, when I try to open this file it produces the following error:

"This workbook couldn't be opened because the file format may not be matching with the file extension."

This also means that other sheets that feed from this file are not being updated.

My flow is

when a new mail arrives with "XYZ" in the subject, for each attachment, create file in "123" library with file name

"name": "@item()?['name']",

"body": "@item()?['contentBytes']"

I've tried different "content" related options for content but none seem to be able to resolve the issue.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (4)

Report

Hi @RhysWilliams

Firstly, switch to classic designer by toggle off 'New designer' on the top right corner:

Next, in the loop before "Create file" action add "Get attachment" action to get the content of the email attachment. Pass the message ID & attachment id as shown below:

Finally, add create file action to save a file in SharePoint. Pass the attachment name & content dynamically as shown below:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

2 people found this reply helpful.

Was this reply helpful? Yes No
RhysWilliams 27 on at

Like (0)

Report

You beauty! Couldn't find any reference of the get attachment step in any posts I was following but it now works perfectly.

Was this reply helpful? Yes No