Answered

Send email 30 days before expiry date

(0) Share

Report

Posted on by mr-samd

Hi,

I have a flow that I cant quite get right. I have a stock list with an expiry date column. I want to receive an email 30 days before the expiry date, reminding me to order some new stock. I have followed guides online and am receiving emails for all items in the list, no matter if the due date is within 30 days or not.

The formula I am using in the condition is:

formatDateTime(addDays(utcNow(), 30), 'MM/dd/yyyy')

any tips on how to get this to work would be appreciated.

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (1)

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Hi @mr-samd

Have you considered using a filter on the get items action?

expirydate le 'formatDateTime(addDays(utcNow(), 30), 'MM/dd/yyyy')'

This uses the column name and requires that the date is in the correct format. You can check the date format in the history output of the get items actions.

You could then use the Create HTML table action on the results of your get items and simply include the HTML table in you send email with no need for an apply to each or condition.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

Was this reply helpful? Yes No
mr-samd on at

Like (0)

Report

Hi Damien,
Thanks for your help. I have tried to follow your advice but for some reason the filter is saying its not valid.

The expression "expirydate le 'formatDateTime(addDays(utcNow(), 30), 'MM/dd/yyyy')'" is not valid. Creating query failed.

I dont know if its because im not referencing my list column properly or ive put it in wrong somehow.
Any further explanation of how to input this would be very helpful.

Was this reply helpful? Yes No
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Hi @mr-samd

You need to type or paste the expression in the expression tab and not as plain text or it will not evaluate.

paste: formatDateTime(addDays(utcNow(), 30), 'MM/dd/yyyy') into the expression tab, next to the dynamic content tab

Damien

Was this reply helpful? Yes No
mr-samd on at

Like (0)

Report

Oh ok sorry,
This now gives a new error:

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Hi @mr-samd

It's possible that it should be in the format yyyy/MM/dd - give that a go.

Damien

Was this reply helpful? Yes No
mr-samd on at

Like (0)

Report

Sadly that did not help. I think the issue lays with referencing the column. The "expirydate le " bit on the front of the function you gave says its invalid.

expirydate le 'formatDateTime(addDays(utcNow(), 30), 'MM/dd/yyyy')'

Was this reply helpful? Yes No
mr-samd on at

Like (0)

Report

This is what I am trying and getting the following error:

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

@mr-samd you're also missing ' ' around the date.

Damien

Was this reply helpful? Yes No
mr-samd on at

Like (1)

Report

THATS IT! Thankyou.

Was this reply helpful? Yes No
therrean 76 on at

Like (0)

Report

I am having the same issue with my flow not working will you be able to help?

Was this reply helpful? Yes No