Query List action returns null if the filter is an empty string

Topic

When using the "Query List" action in Nintex Workflow for Office 365, with a Filter that is equal to a variable that has an empty string. The query will return 0 results even though there are some item(s) with an empty string value on one of the columns.

 

Instructions

Design the workflow as below:
  • Use the "Conditional branch" action to check whether a variable is empty or not.
  • If the variable is empty then use "Query List" with Filter = Is Null.
  • If the variable is not empty then use "Query List"  with Filter = "Variable". 

 

Labels: (1)
Version history
Revision #:
34 of 34
Last update:
‎08-27-2020 03:42 PM
Updated by:
 
Contributors