Unanswered

Building a flow for emailing expiry date notifications to a user

(0) Share

Report

Posted on by Limahhui

Hi all , i need to make a flow which reads one column of an excel file called expiry dates. Whenever the training expiry date is reaching 30 days before it expires, it sends an email prompt to a user . Thanks for the help in advance!

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Rhiassuring 8,690 Moderator on at

Like (1)

Report

Hi there,

You'll need a daily recurrence for this.

Your first action will be "Get Rows from a Table". Point the fields to your file, and the table within your file. Be sure to set Date / Time to ISO 8601 in the dropdown. In the filter query, make it ExpiryDate eq 'xxxxx', where "ExpiryDate" is the name of the column that holds your date, and "xxxxx" is an expression which is as follows: addDays(utcNow(),-30,'yyyy-MM-dd')

Then, "Send an Email" - and point the "To" at whatever column you hold that data in. It'll turn into an Apply to Each (but if there's only one entry for that date found, it will only send one; if there's multiple, it'll send multiple; if there's none, it'll send nothing.)

Was this reply helpful? Yes No
Limahhui 16 on at

Like (0)

Report

Hi if i want to make it so that if my expiry date is coming 30 days or lesser from now, it will send an email . How can I do that. Also i couldnt find 'Get rows from a table' . 'Is get a row same' ? because i do not have the filter query. For 'Send an Email ' , How does it work ? because isnt "To" for the person that will receive the email? Thanks

Was this reply helpful? Yes No