Answered

SharePoint created date not available in dynamic content to map to date field in sql server

(0) Share

Report

Posted on by rpiazza

Thanks in advance,

I noticed in my flow when I map the created date from my SharePoint lib to a date field in SQL server, the created date is not available in the dynamic content to select from however it is available if I map to a non date field from sql server. Any reason why?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report
Dynamic Content values are filtered based on the data type of the destination. Since SQL only accepts certain kinds of Data Time values it filters the SharePoint date values out of dynamic content. The easiest workaround is to use a compose action to pre-format the SharePoint date into a form that is acceptable to SQL. Then use the compose from the dynamic content dialog. SQL will normally want the date time in ISO 8601 format. So you can use the following

formatDateTime('SharePoint DateTime Value','o')

Was this reply helpful? Yes No
rpiazza 23 on at

Like (0)

Report

Thanks for the quick reply; I am confused. I tried doing the following. First I compose the date time of the Created date in SP with formatDateTime('Created','o')

then use the output from that function to map to my datetime field in sql
But it didnt work for me.... are my steps correct? thanks

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

What is the specific field type for the SQL field you are trying to update? SQL has a variety of field types for Dates and Times, but the steps should work for a field of type DateTime in SQL.

Was this reply helpful? Yes No
rpiazza 23 on at

Like (0)

Report

SQL Col is def as a datetime2(7), null)

Was this reply helpful? Yes No
Verified answer

Pstork1 68,717 Most Valuable Professional on at

Like (1)

Report
Since its a Datetime2(7) I think you'll have to use a different format without the UTC code. Try this one.

formatDateTime('SharePoint DateTime Value', 'yyyy-MM-ddTHH:mm:ss.nnnnnnn')

Was this reply helpful? Yes No
rpiazza 23 on at

Like (0)

Report

In my first compose I needed to remove the '' around Created, in the second compose I formatted datetime from the output of the first compose with 'yyyy-MM-dd hh:mm'...seemed to work.

Thanks for your help

Was this reply helpful? Yes No