Skip to main content

New Site WF (for SP2016 on prem). Multiple Sql query controls configured correctly (without error when testing RUN NOW) resulting in 1 or more email addresses stored in db (per certain criteria). 

When testing in control, replacing 2 criteria variables, we see email addresses (contacts related to criteria) return without error. 

1st we stored the returns in a collection variable, followed by a Collection Operation to JOIN the collection (delimiter of a semicolon) and store in a SLofText variable. 

While query runs fine, nothing is stored in variable. 

2nd replaced SLofText variable with PEOPLE/GROUP variable - nothing stored 

3rd saved data returned in SQL query to the new PEOPLE/GROUP variable - nothing stored. 

4th saved data returned in SQL query to a new MLofText variable - nothing stored. 

While query and WF runs without error - seems likely the variable TYPE is an issue, but if so, I’ve obvi created multiple types so far. 

What am I missing/doing wrong? 

 

screenshot captures 1 of 4 Sql queries, to return email address’ for certain properties specified in query,  followed by collection operation to join with delimiter, and then log the variables to history (so that we know emails are being returned, and we can later in wf, send emails to each group of contacts at certain time/days). 

 

 

 

Issue Resolved. 

What I did.  Tested successfully - this is stage 1 of a much longer site WF

  1. Removed filter on the list query. Output item ID to a collection variable
  2. Collection operation to COUNT items - output to a INTEGER variable
  3. log to wf history so I can verify count once the WF runs
  4. Next, I added a FOREACH - added another Query list - for each item, get field data needed, storing to it’s own variable. 
  5. log to wf history so I can verify output. 

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings