Skip to main content

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


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings