milkdud1
Scholar

Site workflow to check each item in a list and count how many have a value of "no"

Jump to solution

I have a sharepoint list that tracks tasks that people need to do. Each person has their own item with their name (people picker) then  column is a question "did you submit the expense for this month" with radio button 3 choices yes, no, not yet. I want build a site workflow that counts how many items record and counts how many items have a reply of no or not yet then sends an email showing how many no's and how many not yet's.

 

I have never built a site workflow before (only did basic list workflows to update an item). Can any one guide me on how to build this 

Labels: (1)
0 Kudos
Reply
3 Replies
kchaluvadi
Contributor

Re: Site workflow to check each item in a list and count how many have a value of "no"

Jump to solution

If you are using Nintex for SharePoint 2013, follow the below steps (should be similar to later versions):

  • click on gear icon, locate "Nintex Workflow 2013" --> "Create Site Workflow"
  • This open Nintex workflow designer that looks similar when you create a list workflow
  • Use "Query List" action and select the list that you want to query. 
  • Apply filter for "No" and store the result in a collection variable and process the collection variable as required.
  • Repeat the same steps for "Not Yet" and store the result in another collection variable and process the collection variable as required.

Hope this helps.

0 Kudos
Reply
milkdud1
Scholar

Re: Site workflow to check each item in a list and count how many have a value of "no"

Jump to solution

Thank you. After the query list do I need to do 2 different  collection operations to  count (do i do count or add) all the no and not yet and store the results  of the count into 2 different variables (e.g. Bariable: Total no Variable total yes?

 

For the email sending me the count of each do I just write the email and put the 2 variables in there?

 

Thank you for all your help

0 Kudos
Reply
kchaluvadi
Contributor

Re: Site workflow to check each item in a list and count how many have a value of "no"

Jump to solution

If you want to take the same action for "No", "Not Yet" response, you can use only one collection variable by modifiying the query with "OR" condition.

Then process the collection variable for counting the "No"s, and "Not Yet"s.

 

If you are using 2 different collections for each "No", "Not Yet", simply get the count of each collection variable.

 

Either way it works. 

 

View solution in original post

Reply