Share
ReportHi All,
I am having a tough time writing a proper query and was wondering if I can get help here. I have a flow that is running successfully, but when I refresh to see if any rows populated in SQL, it is not happening. My Select and Compose pieces are pulling the data perfectly:
Above query is successful as well but with nothing in the ResultSets or results in general, but the Input of execute query is grabbing the data from compose:
I'm sure it has something to do with how I wrote the query
My only goal here is to take the Compose output from an Excel table, and place into the Query to split each column and insert the data into its respective columns in SQL. Any help would be great as the reference links below were not helpful/successful for me, and surprisingly there's not a whole lot out there on this topic:
https://powerusers.microsoft.com/t5/Building-Flows/Extremely-Slow-SQL-inserts/m-p/527181#M67733 - Shows successful query but not showing code / query is not working on my end.
https://stackoverflow.com/questions/46323946/how-to-insert-json-object-to-sql-server-2016-as-nvarchar - Doesn't work for me unless I'm writing it wrong.
Insert Row is out of the question because of the length of time, I want to be able to insert 3000 rows and read through the first link it did not take them long at all to do it with this method. Thanks for reading!
All responses (
Answers (
4,978
