Answered

File Type Error when uploading Excel email attachment to Sharepoint

(0) Share

Report

Posted on by ekru222

When attempting to automate the upload of an excel email attachment when I attempt to change the name of the attachment I receive the "This workbook couldn't be opened because the file format may not be matching with the file extension." error.

If I use the attachment name control this error does not occur. Any ideas how to save an excel attachment to a sharepoint folder with a different name? I've looked extensively at the existing questions surrounding this issue out there but none address changing the name of the attachment.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Please upload a screenshot of your flow

Was this reply helpful? Yes No
ekru222 69 on at

Like (0)

Report
Copy link

Link copied!

This is where the error is. Whenever I attempt to hard code a File Name, for example 'Test.xlsx', the file will not open. However if I use the attachment's name, as seen in the screenshot, it works fine.

Was this reply helpful? Yes No
Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@ekru222 I think you have the actions in a loop. It is attempting to convert all attachment to excel and hence failing.

Please note any embedded images in the email (such as signatures) are also treated as attachments.

Was this reply helpful? Yes No
ekru222 69 on at

Like (0)

Report
Copy link

Link copied!

Yes I'm pretty sure that was it. I found a work around and haven't retested it, but I do have a signature and that was probably messing with it in the way you describe.

Was this reply helpful? Yes No