Skip to main content

Notifications

Announcements

No record found.

Power Platform integration forum
Unanswered

Automation flow run before 7 days of a date parameter

Posted on by 3,962

I create a new date field in Dynamic CRM Account.

 

I am trying to add a new flow that can run 7 days before date store in this field and send an email.

 

But I really dont know how to write condition?

Please help, TKX.

 

George

  • RE: Automation flow run before 7 days of a date parameter

    @Mira_Ghaly 

    I see.

    If result of Diffindays ()  is lower than 24hours, the result will show 0 because it is less than 1 day.

  • RE: Automation flow run before 7 days of a date parameter

    @ufgeorge 

    It will work as UTC Time

     

  • RE: Automation flow run before 7 days of a date parameter

    @Mira_Ghaly 

    I use Diffindays in calc field.

    It can only use utcNow() in Power Automate.

     

    I don't know if I was wrong!

    Can you tell me Now() returns utc time or local time?

    Then I can decide how I can use it.

     

    TKX.

     

    George

  • RE: Automation flow run before 7 days of a date parameter

    @ufgeorge are you using Diffindays in power automate or as a calculated field?

     

  • RE: Automation flow run before 7 days of a date parameter

    @Mira_Ghaly 

    I found I can use:

    DiffInDays(NOW(), crb94_webschool_expire)

     

    But there is a question.

    now() shows date of my time zone.

    But date stored in CRM is UTC.

    How to correct it?

    TKX.

  • RE: Automation flow run before 7 days of a date parameter

    @Mira_Ghaly 

    This is a good way.

    But maybe a field to calculate how many days left...

    Then I can use this field = 30 to send a email, =7 send another...

     

    How to set calculate about this? utcNow() - datetime field?

  • RE: Automation flow run before 7 days of a date parameter

    @ufgeorge 

    I would add another calculated field .. 

    Mira_Ghaly_0-1622373543415.png

    Then you create a Recurrence flow that runs daily and Retrieves all records where Calculated Field = Today

    You can use the List Rows Action with FetchXML

     

     

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans