Skip to main content

Notifications

Power Automate - General Discussion
Answered

scheduled reminder

(0) ShareShare
ReportReport
Posted on by 83

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:
  • GokhanA. Profile Picture
    GokhanA. 83 on at
    Re: scheduled reminder

    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.

  • Verified answer
    Anil_g Profile Picture
    Anil_g 668 on at
    Re: scheduled reminder

    @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

  • GokhanA. Profile Picture
    GokhanA. 83 on at
    Re: scheduled reminder

    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 !

     

  • Anil_g Profile Picture
    Anil_g 668 on at
    Re: scheduled reminder

    @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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard