web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / When a new email arriv...
Power Automate
Answered

When a new email arrives, save attachments to OneDrive with a preview

(0) ShareShare
ReportReport
Posted on by 6

this is the flow I created using a templet:

Tacurwick_0-1695076853105.pngTacurwick_1-1695076889528.png

The email being sent looks like this:

Tacurwick_2-1695076935016.png

but the file saves like this:

Tacurwick_3-1695076993449.png

 

and I get this error:

Tacurwick_4-1695077017883.png

 

I am trying to understand why the file is not saving as a PDF in OneDrive and why I can't get a preview or open it.

Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,508 Moderator on at

    @Tacurwick You haven't defined a file extension in the Create a file action. 

    Get the File Extension

    You can get the extension of the file from the Attachment Name.

    creativeopinion_0-1695078175609.png

     

    You can add Compose actions to your Apply to Each action to extract that information. The first Compose action is optional (however, if you are new to Power Automate—it'll make it easier to build the expression in the second Compose action).

    creativeopinion_1-1695078247732.png

     

    In the first Compose action, insert the Attachments Name dynamic content. 

    creativeopinion_2-1695078306485.png

     

    In the second Compose action, you are going to build an expression with two functions:

    • split() to split the attachment name at the period.
    • last() to get the extension after the attachment name has been split.

    Start with the split() function. The split() function takes two parameters:

    split([string to split],'[separator]')

    creativeopinion_3-1695078362127.png

     

    Switch to the Dynamic content tab and insert the outputs from the Compose action that has the Attachment Name.

    creativeopinion_4-1695078451980.png

    Add a comma and single quotes. Between the single quotes insert a period.

    creativeopinion_5-1695078489527.png

     

    This action will split the Attachment name at the period into an array. To get the last item in the array (aka the file extension) you need to wrap the entire expression in the last() function.

     

    Got to the start of the expression. Tip: Press the up arrow key.

     

    Insert last ( 

    creativeopinion_8-1695078636648.png

     

     

    Go to the end of the expression. Tip: press the down arrow key. 

     

    Insert a closing bracket.

    creativeopinion_7-1695078607313.png

     

    creativeopinion_0-1695157752594.png

    Run a test. Click on the Compose action to view the Outputs. Confirm that the extension of your attachment(s).

    creativeopinion_1-1695157855436.png

     

    Create File

    Add a Create File action. Ensure that you are inserting a period before you insert the outputs from the Compose action that contains the file extension.

    creativeopinion_3-1695158045189.png

     

    Insert the Attachments Content dynamic content in the File Content field of the Create File action. 

    creativeopinion_0-1695090803802.png

     

     

    Hope this helps!


    If I helped you solve your problem—please mark my post as a solution ✅.
    Consider giving me a 👍 if you liked my response!

    👉Watch my tutorials on YouTube
    👉Tips and Tricks on TikTok
  • Tacurwick Profile Picture
    6 on at

    Hello @creativeopinion! This has helped some, but I am still getting stuck, only now I can't figure out why it will not save.

    I was able to get this part updated:

    Tacurwick_0-1695155920610.png

    But when I go to add the next part and save it I get an error message saying " Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The repetition action(s) 'Apply_to_each_attachment_from_specific_user' referenced by 'inputs' in action 'Create_file_when_condition_is_satisfied' are not defined in the template.'.'. "

    Tacurwick_1-1695156202954.png

    At one point in the directions you say "Run a test. You'll see that the Compose action will now have the attachment extension." However, when I do that the Compose action does not have the attachment extension. I am also not sure where the formula that begins with first comes in.

     

    Many thanks!

     

  • Verified answer
    creativeopinion Profile Picture
    10,508 Moderator on at

    @Tacurwick I would recommend removing the Create file action in your flow first. I've updated the original instructions as I made an error with one of the screenshots. 

     

    Run a test at this point of your flow. Refer to the original post instructions. 

    creativeopinion_2-1695157932261.png

     

  • Tacurwick Profile Picture
    6 on at

    @creativeopinion This was helpful, thank you. 

    I was having issues saving the flow with what I had in there for the name. I can play around with that later, but when I took out the beginning formula it saved. I ran a test and it did not fail. My end result is confusing.

     

    the new formula for Create file step:

    Tacurwick_0-1695160793064.png

    everything checks out here, but then when I go into my files I have two? One that is the correct PDF attachment, the other that is some other type of attachment.

    Tacurwick_3-1695161817467.png

     

    Any idea what might be causing this?

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 251 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 239

#3
Expiscornovus Profile Picture

Expiscornovus 220 Most Valuable Professional

Last 30 days Overall leaderboard