Send E-mail reminder based om expiration date and days befor experation both values in SharePointlist

(0) Share

Report

Posted on by DennisHass

Hello,

I have a question how to approach the following solution.

I want to send a weekly mail on the moment the today date is equal of within the days before the expiring date of the contract.

The value of the days before expiring are stored in the column "Opzegtermijn_x0028_dagen_x0029_" and the Expiring date is stored in the column "Einddatum".

This is how I approached it:

The Expression I used for dynamic content is:
formatDateTime(addDays(utcNow(),int(coalesce(triggerOutputs()?['headers']['Opzegtermijn_x0028_dagen_x0029_'], '0'))),'yyyy-MM-dd')

But it looks like the value in 'Opzegtermijn_x0028_dagen_x0029_' is always null.

But if I look at the output (below) the field/column is filled.

Does anyone know a solution?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

abouchaalaBAIT 932 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello @DennisHass
Here is how i would do it
Reccurence
create DaysBefore variable
create ExpiringDate variable
create TargetDate variable
Get all SharePoint items
Foreach SP Item
Store Einddatum in DaysBefore variable
Store Opzegtermijn_x0028_dagen_x0029_ in ExpiringDate variable
Calculate the TargetDate (ExpiringDate - DaysBefore) : using addDays function and store it in TargetDate variable
Condition if utcnow() between both date => send email else do nothing.
The optimal way will be to Get all SharePoint items that you need by filtering from the beginning.

Hope this helps
----------------------------------------------------------
If I have answered your question, please mark your post as Solved. 🆗✔️
If you like my response, please give it a Thumbs Up. 👍
You can accept more than one post as a solution.

Was this reply helpful? Yes No
Verified answer

DennisHass 9 on at

Like (0)

Report
Copy link

Link copied!

Thank you, that's an approach that could work.

I've come up with a different approach.
formatDateTime(addDays(utcNow(),int(items('Apply_to_each_-_mail_naar_iedere_contractbeheerder')?['Opzegtermijn_x0028_dagen_x0029_'])),'yyyy-MM-dd')

That did the trick.

Thanks for your suggetion.

Was this reply helpful? Yes No