expiry date should equal: minus 30 days formula (todaysdate - 30 days?

(0) Share

Report

Posted on by Community Power Pla...

Good day,

i have a List with and Expiry Date Column and i need a Notification email to be sent 30 days prior the Expiry date.

What should the formula look like? @equals(substring(item()?['Expiry Date'], 0, 10), utcnow('yyyy-MM-dd'))

Where should the minus 30 days be added?

many thanks

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-xida-msft on at

Like (1)

Report
Hi @Anonymous,

The formula that you provide above could not be able to achieve your needs.
Please take a try with the following formula:

@equals(formatDateTime(utcNow(), 'MM/dd/yyyy'), formatDateTime(addDays(item()?['Expiry_x0020_Date'], -30), 'MM/dd/yyyy'))

More details about the usage of formatDateTime() function and addDays() function, please read the article as below:
https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

Best regards,
Kris

Was this reply helpful? Yes No
421 4 on at

Like (0)

Report

Hello @v-xida-msft ,
May you please help me with something similar? I'm new to flow and I have a SP list with column for date 'Due Date'. I want to send the notification with flow to the person in charge 3 days before the 'Due Date'. I could get the recipients e-mails from other column in the list - 'AssignedTo', no problem with that. I begin the flow with recurrence(I will set it to run one time a day), than I want to use the 'Filter query' in Get items, but I'm not exactly sure how could I achieve the right filter with adddays.

I will be very grateful, if you could help me with that.

Kind Regards

Was this reply helpful? Yes No
421 4 on at

Like (0)

Report

Hello @v-xida-msft ,

I managed to do the job, please don't take my questions in consideration.

Kind Regards
Boyan

Was this reply helpful? Yes No
Share-and-Flow 32 on at

Like (0)

Report

hi @421
I am here looking for a similar solution.
My reminders will be sent 60,30 and 15 days before expiry date.
How did you do it?

Thanks

Was this reply helpful? Yes No