cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lucian
Advocate III
Advocate III

Why there is a difference between dates format when using the trigger vs. List Rows or Get a Row By ID

Hello,

 

I have some trouble, and lost some time, because of the way the Power Automate returns date values from Dataverse connector.

When using the "List rows" or "Get a row by ID" actions, the date is returned as datetime: "2022-07-19T21:00:00Z"

But when using the "When a row is added, modified or deleted" trigger, the same date is returned as "date only": "2022-07-19"

 

Because of this, I had some problems in the actions inside the flow and I have to put some additional steps that use the other two actions to get the correct date transformed in UTC+2 which would be "2022-07-20".

 

Is this difference intended, and I could not see why would be?

Or is there a way to avoid this "1 day difference"?

 

Kind Regards,

Lucian

0 REPLIES 0

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (6,042)