Skip to main content
Nintex Community Menu Bar

Hello Community, 
I'm struggling with the following issue:

- In List A I have column "colour". This column shows all possible colours (incl. duplicates). 

- Now I want to transfer List A to List B (same structure) without the duplicates.

 e.g. List A: 4x red --> List B: 1x red
        List A: 10x green --> List B: 1x green. 

 

I already tried "collections operations" with count Item but do not come to the prefered result.  

Hi @MatsMul 


 


See attached an example based on your scenario, I am using SP16 for this but if you use another version please let me know, in the example I have used a site workflow but I don't think that matters, it is just easier to test.



 



 


Workflow looks like this:




  1. query to get all items

  2. use collection operation with "Remove Duplicates"

  3. Loop through each result

  4. Create an item


 


 


 


 


 


 


 


 

Thank you very much.
That works for me.

Reply


Sidebar Buttons
Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
Terms & ConditionsCookie Settings