Execute SQL - Multiple columns

  • 12 October 2015
  • 2 replies
  • 5 views

Badge +2

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!


2 replies

Badge +2

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,

Badge +2

Thank you!

Reply