Skip to main content

Date Field Shows Wrong Date in Power Automate

We recently noticed the Power Automate Trigger body showing a date prior to the date selected in CRM.
This behavior was not expected because the field was set to Date Only and so the time zone would not cause this problem.

However, after discussion we found that :
The behavior of field was set to User Local and so when this field will be set it will be seen as per the user time zone settings as Power Automate processes the Date in UTC Format.
All existing date/time fields in CRM are set as User Local by default.

Given below are the two approaches by which we can get the proper date in Power Automate.

Approach 1:
Create a new field in CRM with Format and Behavior set to Date Only.
The date for this field will be correctly captured by trigger in power automate.

Approach 2:
Create a formula in Power Automate to add 1 day to the date coming from CRM, using add days expression.
Adddays(parameter from which date is coming from, number of days to add, format of date[optional])


Popular posts from this blog

Understanding Dynamics 365 CRM- Part 1

Introduction:In this post I plan to walk you through some concepts and functional aspects of CRM module of Dynamics 365.  We will look into a vast used module of D365 CRM which is Sales in Part 1 of this blog and we shall look into other modules in Part 2
Pre-requisites: Microsoft Office 365 An instance of CRM Dynamics 365/ Trial account.

In Case you don't have a trial account, you can create one on,
For details on how to create an account, Visit my post:
Theory:CRM as we all know is Customer Relationship Management and is majorly used to maintain data with respect to Sales, Customer Tickets, etc.
We have two major parts to understand for working with CRM, Sales and Customer Service. In earlier versions of D365 CRM, we had  three modules Marketing, Sales and Customer Service. The New UI however looks like below:

This new UI as we see does not have marketing Module as it is been no…

Working with Solutions in CRM Dynamics

In this post, we will read about solutions,Components and  Import-Export of solutions in  Dynamics CRM. Also we will see working with both the old and new interface of Dynamics CRM.

Pre- requisites:
An instance of CRM Dynamics 365/ Trial account. Theory:Solutions are used to extend business functionalities in CRM. Solutions provide a framework for packaging, installing, and uninstalling components to match your business functionalities.
Managed and Unmanaged are the two types of solutions.
An unmanaged solution is a solution that is still under development and not intended to be distributed.By default, any new solution is an unmanaged solution and until you have completed all customizations, you must not create a managed solution.
A managed solution is a solution that is completed and intended to be distributed and installed. 
Now since there are many developers working on a project, each one might create different solutions for his/ her part of customizations and there might …