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

Notifications

Announcements

Community site session details

Community site session details

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

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,502 Super User 2025 Season 2 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,502 Super User 2025 Season 2 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard