Skip to main content

I have the following scenario:

 

Select EmployeeName, Phone, Email from Emplyees

 

The action places the results in a collection, which appears to be single dimensional. How do I access the other columns?

 

Please let me know if further clarification is needed.

 

Thanks in advance!

Thank you, that was helpful. I was able to put the other columns in separate collection variables. Now, when I run a For Each loop for the first column, how do I access the value from the second column with the same index?

For example, I'd like to read through a SQL table with 3 columns and insert the rows in a SharePoint list.

Thank you,


Thank you!


Reply