cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Tbruns
Level: Powered On

Send email with document links when column equals today date

I have created a flow to send emails when the column titled "date created" is equal to todays date. The Flow works fine and sends the email.

What I am needing to do is add links in the email, to the documents that have today's date in the "date created" column.

What do I need to add to get the links in the emails?

12-04-2018 8-02-12 AM.jpg

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: Send email with document links when column equals today date

Hi @Tbruns,

 

You can use link to item to get the item link, then configure it in Select, create the Html table, and send it as the body of the email.

20.PNG22.PNG23.PNG

Please take a try.

 

Best Regards,

Barry

Community Support Team _ Barry
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

Tbruns
Level: Powered On

Re: Send email with document links when column equals today date

I added what you advised and pasted it below along with the results

And in the body of the email I only get this:

<table><tbody></tbody></table>

Please advise.

12-07-2018 7-51-40 AM.jpg

View solution in original post

11 REPLIES 11
Community Support Team
Community Support Team

Re: Send email with document links when column equals today date

Hi @Tbruns,

 

You can use link to item to get the item link, then configure it in Select, create the Html table, and send it as the body of the email.

20.PNG22.PNG23.PNG

Please take a try.

 

Best Regards,

Barry

Community Support Team _ Barry
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

Tbruns
Level: Powered On

Re: Send email with document links when column equals today date

Can you explain this as I have never used it before? Maybe example and where I get the info from etc? Thank you!

12-05-2018 8-00-31 AM.jpg

 

Also I just noticed my filter array is pulling a date of 2018-08-22 and NOT todays date. Any suggestions on how to correct that?

Community Support Team
Community Support Team

Re: Send email with document links when column equals today date

Hi @Tbruns,

 

You could type the expression I provided directly in Expression, and the expression of the link field is the same.37.PNG

For other fields, you could configure a Compose first, then select the Dynamic content of the corresponding field to fill it in, mouse over the Dynamic content and observe its composition.

Configure the part after  “items(‘Apply_to_each’)?”  in Select, following the expression I provided.

2018-12-06_091528.jpg

As for the date in the Filter array you said is incorrect, you could configure the field used to record the date in the condition, and use utcNow() on the right to get the today's date.

39.PNG

Please take a try.

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Tbruns
Level: Powered On

Re: Send email with document links when column equals today date

I added what you advised and pasted it below along with the results

And in the body of the email I only get this:

<table><tbody></tbody></table>

Please advise.

12-07-2018 7-51-40 AM.jpg

View solution in original post

Tbruns
Level: Powered On

Re: Send email with document links when column equals today date

Ok for whatever reason it started working now. How do I add the document name to the body of the email or is there a way to make the document name the link?

Tbruns
Level: Powered On

Re: Send email with document links when column equals today date

Disregard my last comments as I was able to follow your instructions and get it to work! Thank you so much!

Tbruns
Level: Powered On

Re: Send email with document links when column equals today date

The flow is working however it is sending the emails even when there is not a document that equals today's date. Any suggestions?

 

Also when it does send a hyperlink the users are not able to open the link. They do have access to the site.

Community Support Team
Community Support Team

Re: Send email with document links when column equals today date

Hi @Tbruns,

 

first question:

You could add a condition in front of Send an email action and send the message when the body of the Filter array is not empty.

83.PNG

second question:

The user may not be a member of the organization, or have no access to the corresponding list because you have set permissions.

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Tbruns
Level: Powered On

Re: Send email with document links when column equals today date

I tried adding the condition as you suggested and I am still getting emails when no documents have been added to the site (or when the date does not equal today). Any suggestions please?12-12-2018 8-06-47 AM.jpg

Tbruns
Level: Powered On

Re: Send email with document links when column equals today date

I would appreciate anyone's assistance on making this work please!

Community Support Team
Community Support Team

Re: Send email with document links when column equals today date

Hi @Tbruns,

 

First of all, you need to check whether there are links or related information in the email. If there is any, then the configuration of Flow is no problem. It may be because of the time zone, the date determined by Recurrence is not the expected date.

Alternatively you could try to replace the expression in the Condition with this:

@not(equals(length(body('Filter_array')), 0))

Take a try again.

 

Best Regards,

Barry

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

Helpful resources

Announcements
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!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (3,928)