Skip to main content
Nintex Community Menu Bar

Display SQL query output in Sharepoint

  • August 14, 2019
  • 3 replies
  • 19 views

Forum|alt.badge.img+2

Hello,  My goal is to capture the data from sql query out put (couple of columns) and display the out put in Sharepoint

I am using the link below to capture the sql query out put to a collection variable using  a worflow

https://community.nintex.com/t5/Nintex-for-SharePoint/Nintex-SQL-query-workflow-action/m-p/9552#M8040

 

How do I display the captured data in Sharepoint list ?

 

Thank you

@R

3 replies

Forum|alt.badge.img+9
  • Scholar
  • August 14, 2019

If it is a site workflow, use Update Item.  If it is a item workflow, use the Set Field Value action.  If you query is pulling multiple columns, you may need to do a build string to pull all your variable items together.  


Forum|alt.badge.img+2
  • Author
  • August 14, 2019

This workflow is on a list with a basic form. When user selects a check box1, saves the form then workflow is triggered. 

Can you please give me an example as how I can pull all the output (multiple columns)together. 


Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • August 15, 2019
Hi,
At the end of solution on the post you linked you are left with collection variables for each column.
If you check out the workflow on the linked post below you will see how to work with two collection variables and pull out what you need and combine it.
https://community.nintex.com/t5/Nintex-for-SharePoint/Split-string-help/m-p/99534/highlight/true#M69431