How can I use execute SQL to insert records to a Oracle table and looping through a list . I have tried calling the Startworkflow on list item, but it seems to insert the
same row over and over
Inside your workflow you will first do a Query List action to capture all the list items into a Collection variable. You will then use a For Each action to loop through the collection and inside of this loop using the Execute SQL statement to insert your records row by row.
I agree with Mike.
It worked! Thanks
Hi, "Femi Oyesanya! Glad you got a solution.. Mind clicking the "correct answer" button beneath the right response? It's helpful for others in the community who search for answers to questions like yours. Thank you!
Your community manager
Great to hear please mark my answer as correct to close this one out.
Retrieving data ...