Unanswered

Flow error: Cannot convert the literal '2018-01-08T00:00:00' to the expected type 'Edm.DateTimeOffse

(0) Share

Report

Posted on by rodrigoserra1

Since yesterday all the flows that we have extracting data from SQL Server on Prem and sending data to Microsoft Dynamics CRM on the cloud if faling as below.

We checked all the field and data and seems to be correct. The problem somewhere inside Flow or CRM.

  "status": 400,
  "message": "Cannot convert the literal '2018-01-08T00:00:00' to the expected type 'Edm.DateTimeOffset'.",
  "source": "carpetrightuk.crm11.dynamics.com",
  "errors": [],

At the flow notification the error displayed are:

Action 'CheckSalesOrderToCreateOrUpdate' failed
Fix It
If this error was temporary, you can try resubmitting the run and the issue may have been resolved.
Error type
This action failed because of an error in the connector.
Action 'InsertNavSalesOrderInCRM' failed
Fix It
If this error was temporary, you can try resubmitting the run and the issue may have been resolved.
Error type
This action failed because of an error in the connector.

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @rodrigoserra1,

Could you show me a screenshot of your flow configuration?

It seems that the flow worked fine before and it failed all of a sudden.

From the error message, it seems that flow cannot convert the date to expected type. Could you try to use the workflow definition language formatDateTime to convert the date to expected type?

More details about formatDateTime function please check it at here:
https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

Please try it on your side and feel free reply if you need more help.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
rodrigoserra1 7 on at

Like (0)

Report
Copy link

Link copied!

hi @v-yamao-msft

The Flow was working before and there is no data convertion on the configuration (image below), nothing has been changed on the source or in CRM that is the target system.

Was this reply helpful? Yes No
rodrigoserra1 7 on at

Like (0)

Report
Copy link

Link copied!

hi @v-yamao-msft

I've removed the field that was failing and the error moved to the next date field. I've checked the content on the field on the SQL Server and it's correct and i'm doing any convertion or transformation, it's DataTime field from the SQL Server thru Flow Gateway and DateTime field on CRM.

I've checked on the Flow community and i've found that this issue happen before in the pass and was solved.

Regards.

Rodrigo Serra.

Was this reply helpful? Yes No
v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @rodrigoserra1,

Thanks for reporting this.

The issue you posted should be related to date formatting.

Could you please share a screenshot of the Flow configuration?

Meanwhile, please take a try to format the date column from SQL Server, then add it into the corresponding date field in Dynamics 365, with formatDateTime function.

Regards,

Michael

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hello @v-micsh-msft @rodrigoserra1 @v-yamao-msft @ScottShearer

Worked for me used below expression for content types
body('get_file_content').$content
Thanks to flow community
https://powerusers.microsoft.com/t5/Building-Flows/Flow-and-SharePoint-Send-Email-with-Attachment-unreadable/td-p/129955

Thank You all

Was this reply helpful? Yes No