I am trying to query a list called "RequestTypeSteps" and load it into a task list called "RequestTasks".
I used "Query List" to get a collection (see screen shot below). I have 6 collection variables in my Query List to capture 6 of the fields from the RequestTypeSteps. I also want to associate it with a RequestID which I previously saved. How do I copy this collection into RequestTasks which has the same data structure with an additional RequestID field.
I figured out a way to get this done, but I assume there is a much more efficient way. For each item in my collection, I assign the collection variable to an item variable and then use Create Item to update the row in my RequestTasks table.
The create item configure screen is blow.
I would do this slightly differently in that in my first query list I would pull back only the IDs so that I have a collection of IDs. then inside my for each I would query the list again using the current ID in the collection as a filter and pull back all the other fields into separate variables, and then use a create item with all of those.
see an example here: