Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Date and time fields now emit conversion errors

Has the method of registering data in Powers Date and Time fields changed from Power Automate?

Until 2 days before
addHours (utcNow (), 9, 'yyyy / MM / dd')
I was able to register with
I started to vomit a conversion error now

Community Support
Community Support

Hi @mukie ,


I have made a test on my side and don't have the issue that you mentioned.

My flow with expression that you provided works well on my side.

Please take a try with your flow again and let me know if your issue still exists.


Best regards,



Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-alzhan-msft


New_date field that is created when a custom entity is created automatically in Dynamics365

There was a difference in the setting of this field in my development environment and production environment.

The difference was in “action”.

In a production environment, the new_date field only works with dates,
If you add addHours (utcNow (), 9, 'yyyy / MM / dd') to this field in Flow, a conversion error will occur.

In the development environment, the operation of the new_date field is user-local, and if you add addHours (utcNow (), 9, 'yyyy / MM / dd') to this field in Flow, registration was successful.

Previously, registration and updating were possible even in a production environment.

Frequent Visitor

An answer was returned from MS.
In the above case, addHours (utcNow (), 9, 'yyyy / MM / dd')
I was told that by setting addHours (utcNow (), 9, 'yyyy-MM-dd') instead, no error occurred.

I asked why it happened.
To be honest, I felt uneasy about the MS system.
There are too many bugs and we don't accept them.

Helpful resources

MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (2,088)