Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Sending auto email 30 days before due date

(0) ShareShare
ReportReport
Posted on by 12

Hello everyone!

I'm new at power automate. Can somebody assist me in creating a flow that will remind end users about their due equipment? Any help would be appreciated.

 

I've done below flow: 

Recurrence

Get future time for 30 days 

List items in a table

 

Thanks

  • z_prins Profile Picture
    z_prins 12 on at
    Re: Sending auto email 30 days before due date

    What is the expression I would need if I am trying to send an email 1 day before a due date? I am having a hard time finding help on this.

  • Ninovm Profile Picture
    Ninovm 12 on at
    Re: Sending auto email 30 days before due date

    Ninovm_0-1638176022619.pngNinovm_1-1638176084693.pngNinovm_2-1638176123237.png

    I already have this flow. but the mail i'm receiving is wrong as suppose on what it has on the excel file. i'm suppose to receive only 1 item and the other item to my colleague.

    Ninovm_4-1638176384155.png

     

     

  • Ninovm Profile Picture
    Ninovm 12 on at
    Re: Sending auto email 30 days before due date

    i have created below flow but with error.

     

    Ninovm_0-1638148822846.png

     

  • Gopala_Krishna Profile Picture
    Gopala_Krishna 1,459 on at
    Re: Sending auto email 30 days before due date

    @Ninovm 

    I have created a SharePoint list with the date column 'Test Date' 

    Gopala_Krishna_0-1638002293801.png

    We can add a OData filter query on the SharePoint "Get Items" action to filter the data to match our specified requirements

    Gopala_Krishna_1-1638002453045.png

    addDays(utcNow(),30,'yyyy-MM-dd')
     
    or 
     
    You can also make use the Filter Array action in Power Automate to filter the data as needed
     
     
    If the information shared helps you please consider giving a thumbs up 👍 and mark solution as resolved

    Please follow my website PowerCards for more information related to Power Platform

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,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard