Enable to save an Outlook attachement to a SharePoint

[ZKBPCE-IT]

Hello everybody,

I have a problem with my flow saving an attachment to a SharePoint.

My problem is that the save file does not open with this error:
"Cannot open this workbook because the file format may not match the file extension."

I also noticed that my flow tries to save the file twice with the "Apply to each" action.

And in the version history of on SharePoint, I find that there are two versions but not with the same file size.

Do you have any idea about the cause of this problem? and potential solutions?

Thank you in advance for your feedbacks!

[Nived_Nambiar]

Hi @ZKBPCE-IT 

May i know what parameters are you passing to create file action ?

[ZKBPCE-IT]

Hi @Nived_Nambiar,

Here is the create file action :

Thank you in advance for your time

[Nived_Nambiar]

Hi @ZKBPCE-IT 

Normally it should work. Do you know why the flow is iterating twice in your case, is there any attachments inline with the email body like images or so ?

if the second iteration attachment is an image (may be from signature of email which has inline image) it is being converted to xlsx that may be reason why file is not opening

Just check what are attachments type in each iteration ?

[ZKBPCE-IT]

Yes, there's an image in the signature of the e-mail. 

Do you know how can i get just the attachement ?

[Nived_Nambiar · Accepted solution]

do one thing, after email is received, use filter array like below 

This will remove all attachments inline to email body, next use the body of the filter array to loop through to save attachments like below

Try this and let me know if it works 🙂

[ZKBPCE-IT]

Thank you for you help, 

I tried your solution but the flow fail to save the right file 

I can't acces the file

[ZKBPCE-IT]

Here is what i did 

I added the filter array action

then i created the file with the output of the filter array 

And i noticed that the file is saved 2 times, i found 2 versions of the file 

[Nived_Nambiar]

Hi @ZKBPCE-IT 

I could see you used a dynamic content from mail, But you try with contents from filter array only. 

Also, please confirm whether the output of filter array has attachments list which are not inline 

[ZKBPCE-IT]

Hi @Nived_Nambiar, 

I tried by creating the file without the condition before but it still returning the same problem

I tried all the possible solution, i knwo that the problem is the signature image but i don't know how to solve the issue

[Nived_Nambiar]

Hi @ZKBPCE-IT 

Before create file, could you place the compose action and passing attachment name dynamic content from filter array to see which file it is converting here ?

[ZKBPCE-IT]

Hi @Nived_Nambiar, 
sorry for this late reply.  Finally,

your solution worked for me, by removing the inline attachments.

Thank you so much for your help

[Nived_Nambiar]

Hi @ZKBPCE-IT 

Kindly mark appropriate answer as solution so that it could help others in future 🙂