cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LinkeD365
Advocate V
Advocate V

Override D365 Create Date

I have a scenario where I want to generate data, but include an offset created on date. This will be used for a demo of SLAs within D365.

 

In Postman, I can post something like this to the Incidents entity

 

{
"title": "CC Test",
"overriddencreatedon": "2020-04-29T10:08:15Z",
"customerid_contact@odata.bind": "/contacts(aaae302f-1899-ea11-a812-000d3a7fc8be)"
}

 

And the record is created with the Created on matching the date & time accurately.

 

If I do similar in Flow, using a compose action firstly to get a date

 

formatDateTime(addHours( addDays(utcNow(),rand(-45, 1)),rand(-6,0)),'yyyy-MM-ddThh:mm:ssZ')
 
and use Create New record to pass the generated timestamp to Record Created On (and Last On hold time, to prove it wasn't the formatting), only the date is placed on the record, the time part is blanked
 

What am I doing wrong?

 

Annotation 2020-05-28 111603.png

 

Annotation 2020-05-28 111757.png

 

4 REPLIES 4
abm
Super User
Super User

Hi @LinkeD365 

 

What connector are you using? CDS or D365. 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

I have used both versions of the Common Data Service connector without joy

Hi @LinkeD365 

 

Thanks for your reply. I have tested this with both CDS connectors and D365. Looks like this is a bug. Alternate option is use the REST API.

 

Thanks 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Yeah, that's what I thought. Have got a connector for other things so will have to embellish that.

 

Cheers

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.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (2,898)