Solved

Transfer Data without duplicates from List A to List B

  • 23 September 2022
  • 2 replies
  • 12 views

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.  

icon

Best answer by Jake 26 September 2022, 12:44

View original

2 replies

Userlevel 5
Badge +13

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