unable to insert date in to sql from cds

[flowadmin3]

I have a flow that triggers off updating an CDS entity and inserts some data into an on-premise SQL server. This works fine in our testing environment but I get an error in our production environment on a date field:

Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'item' validation failed in workflow operation 'TT_project_aanmaken': The parameter with value '"@triggerOutputs()?['body/estimatedclosedate']"' in path 'item/estimatedclosedate' with type/format 'String/date' is not convertible to type/format 'String/date-no-tz'.'.

As far as I know the two environments are identical. The SQL field is of the type datetime and the CDS field is just a date.

[v-alzhan-msft · Accepted solution]

Hi @flowadmin3 ,

Could you please share a screenshot of the configuration of the flow?

You could take a try to format the date time from the sql to date in CDS with workflow definition language.

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#f...

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.