Send email with document links when column equals today date

[Tbruns]

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?

[v-bacao-msft · Accepted solution]

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.

Please take a try.

Best Regards,

Barry

[Tbruns]

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

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?

[v-bacao-msft]

Hi @Tbruns,

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

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.

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.

Please take a try.

Best Regards,

Barry

[Tbruns · Accepted solution]

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.

[Tbruns]

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]

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

[Tbruns]

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.

[v-bacao-msft]

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.

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

[Tbruns]

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?

[Tbruns]

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

[v-bacao-msft]

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