Answered

Saving and renaming email attachment to SharePoint

(0) Share

Report

Posted on by mtomova

Hi, I am trying to get an email attachment from Outlook, add the current month and year to the file name and save the file in a SharePoint location.

The problem I am getting is that once I have the file when I try to open it I get an error message -

"Excel cannot open the file "FileName.xlsx" because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file"

I suspect that the problem is coming from the way I try to get the file extension by using a Compose action and the following expression -

last(split(variables('AttachedFile-Name'), '.'))

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

trice602 16,164 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @mtomova ,

Here's one way to do it, please mark as a solution if this was helpful! I did a test with a jpg and an excel file. Always glad to help! Tom

I create four variables (code below). Also to help expand your knowledge of Power Automate, the last two variable expressions were created with Format data by Examples - this can really help you work through expression challenges and I provided the example for the AName at the very end.

1) Month (we want 08)
2) Year (we want 2023)
3) AName (we want the file name without the extension)
4) AType (we want the extension)

split(outputs('Get_Attachment_(V2)')?['body/name'], '.')[0]

slice(outputs('Get_Attachment_(V2)')?['body/name'], indexOf(outputs('Get_Attachment_(V2)')?['body/name'], '.'))

Example of Format data by Example for AName (how to get the attachment name without the extension)

Was this reply helpful? Yes No
mtomova 7 on at

Like (1)

Report
Copy link

Link copied!

Hi, thank you so much. It worked exactly as expected!

Was this reply helpful? Yes No
trice602 16,164 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Nice @mtomova ! I love it! I have found that in many cases the format data by example can be very helpful! Feel free to tag me in your future posts! If I can contribute to an answer, I will be glad to participate. Always glad to help! Tom

Was this reply helpful? Yes No