Automation flow run before 7 days of a date parameter

[ufgeorge]

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

[Mira_Ghaly · Accepted solution]

@ufgeorge 

I would add another calculated field .. 

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

[ufgeorge]

@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?

[ufgeorge]

@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.

[Mira_Ghaly]

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

[ufgeorge]

@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

[Mira_Ghaly]

@ufgeorge 

It will work as UTC Time

[ufgeorge]

@Mira_Ghaly 

I see.

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