web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Email Reminder with mu...
Power Automate
Unanswered

Email Reminder with multiple condition and calculated columns

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi Automate Community,

 

I am trying to build a flow that sends out an automatic email 30 days prior to expiration date. Here are the conditions. Each row there are three starting dates and three expiration days(calculated fields). There are three status as well. I only care if the status is active. The expiration date format are like this "2023-05-12T05:00:00Z". They only have T05:00:00Z or T06:00:00Z at the end. But get time will get me the exact minute. And I am not sure if my condition inside apply to each will work.

 

I have really ran out of solutions.

zephrus_f4001_0-1680619298863.png

 

if anyone could help me, thank you so much in advance

 

Categories:
  • Sundeep_Malik Profile Picture
    6,501 on at

    Hey @Anonymous 

     

    Why dont you just match the dates in both?

     

    write the following expression in the condition:

     

    Left side

    formatDateTime(urDateinSP,'MM-dd-yyyy')

    Right Side

    formatDateTime(FutureDate,'MM-dd-yyyy')

     

    or you can do one more thing as well

     

    on right side just add

     

    addDays(utcNow(),30,'MM-dd-yyyy')

     

    on left side add:

    formatDateTime(urDateinSP,'MM-dd-yyyy')

     

     

    Dont bring time in this scenario, it will make it complicated.

     

    I hope this helps 🙂

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 299

#2
11manish Profile Picture

11manish 274 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 119

Last 30 days Overall leaderboard