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:
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.
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.
User | Count |
---|---|
92 | |
45 | |
21 | |
18 | |
16 |
User | Count |
---|---|
136 | |
49 | |
42 | |
36 | |
28 |