Answered

Updating datetime with WebApi offline

(0) Share

Report

Posted on by LostInDynamics

I'm using Xrm.WebApi.offline.updateRecord to update a Dynamics record offline in my PCF component (as documented here: https://docs.microsoft.com/en-us/power-apps/developer/model-driven-apps/clientapi/reference/xrm-webapi/updaterecord).

Other fields update smoothly offline, but if I add a datetime field to the mix & try to save, I get an uninformative error "An error has occurred...". I have tried several formats for the datetime with no success. What kind of date format is expected here?

let data: any = {};

data["myDateField"] = "dd/MM/yyyy hh:mm AM/PM";

Xrm.WebApi.offline.updateRecord("myentity", recordId, data).then(
	function success(result) {
		console.log("Entry updated.");
	},
	function (error) {
		console.log(error.message);
	}
);

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

cchannon 4,702 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
You're trying to insert a string into that col, not a datetime. You have to actually construct the datetime value with new Date():

let myDate = new Date("01/01/2022");

or:

let myDate = new Date(2022,01,01,0,0,0,0);

JavaScript Date Objects (w3schools.com)

Was this reply helpful? Yes No
Diana Birkelbach 3,072 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LostInDynamics ,

If was surely not the cause for your issue, but just wanted to add that using the Xrm.* object inside a PCF is not supported,

The right way would be to use the context.WebAPI, offered by the PCF sdk. That will automatically switch between online and offline if needed: https://docs.microsoft.com/en-us/power-apps/developer/component-framework/reference/webapi?WT.mc_id=BA-MVP-5004107

Was this reply helpful? Yes No