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

How to count List data and send the total to another List?

Hi, I have hopefully an easy question... 

 

I have a very simple Sharepoint list that has a 'Deliverables' column, where the user can select a choice from a dropdown list. I want to count how many of each choices there are and send the total of each Deliverable to another Sharepoint List.

 

Is this possible, and if not is there another way to do this?

Labels: (1)
0 Kudos
Reply
1 Reply
Highlighted
Automation Master
Automation Master

Re: How to count List data and send the total to another List?

@sheather  try below steps:

 

  1. Query your list and store "Deliverables" into a collection e.g. collec_Deliverables
  2. Using Collection Operations:
    1. Target Collection - collec_Deliverables
    2. Remove Duplicates
    3. Store Results in - collec_Unique_Deliverables
    4. Using For Loop, for each collec_Unique_Deliverables
      1. Store values in slt_Unique_Deliverable
      2. Query your list again and do
        1. Apply filter --> "Deliverables" = slt_Unique_Deliverable
        2. Store results in collection --> collec_Count_Unique_Deliverables
      3. Use Collection Operations and get the count of collec_Count_Unique_Deliverables variable

This way your solution will be dynamic and won't have to update the workflow if requirement changes.

0 Kudos
Reply