Skip to main content
Nintex Community Menu Bar

Get the Items NOT selected from Collection

  • October 12, 2017
  • 2 replies
  • 9 views

Forum|alt.badge.img+1

Hello, Im trying to REMOVE items from a collection.

 

1. Populate a collection of ALL IDs possible (example: 1,2,3,4,5,6,7,8,9,10,11,12)

2. Loop through the IDs that have been selected (example: 1,4,5,11)

3. Want to REMOVE IDs that appear in my selection from the full list

4. Result in a collection of IDs I didnt select (example: 2,3,6,7,8,9,10,12)

 

Havent been able to get this done since, would appreciate a fresh set of eyes.

 

2 replies

Forum|alt.badge.img+9

Can you try this way and check it.

1. Get the item Ids into 'Col1'.

2. Get the item Ids into 'Col2' based on some selection.

3. Use 'For each' action to iterate through each item in 'Col2'.

4. Use 'For each' action to iterate through each item in 'Col1'.

5. Use 'Set a Condition' or 'Run If' action to compare, if item in 'Col1' is equal to item in 'Col2'.

6. If equal then Remove that item from 'Col1' using 'Collection' operation (remove).

7. Store Result in 'Col1'.


Forum|alt.badge.img+14
  • Scholar
  • October 16, 2017

you can achieve it eg. following way.

 

- create for each loop over select IDs collection. save current element into a variable

- within the loop, use collection operation on all IDs collection and its operation 'Remove by value'. use variable from above step to identify which element to delete from the collection.