cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mukie
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

3 REPLIES 3
Community Support
Community Support

Re: Date and time fields now emit conversion errors

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,

Alice       

 

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.

mukie
Frequent Visitor

Re: Date and time fields now emit conversion errors

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.

mukie
Frequent Visitor

Re: Date and time fields now emit conversion errors

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

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Users online (6,954)