cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sperry1625
Solution Supplier
Solution Supplier

SQL Data Transfer from SharePoint

I have a flow that is migrating data from a SharePoint list into an Azure SQL table via a stored procedure. I am transferring the Created and Modified dates as part of the record. The Created and Modified dates are defined in SQL as datetime. I setup the transfer as below:

sperry1625_0-1644872003057.png

I get this error: Conversion failed when converting date and/or time from character string.

I have tried converting the dates to text using formatAsText(), as well as running convertFromUTC() on them, nothing works. How do I get the datetime stored in SQL Server?

 

Thanks.

Regards,

-S

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

0 REPLIES 0

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,063)