cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

Site workflow to loop into all listItems where column x is empty?

Jump to solution

We are using SharePoint 2013 and Nintex forms/workflow 2013. I created a Nintex site workflow and would like to loop into some specific listitems in ListA. The filter is that I only want to loop into the listitems where column x is empty. Which actions do I need to use?

Labels: (1)
0 Kudos
Reply
4 Replies
Highlighted
Nintex Newbie

Re: Site workflow to loop into all listItems where column x is empty?

Jump to solution

If the filter  "Column X is null" does not result the expected items, maybe you could try to add a calculated column which sets the value to whatever you like if Column X is empty and to "" if it contains a value; eg. IF(ISBLANK(Column X),"Include",""). Filter the Query List on the calculated column if it equals "Include".

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Site workflow to loop into all listItems where column x is empty?

Jump to solution

Hi, my question was more about how to loop into all list items by a filter? I dont have a problem with the filter or something.

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Site workflow to loop into all listItems where column x is empty?

Jump to solution

Your Query List for the ID of the found items which are to be stored in a Collection wf variable, eg. colFoundItems. You also need a List Item ID wf variable, eg idCurrentItem. The For-each is then setup using colFoundItems as its source input, and storing the current collection item into idCurrentItem.

 

Within the For-each you can now lookup details of the item with ID=idCurrentItem.

Alternatively you could create collection wf variables for the item details you need inside the foreach, and also have number wf variable numCollectionIndex that you use inside the For-each config to store the Index value. Inside the foreach you can use numCollectionIndex to get an item from the other collections for the current item.

 

Hopefully this is what you're after.

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Site workflow to loop into all listItems where column x is empty?

Jump to solution

Start by making:

a collection variable named collIDs

A single line variable named targetID

2019-05-17 14_31_50-Workflow Designer - Internet Explorer.png

 

You would change the "title" to be whatever your Column X is. Then save the ID field to collIDs. Then you can do operations against the collection using For Each actions.

 

2019-05-17 14_37_23-Workflow Designer - Internet Explorer.png

 

Then do an Update Item action INSIDE the For Each like so: 

 

2019-05-17 14_36_30-Workflow Designer - Internet Explorer.png

 

It will now loop through every ID on the targeted list, collect only those with empty Title fields, and update the column Title with the text "THIS IS NOT EMPTY ANYMORE".

 

View solution in original post

0 Kudos
Reply