Announcements
No record found.
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
@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
@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?
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.
@ufgeorge are you using Diffindays in power automate or as a calculated field?
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.
It will work as UTC Time
I see.
If result of Diffindays () is lower than 24hours, the result will show 0 because it is less than 1 day.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 137
Pallavi Phade 102 Super User 2026 Season 1
Abhilash Warrier 55 Super User 2026 Season 1
