Unanswered

scheduled reminder

(0) Share

Report

Posted on by GokhanA.

Hello Team,

I am facing an issue with the two applications I am developing due to the "scheduled reminder" topic. Therefore, I would like to ask for your support.

Here is the situation:

In my application, which is connected to the "List" database, I have two date columns named "discount payment date" and "legal deadline date." Additionally, I have a "Status" column. I want the application to send emails to the relevant individuals 5, 4, 3, 2, and 1 day before the dates in the "discount payment date" and "legal deadline date" columns for rows where the "status" is not "completed."

I hope I have provided enough information.

Thank you in advance.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Anil_g 668 Moderator on at

Like (0)

Report

@gokhanarda

1. Trigger daily
2. Get List items with filter on status and date(Here add greater than 1 day and less than 5 days)
3. Loop and send reminder

cheers

Was this reply helpful? Yes No
GokhanA. 83 on at

Like (0)

Report

Thanks for your support @Anil_g,

When looking at the topic from a broader perspective, I agree with your suggested approach. In fact, I am also sending out an informational email. However, the issue we are facing is that the process runs on records with dates in the mentioned columns from -∞ or +∞. I want this to start only 5 days before the dates in the relevant columns and to stop once the recorded date in the column is reached.
I would appreciate it if you could provide more details on this matter.

cheers !

Was this reply helpful? Yes No
Verified answer

Anil_g 668 Moderator on at

Like (0)

Report

@gokhanarda

That is where the filter is helpful where you would get only those items with todays date plus 5 or less..compose will help in adding days and getting 5 days plus the date then can be sued in the filter date lt 'outputofcompose' and date gt 'output of second compose'

in compose use formatDateTime(addDays(utcNow(), 5), 'yyyy-MM-dd') - this si for 5 days similarly one mroe compose for 1 day

cheers

Was this reply helpful? Yes No
GokhanA. 83 on at

Like (1)

Report

Hi @Anil_g,

Thank you for your response. I resolved my issue with your suggestion. However, I found that I encountered a problem at each step of the process. Consequently, detailed procedures are required to handle notifications such as 5 days before, 4 days before, and 3 days before in the multi-select person and group column. I resolved these procedures with the help of the video found at this YouTube link.

Working with multi-select person fields in Get items output

Thanks.

Was this reply helpful? Yes No