Create a new record in Dynamics 365

[vecerpa]

Hello all,

I'm trying to create new record in Dynamics 365 in Appointments. I have here two date time fields I need to fill. One is start Time and second it End Time.

I'm loading those values from PowerApps form:

But it is throwing error datetime is in format "28.05.2018 8:30":

The error message is:

An error occurred while validating input parameters: Microsoft.OData.ODataException: Cannot convert the literal '28.05.2018 8:30' to the expected type 'Edm.DateTimeOffset'. ---> System.FormatException: The string '28.05.2018 8:30' is not a valid AllXsd value.
 at System.Xml.Schema.XsdDateTime..ctor(String text, XsdDateTimeFlags kinds)
 at System.Xml.XmlConvert.ToDateTimeOffset(String s)
 at Microsoft.OData.PlatformHelper.ConvertStringToDateTimeOffset(String text)
 at Microsoft.OData.ODataPayloadValueConverter.ConvertStringValue(String stringValue, Type targetType)
 at Microsoft.OData.ODataPayloadValueConverter.ConvertFromPayloadValue(Object value, IEdmTypeReference edmTypeReference)
 --- End of inner exception stack trace ---
 at Microsoft.OData.ODataPayloadValueConverter.ConvertFromPayloadValue(Object value, IEdmTypeReference edmTypeReference)
 at Microsoft.OData.JsonLight.ODataJsonLightReaderUtils.ConvertValue(Object value, IEdmPrimitiveTypeReference primitiveTypeReference, ODataMessageReaderSettings messageReaderSettings, Boolean validateNullValue, String propertyName, ODataPayloadValueConverter converter)
 at Microsoft.OData.JsonLight.ODataJsonLightPropertyAndValueDeserializer.ReadPrimitiveValue(Boolean insideJsonObjectValue, IEdmPrimitiveTypeReference expectedValueTypeReference, Boolean validateNullValue, String propertyName)
 at Microsoft.OData.JsonLight.ODataJsonLightPropertyAndValueDeserializer.ReadNonEntityValueImplementation(String payloadTypeName, IEdmTypeReference expectedTypeReference, PropertyAndAnnotationCollector propertyAndAnnotationCollector, CollectionWithoutExpectedTypeValidator collectionValidator, Boolean validateNullValue, Boolean isTopLevelPropertyValue, Boolean insideComplexValue, String propertyName, Nullable`1 isDynamicProperty)
 at Microsoft.OData.JsonLight.ODataJsonLightResourceDeserializer.ReadEntryDataProperty(IODataJsonLightReaderResourceState resourceState, IEdmProperty edmProperty, String propertyTypeName)
 at Microsoft.OData.JsonLight.ODataJsonLightResourceDeserializer.ReadPropertyWithValue(IODataJsonLightReaderResourceState resourceState, String propertyName)
 at Microsoft.OData.JsonLight.ODataJsonLightResourceDeserializer.<>c__DisplayClass4_0.<ReadResourceContent>b__0(PropertyParsingResult propertyParsingResult, String propertyName)
 at Microsoft.OData.JsonLight.ODataJsonLightDeserializer.ProcessProperty(PropertyAndAnnotationCollector propertyAndAnnotationCollector, Func`2 readPropertyAnnotationValue, Action`2 handleProperty)
 at Microsoft.OData.JsonLight.ODataJsonLightResourceDeserializer.ReadResourceContent(IODataJsonLightReaderResourceState resourceState)
 at Microsoft.OData.JsonLight.ODataJsonLightReader.ReadResourceStart(PropertyAndAnnotationCollector propertyAndAnnotationCollector, SelectedPropertiesNode selectedProperties)
 at Microsoft.OData.JsonLight.ODataJsonLightReader.ReadAtStartImplementationSynchronously(PropertyAndAnnotationCollector propertyAndAnnotationCollector)
 at Microsoft.OData.ODataReaderCore.ReadImplementation()
 at Microsoft.OData.ODataReaderCore.InterceptException[T](Func`1 action)
 at System.Web.OData.Formatter.Deserialization.ODataReaderExtensions.ReadResourceOrResourceSet(ODataReader reader)
 at System.Web.OData.Formatter.Deserialization.ODataResourceDeserializer.Read(ODataMessageReader messageReader, Type type, ODataDeserializerContext readContext)
 at System.Web.OData.Formatter.ODataMediaTypeFormatter.ReadFromStream(Type type, Stream readStream, HttpContent content, IFormatterLogger formatterLogger)

Does anybody know what is the correct format to be used to send it do Dynamics? And how to convert it from date and time in string format I'm using?

Type in Dynamics is set to this:

Thank you in advance for any advice.

p.

[v-yuazh-msft]

Hi @ vecerpa,

Could you please share a screenshot of the end time and start time which is inserted in the powerapps.

The correct format to be used in the "End Time" and "Start Time" field is of type 'yyyy-MM-ddTHH:mm:ssZ'.

If you would like to insert the end time and start time from Powerapps to "End Time" and "Start Time" field of "Create a new record" action, please make sure the end time and start time which you insert to the Powerapps is a date time type,and then you could convert the date time type end time and start time to a 'yyyy-MM-ddTHH:mm:ssZ' type date time.

I have made a test on my side to convert a "utc" type date time to a 'yyyy-MM-ddTHH:mm:ssZ' type date time,and then insert

the 'yyyy-MM-ddTHH:mm:ssZ' type date time in the "End Time" and "Start Time" field of "Create a new record" action as below:

The expression in the Compose as below:

formatDateTime(utcNow(),'yyyy-MM-ddTHH:mm:ssZ')

The flow would run successfully as below:

Please let me know if yur problem could be solved.

Regards,
Alice Zhang

[vecerpa]

Hi @v-yuazh-msft,

As I wrote I have date and time from PowerApps form where users fill them. As currently there is not possible in PowerApps to have DateTime field it is collection of DatePicker and two dropdowns which are connected together to provide DateTime.

As outpot of this I have this format as I mentioned - "28.05.2018 8:30". And I am not able to find some expression to transfer it to proper format, so I'm looking for such.

P.

[v-yuazh-msft · Accepted solution]

Hi @ vecerpa,

You could refer to screenshot below to convert the time to a stardard time formate as below:

The expression in the Year as below:

first(skip(split(first(split(outputs('Compose'),' ')),'.'),2))

The expression in the month as below:

first(skip(split(outputs('Compose'),'.'),1))

The expression in the day as below:

first(split(outputs('Compose'),'.'))

The expression in the time as below:

first(skip(split(outputs('Compose'),' '),1))

The expression in the date time as below:

concat(outputs('year'),'.',outputs('month'),'.',outputs('day'),' ',outputs('time'))

The flow would run successfully as below:

Please let me know if your problem could be solved.

Regards,
Alice Zhang

[vecerpa]

Hi @v-yuazh-msft,

Thank you for navigation how to solve this problem.

I made slight change to approach you suggested:

1) I formatted datetime variables for starttime and endtime already in powerapps like this:

Text(dpStartTime.SelectedDate + Time(Value(dpdStartTimeHours.Selected.Value); Value(dpdStartTimeMinutes.Selected.Value); 0);"[$-cs-CZ]yyyy.mm.dd HH:mm")

So this gives me datetime in format 2018.05.30 7:00.

2) I send this to Flow from PowerApps and store it in variable:

3) I'm converting it to proper time zone:

4) Finally I'm able to put it into Dynamics action:

And thats all, I didn't expected that CZ date formatting will not work in Flow 🙂

So thank you again.

P.