cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

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
Highlighted
Super User III
Super User III

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
Highlighted

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

Highlighted

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
Highlighted

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

 

Cheers

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (6,631)