You’re offline. This is a read only version of the page.
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
You beauty! Couldn't find any reference of the get attachment step in any posts I was following but it now works perfectly.
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.
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (