Solved

O365 Execute SQL - Multiple Columns

  • 7 May 2020
  • 1 reply
  • 8 views

My SQL query returns multiple columns , how do we configure them in Nintex o365 Execute SQl Action ? i am aware this can be done by specifying column names in on premise version. Want to know how to do it on O365.

icon

Best answer by butlerj 8 May 2020, 15:53

View original

1 reply

Userlevel 5
Badge +19

Hi @KalEl, currently the Execute SQL action for O365 does not support retrieving more than one column at a time. The best way to get around this is with a couple different Execute SQL actions, each grabing the different column values. Depending on how you then want to interact with that data, you could then either join collections, or query the XML for the values that you need in the workflow.

Reply