Automation flow run before 7 days of a date parameter

(0) Share

Report

Posted on by Power Platform Comm...

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

I have the same question (0)

All responses (7)

Answers (0)

Power Platform Comm... 8 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

@ufgeorge

It will work as UTC Time

Was this reply helpful? Yes No
Power Platform Comm... 8 on at

Like (0)

Report

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

Was this reply helpful? Yes No