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 / Power Automate Desktop...
Power Automate
Unanswered

Power Automate Desktop - Invoking a Send Outlook E mail action when adding 1 day to open day variable?

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I use the Add to DateTime Action to add 1 day to a open date variable called ResultedDate1 and then use a IF action to match the CurrentDateTime to the ResultedDate1 variable to send an email.  Do I have to convert the CurrentDateTime to text for it to recognize that 1 day has passed?  What am missing. Thanks for your help.

  • UshaJyothiKasibhotla Profile Picture
    225 Moderator on at

    I think you need to write the data table into Excel sheet and then send by using

    Launch excel sheet 

    Write to excel sheet action 

    And then send this attachment through mail

    Hope this helps 

    Ushaa

  • Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    If you want to compare two dates, you need to make sure that your dates do not include timestamps. I'm not sure what you have there in the "open date variable", but if there is no timestamp on it, it should be enough to just make sure that you select Get current date and time to only retrieve the current date without the time:

    Agnius_0-1698899940734.png

     

     

    Alternatively, you can convert both dates to text via Convert datetime to text using the same format on both and not including time.

    -------------------------------------------------------------------------
    If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

    I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

  • Srini007 Profile Picture
    3,490 Super User 2026 Season 1 on at

    Hi   @Anonymous 

     

    Check as below

    Srini007_1-1698919701848.png

     

     

     

    1) Use Get Current Date and Time action to get the Current Date and Time, This Stored in CurrentDateTime

    2) Use Add to Datetime action to add 1 to your CurrentDateTime Variable, This stored in ResultedDate

    3) Subtract Dates as ResultedDate - CurrentDateTime, which store in TimeDifference

    4) Now you can use IF condition according to your logic, Let suppose TimeDifference = 1 Then send the Email

     

    If you find this reply helpful, please consider giving it a LIKE AND

    If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

     

    Regards,

    Srini

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

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 245 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 233 Super User 2026 Season 2

#3
Valantis Profile Picture

Valantis 136 Super User 2026 Season 2

Last 30 days Overall leaderboard