4
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 see.
If result of Diffindays () is lower than 24hours, the result will show 0 because it is less than 1 day.
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
@ufgeorge are you using Diffindays in power automate or as a calculated field?
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.
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?
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
#1
Adis
136
Super User 2025 Season 1
#2
Sohail Ahmed
81
#3
Jonas "Jones" Melgaard
77
Super User 2025 Season 1
Share
Report
All responses (
Answers (
