Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Issue making flow for sending email 30 days after specified date

(0) ShareShare
ReportReport
Posted on by

I'm trying to make a flow that will grab dates from a column called "Invoice Sent" in a Sharepoint list, then send me an email once it hits 30 days PAST any dates in the "Invoice Sent" column. The dates are formatted as dd-mm-yyyy. I want it to run once a day, and I only want to get an email on the day it becomes 30 days past due.

 

I've tried using bits and pieces from other forum posts that were similar to my issue, but I have yet to have any success. I only put the "InvoiceSent ge '01/01/2020'" part to encompass every date in the column-- this might not be necessary. This is what I have so far:

 

flow.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I really appreciate any help!

  • SudeepGhatakNZ Profile Picture
    14,381 Most Valuable Professional on at
    Re: Issue making flow for sending email 30 days after specified date

    Please try

    InvoiceSent ge 'formatDateTime('01/01/2020',dd-MM-yyyy')'

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1