How to sync SQL Date Field with CRM Date field using Microsoft Flow(Power Automate)

(0) Share

Report

Posted on by NILANKA SEKHAR PAUL

340

Hi Team,

I am facing an issue while going to sync SQL Date Column with CRM dateTime Field using Microsoft Flow. While Syncing it is throwing error.

Unable to process template language expressions in action 'Compose' inputs at line '1' and column '2673': 'In function 'formatDateTime', the value provided for date time string '20190812' was not valid. The datetime string must match ISO 8601 format.'.

How to solve this issue in MS Flow. Please help me .

Thanks in advanced.

I have the same question (0)

All responses (1)

Answers (0)

David Jennaway 14,065 on at

Like (0)

Report

I think you the problem is that you're using a SQL Date data-type, rather than a DateTime (or smalldatetime) data type. As far as I know, you'll need to convert the data-type to a datetime. You should be able to create a SQL view that includes a column with the converted value, if it is not possible (or desirable) to change the underlying column

Was this reply helpful? Yes No