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

Notifications

Announcements

Welcome to the Power Platform Communities
Forum hierarchy changes are complete!
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Saving an Attachment f...
Power Automate
Unanswered

Saving an Attachment from Outlook that comes in the form of a Link

(0) ShareShare
ReportReport
Posted on by JustLetitFlow 18

Hello, I am at the very last item on my list to automate that will make my EOM report system 100 % automated but I can't figure it out. I have one report that comes on the 1st of the month and it has no attachment but rather a link to download the .CSV file from.  How do I go about automating this I need to download and send to OneDrive to its specified folder. HELP!

Categories:
Building flows
I have the same question (0)
  • v-wenjuan-msft Profile Picture
    v-wenjuan-msft Microsoft Employee on at

    Hi @JustLetitFlow ,

     

    I found a similar thread for your reference:

    Solved: Automatically download a file that is in an url li... - Power Platform Community (microsoft.com)

     

    To be brief, key point is to get the link. After that we only need to send a request to the uri to download the file.

    Feel free to share an email template for further test if you still need my help.

     

    Community Support Team _ Wenjuan Zou

    If this post helps, then please consider Accept it as the solution to help the other members find it.

  • JustLetitFlow Profile Picture
    JustLetitFlow 18 on at

    Hello! Thank you for your speedy response. I have attached a copy of the email I receive as a PDF. Do I need just the url (highlighted in yellow) or would I need to input the long link that lives in the Download button? Also would that be one of the premium options? Thank you so much for your kindness and help. 

    Malina sent a CSV...
  • v-wenjuan-msft Profile Picture
    v-wenjuan-msft Microsoft Employee on at

    Hi @JustLetitFlow ,

     

    I think it should be the url.

    But I cannot reproduce your email with such template, would you please copy the outputs of email body to me for further test?

    vwenjuanmsft_0-1687916369856.png

     

    Community Support Team _ Wenjuan Zou

    If this post helps, then please consider Accept it as the solution to help the other members find it.

  • JustLetitFlow Profile Picture
    JustLetitFlow 18 on at

    I copied to my clipboard this:

    {"id":"ec0f3655-c035-476d-9ba3-1a0a3b8fed30","brandColor":"#8C6CFF","connectionReferences":{"shared_office365":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_office365/connections/shared-office365-08508d90-67aa-4c92-9768-f3246eecd102"}},"shared_onedriveforbusiness":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_onedriveforbusiness/connections/shared-onedriveforbu-93b39196-32f6-46f3-8247-6a84-3a3a766a"}}},"connectorDisplayName":"Data Operations","icon":"https://content.powerapps.com/resource/makerx/static/pauto/images/designeroperations/dataoperationedit.2c8a4d5e.png","isTrigger":false,"operationName":"Compose","operationDefinition":{"type":"Compose","inputs":"@items('Apply_to_each')?['body']","runAfter":{}}}

    I am sorry, I am not very good with the coding part of Power Automate, yet. 
    Also it keeps wrapping "Compose" in to "Apply to Each", which is not what your screenshot shows so I am wondering if I am providing the correct information to you. 

    JustLetitFlow_0-1687977601000.png

    I appreciate all your help with this 🙂 



  • v-wenjuan-msft Profile Picture
    v-wenjuan-msft Microsoft Employee on at

    Hi @JustLetitFlow ,

     

    Thanks for your information! But I'm afraid you pick the wrong one.

    Please notice the highlighted subtitle of "Body". It should be like this:

    vwenjuanmsft_0-1688005801566.png

     

    Best regards,

    Community Support Team _ Wenjuan Zou

  • JustLetitFlow Profile Picture
    JustLetitFlow 18 on at

    HI I took a very quick video of what I am doing because I thought I was following your steps. Here is a link to my video, it was too big to attach with the comment Power Automate: Vid for Question in Community  
    If you prefer I share a different, feel free to let me know. I am curious to know it I am selecting "Body" correctly because it keeps wrapping the step in to "Apply Each""

  • v-wenjuan-msft Profile Picture
    v-wenjuan-msft Microsoft Employee on at

    Hi @JustLetitFlow ,

     

    Thanks for your effort. Turn this setting on and try to insert "Body" again:

    vwenjuanmsft_0-1688091467172.png

    If it works as my demo, run it and copy its outputs. Thank you~

     

    Best regards,

    Community Support Team _ Wenjuan Zou

  • JustLetitFlow Profile Picture
    JustLetitFlow 18 on at

    Thank you, ok copied from the clipboard ad got this, is this what you needed?
    {"id":"2a2fe2ff-c7c6-4637-894f-6cc4a1877771","brandColor":"#8C6CFF","connectionReferences":{"shared_office365":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_office365/connections/shared-office365-08508d90-67aa-4c92-9768-f3246eecd102"}},"shared_onedriveforbusiness":{"connection":{"id":"/providers/Microsoft.PowerApps/apis/shared_onedriveforbusiness/connections/shared-onedriveforbu-93b39196-32f6-46f3-8247-6a84-3a3a766a"}}},"connectorDisplayName":"Data Operations","icon":"https://content.powerapps.com/resource/makerx/static/pauto/images/designeroperations/dataoperationedit.2c8a4d5e.png","isTrigger":false,"operationName":"Compose","operationDefinition":{"type":"Compose","inputs":"@triggerBody()?['body']","runAfter":{}}}

    I also did a sneak peak and took a photo 

    JustLetitFlow_0-1688596873990.png

     

  • JustLetitFlow Profile Picture
    JustLetitFlow 18 on at

    Hello, @v-wenjuan-msft  , I apologize I didn't understand what you  needed at first but now I understand and I have run it and have the out outputs. I am not sure which one you need exactly so I am going to give you all  Outputs for "Compose" 
    <html><head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="Generator" content="Microsoft Word 15 (filtered medium)"><style>
    <!--
    @font-face
    {font-family:Helvetica}
    @font-face
    {font-family:"Cambria Math"}
    @font-face
    {font-family:Calibri}
    @font-face
    {font-family:"Arial Nova"}
    p.MsoNormal, li.MsoNormal, div.MsoNormal
    {margin:0in;
    font-size:11.0pt;
    font-family:"Calibri",sans-serif}
    a:link, span.MsoHyperlink
    {color:blue;
    text-decoration:underline}
    .MsoChpDefault
    {font-size:10.0pt}
    @page WordSection1
    {margin:1.0in 1.0in 1.0in 1.0in}
    div.WordSection1
    {}
    -->
    </style></head><body bgcolor="#EEF1F2" lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word"><div class="WordSection1"><p class="MsoNormal">&nbsp;</p><div><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%; background:#EEF1F2; border-collapse:collapse"><tbody><tr><td width="100%" style="width:100.0%; padding:0in 0in 0in 0in"><div align="center"><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="600" style="width:6.25in; border-collapse:collapse"><tbody><tr style="height:5.0pt"><td width="100%" style="width:100.0%; padding:0in 0in 0in 0in; height:5.0pt"></td></tr><tr style="height:15.0pt"><td width="100%" style="width:100.0%; padding:0in 0in 0in 0in; height:15.0pt"></td></tr></tbody></table></div></td></tr></tbody></table></div><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%; background:#EEF1F2; border-collapse:collapse"><tbody><tr><td width="100%" style="width:100.0%; padding:0in 0in 0in 0in"><div align="center"><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="600" style="width:6.25in; border-collapse:collapse"><tbody><tr style="height:7.0pt"><td style="background:#46C6AD; padding:0in 0in 0in 0in; height:7.0pt"></td></tr><tr style="height:13.0pt"><td width="100%" style="width:100.0%; background:#46C6AD; padding:0in 0in 0in 0in; height:13.0pt"><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%; border-collapse:collapse"><tbody><tr><td width="15" valign="top" style="width:11.25pt; padding:0in 0in 0in 0in"><p class="MsoNormal" align="center" style="text-align:center">&nbsp;</p></td><td width="40" valign="top" style="width:30.0pt; padding:0in 0in 0in 0in"><p class="MsoNormal"><img width="33" height="33" id="_x0000_i1026" src="https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fusanorth811.satmetrix.com%2fapp%2fcore%2fmain%2fimages%2ficon-email2.png&amp;c=E,1,O1Fp8Oj8Fdx1v2C9rt9Fa2EUy291X_vUvNQfEougk59gQ4-eObfTnIHT-cXZUPrRCluC7Ly3lO0MVE6GVhKzc4FX_pS4uexvPZzfeE4iaX3k3pT_b7zcSYYh&amp;typo=1" style="width:.3472in; height:.3472in"></p></td><td style="padding:0in 0in 0in 0in"><p class="MsoNormal"><span style="font-size:15.0pt; font-family:&quot;Helvetica&quot;,sans-serif; color:white">Malina sent a daily PDF</span></p></td><td width="15" style="width:11.25pt; padding:0in 0in 0in 0in"><p class="MsoNormal"><span style="font-size:15.0pt; font-family:&quot;Helvetica&quot;,sans-serif; color:white">&nbsp;</span></p></td></tr></tbody></table></td></tr><tr style="height:5.0pt"><td width="100%" style="width:100.0%; background:#46C6AD; padding:0in 0in 0in 0in; height:5.0pt"></td></tr><tr style="height:12.5pt"><td width="100%" style="width:100.0%; background:white; padding:0in 0in 0in 0in; height:12.5pt"></td></tr><tr><td style="background:white; padding:0in 0in 0in 0in"><div align="center"><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="95%" style="width:95.0%; border-collapse:collapse"><tbody><tr><td style="padding:0in 0in 0in 0in"><p class="MsoNormal" style="line-height:17.25pt"><span style="font-size:10.0pt; font-family:&quot;Helvetica&quot;,sans-serif; color:#606060">Hello,<br>Malina sent a daily PDF for the 'DPS Surveys Previous Day' chart to you</span></p></td></tr></tbody></table></div></td></tr><tr style="height:12.5pt"><td width="100%" style="width:100.0%; background:white; padding:0in 0in 0in 0in; height:12.5pt"></td></tr><tr style="height:22.0pt"><td width="100%" valign="top" style="width:100.0%; background:white; padding:0in 0in 0in 0in; height:22.0pt"><div align="center"><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="211" style="width:158.25pt; border-collapse:collapse"><tbody><tr style="height:20.0pt"><td width="368" style="width:276.0pt; background:#46C6AD; padding:0in 0in 0in 0in; height:20.0pt"><p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:12.0pt; font-family:&quot;Helvetica&quot;,sans-serif; color:#606060"><a href="https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fusanorth811.satmetrix.com%2fapp%2fcore%2fservice%2fscheduleexport%3ffilename%3d313600000000000000004a645d81e8e9566ca708fa209e7377d44f8c99af09a831479a40b22c730a239a82c3c624fe7ec740eb67949cee4a8f1c1bb1f8f9402011068c45cb803cf5c5300e48afeecaadab5c2707cd2fa942f16f9d141f939f6d78c811b0b2772bb69d4c8d4d1e422a7d8fc8abc419ee01f37183af522ff7d7be0fd9a09568251ae85cdd4c964717edf2b9ca7ed474aeadec92a54ec9edbda8f7bf4a47255149132d9db607eb573151bac87faa5905870b484b0f&amp;c=E,1,vfMGZQRPbOy2Qx25i8NzJWi3TpgUqlyEusjhvmVzcIuThau0x8lXnrx2NEhmJ0Wqtzrl3cAzaWr5iSFUkxmgShkTtE4rrDFT24CbNo594xz3ySk,&amp;typo=1"><span style="color:white; text-decoration:none">DOWNLOAD</span></a></span></p></td></tr><tr style="height:2.5pt"><td style="padding:0in 0in 0in 0in; height:2.5pt"></td></tr></tbody></table></div></td></tr><tr style="height:22.0pt"><td style="background:white; padding:0in 0in 0in 0in; height:22.0pt"><div align="center"><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" style="width:100.0%; border-collapse:collapse"><tbody><tr style="height:.75pt"><td width="100%" valign="top" style="width:100.0%; border:none; border-top:solid #EEEEEE 1.0pt; padding:0in 0in 0in 0in; height:.75pt"><p class="MsoNormal"><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#515151">&nbsp;</span></p></td></tr><tr><td width="100%" style="width:100.0%; padding:0in 0in 0in 0in"><p class="MsoNormal" align="center" style="text-align:center"><strong><span style="font-size:8.5pt; font-family:&quot;Arial&quot;,sans-serif; color:#A8A8A8; font-weight:normal">Site name: </span></strong><span style="font-size:8.5pt; font-family:&quot;Arial&quot;,sans-serif; color:#515151">USANORTH811</span><strong><span style="font-size:10.5pt; font-family:&quot;Arial&quot;,sans-serif; color:#515151">&nbsp;&nbsp;</span></strong><strong><span style="font-size:8.5pt; font-family:&quot;Arial&quot;,sans-serif; color:#A8A8A8; font-weight:normal">URL: </span></strong><span style="font-size:8.5pt; font-family:&quot;Arial&quot;,sans-serif; color:#515151"><span class="MsoHyperlink"><span style="color:#6CA898; text-decoration:none">https://usanorth811.satmetrix.com</span></span></span><span style="font-size:10.0pt; font-family:&quot;Arial&quot;,sans-serif; color:#515151"></span></p></td></tr></tbody></table></div></td></tr><tr style="height:5.0pt"><td style="background:white; padding:0in 0in 0in 0in; height:5.0pt"></td></tr></tbody></table></div></td></tr></tbody></table><div><p class="MsoNormal">&nbsp;</p><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="100%" id="backgroundTable" style="width:100.0%; background:#EEF1F2; border-collapse:collapse"><tbody><tr><td width="100%" style="width:100.0%; padding:0in 0in 0in 0in"><div align="center"><table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="600" style="width:6.25in; border-collapse:collapse"><tbody><tr style="height:20.0pt"><td width="100%" style="width:100.0%; padding:0in 0in 0in 0in; height:20.0pt"></td></tr><tr><td style="padding:0in 0in 0in 0in"><p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:11.5pt; font-family:&quot;Helvetica&quot;,sans-serif; color:#484949">Thank you,</span></p></td></tr><tr style="height:3.5pt"><td width="100%" style="width:100.0%; padding:0in 0in 0in 0in; height:3.5pt"></td></tr><tr><td style="padding:0in 0in 0in 0in"><p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:11.5pt; font-family:&quot;Helvetica&quot;,sans-serif; color:#484949">The Customer Experience Program Team </span></p></td></tr><tr style="height:45.0pt"><td width="100%" style="width:100.0%; padding:0in 0in 0in 0in; height:45.0pt"></td></tr><tr style="height:12.0pt"><td style="padding:0in 0in 0in 0in; height:12.0pt"><p class="MsoNormal" align="center" style="text-align:center"><a href="https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fwww.satmetrix.com&amp;c=E,1,PitsB04q6ILu38ClZTb2GHKCiZBRpXG30OuKcLpXBUOf6s4le8ArQ8g_7pJVGoRINhqfzy7Qeg4WIe35ZkeBGQV175_WlLza8lInPZBWCA,,&amp;typo=1" target="_blank"><span style="text-decoration:none"><img border="0" width="129" height="16" id="_x0000_i1025" src="https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fusanorth811.satmetrix.com%2fapp%2fcore%2fmain%2fimages%2fxpui%2fNiceSatmetrixLogo.png&amp;c=E,1,0_71p95fzNNuqvM_Hre1onfyJtczZyrw682hroncONO28Y8y8G-x8Ca8HFmYW-KLM6QUQKgGAVa03DbY5bj7ZPjssjL8arfp_TxBuhX9u61GwsVAL3ZBk3MAQ6g,&amp;typo=1" style="width:1.3472in; height:.1666in"></span></a></p></td></tr><tr style="height:7.0pt"><td width="100%" style="width:100.0%; padding:0in 0in 0in 0in; height:7.0pt"></td></tr><tr><td style="padding:0in 0in 0in 0in"><p class="MsoNormal" align="center" style="text-align:center"><span style="font-size:10.0pt; font-family:&quot;Helvetica&quot;,sans-serif; color:#686868"><a href="https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fniceprod.service-now.com%2fcustomer_service%2f&amp;c=E,1,Ln8KJu1GTvuGdrzXhsovuvlVNeykrWBF43OP2DbIeGdr6ihxs9x1BZxsnIECtji1quFlIIpd4l8pxyMFQ3crtG31KPp1fVlfb0wHklL9zlKX7UhyhqEWs50nBCYG&amp;typo=1"><span style="color:#686868; text-decoration:none">CUSTOMER SUPPORT</span></a> </span></p></td></tr><tr style="height:20.0pt"><td width="100%" style="width:100.0%; padding:0in 0in 0in 0in; height:20.0pt"></td></tr></tbody></table></div></td></tr></tbody></table><p class="MsoNormal">&nbsp;</p></div></div></body></html>

     
  • JustLetitFlow Profile Picture
    JustLetitFlow 18 on at

    crossing my fingers that I was able to provide you with what you need to assist me. I appreciate you!

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

News and Announcements

Welcome to the Power Platform Communities
Forum hierarchy changes are complete!
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 506 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 425 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans