cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Building flow to download link to csv report in a Gmail scheduled email to local drive?

Hi all,

 

I am completely new to Microsoft Flow and have seen similar posts on this topic, but most are from over a year ago and it seems like an integration with Parserr and other advancements may now make my goal possible. 

 

I am just trying to create a flow that takes the link in an email that I receive daily, downloads the .csv file that clicking on the link would download, and save the file to a designated path on my local drive. 

 

Any and all insights on approaches or workarounds are greatly appreciated!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Building flow to download link to csv report in a Gmail scheduled email to local drive?

Hi @jeannes626 ,

 

Do you want to download a .csv file from a link in the email and save it to your local device?

 

If the file is a binary, you can add a HTTP action to download the file and save the content using the “Create file”.

I have created a flow likes below for your reference.

 

As you mentioned, an email contains a link will arrive, please make sure the email body in the same format so that you could extract the link from the email body using a function likes below:

 

substring(body('Html_to_text'),add(indexOf(body('Html_to_text'),'Link'),5),sub(indexOf(body('Html_to_text'),'Name'),5))

 

In the action HTTP, select Compose output for the Uri field.

 

If you want to save the file to your local device, please consider using connector File system to Create file.

An image for your reference:

1.PNG

 

Further, about how to extract content from email body, please check the following thread for a reference:

https://powerusers.microsoft.com/t5/General-Flow-Discussion/Using-a-flow-to-extract-email-body-detai...

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Building flow to download link to csv report in a Gmail scheduled email to local drive?

Hi @jeannes626 ,

 

Do you want to download a .csv file from a link in the email and save it to your local device?

 

If the file is a binary, you can add a HTTP action to download the file and save the content using the “Create file”.

I have created a flow likes below for your reference.

 

As you mentioned, an email contains a link will arrive, please make sure the email body in the same format so that you could extract the link from the email body using a function likes below:

 

substring(body('Html_to_text'),add(indexOf(body('Html_to_text'),'Link'),5),sub(indexOf(body('Html_to_text'),'Name'),5))

 

In the action HTTP, select Compose output for the Uri field.

 

If you want to save the file to your local device, please consider using connector File system to Create file.

An image for your reference:

1.PNG

 

Further, about how to extract content from email body, please check the following thread for a reference:

https://powerusers.microsoft.com/t5/General-Flow-Discussion/Using-a-flow-to-extract-email-body-detai...

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
New Member

Re: Building flow to download link to csv report in a Gmail scheduled email to local drive?

Hi @v-yamao-msft this is exactly what I was looking for. Thank you!

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (10,564)