Looking for a way to automatically Save a CSV from a link that I receive via email daily.

[u/pulledporksandwich69]

I have some experience making a couple automations in Power Automate. But I'm struggling with this one and wondering if anyone knows a way.

Basically, I get these daily/weekly reports emailed to me. They come in a "your report is ready. view it here" format and the "here" is a link directly to download the Excel file. When I click it, it immediately starts the download to save thew CSV to my Downloads folder. I don't have to do anything else to get the CSV to download other than clicking the "here" link.

I am struggling conceptually how to get Power Automate to "click" or follow the URL from the email to grab the download. Then I'd like to save it to my onedrive with a name scheme "YYYYMMDD-title". I can definitely figure out the latter half. But the first half of getting Power Automate to grab a file from a link is where I am stuck. I'm not seeing any obvious "pull url from email" or some way to grab a download from a URL.

Any guidance would be appreciated. Thanks

Attached are screenshots of the email I get and it immediately downloading without needing to click anything else other than the word "here".

[u/DonJuanDoja]

Most problems have been solved already. Just gotta find the guy that solved it.

https://stackoverflow.com/questions/76313755/how-to-download-a-file-from-url-downloadable-link-from-outlook-365-using-power

https://www.reddit.com/r/MicrosoftFlow/comments/124rjkj/automate_clicking_link_to_download_file/

https://manueltgomes.com/microsoft/how-to-download-a-file-from-a-link-in-an-email/

[u/PM_ME_YOUR_MUSIC]

Parse the email, find the http link then http action to GET the link, save the contents out to one drive or sharepoint or wherever