cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JDaws87
Frequent Visitor

Executing a SQL Query (V2) to 'Split' a compose and Insert data into its columns

Hi 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:

JDaws87_0-1632323219100.png

JDaws87_2-1632323340290.png

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:

JDaws87_3-1632323427837.png

 

I'm sure it has something to do with how I wrote the query

JDaws87_4-1632323625213.png

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-nvarcha...   - 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!

 

 

0 REPLIES 0

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,363)