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.
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.
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
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 !
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