4

I am trying to set up using a SharePoint 2010 workflow that will count the number of non priority 1 tickets in a custom SharePoint online list. What I would like to have it do is go through the list, if the ticket is priority 1 then it will print the current total into the column. Then, if it is priority 2-5 it will add one to the total and update the total column. It would look something like this

Title     Priority     Total 
Ticket 1     1          0 
Ticket 2     3          1 
Ticket 3     3          2 
Ticket 4     1          2

I can't seem to get the workflow to work quiet like that and I was wondering if someone could help. Here is how my current workflow is set up enter image description here

enter image description here

1 Answer 1

0

You can do this using following logic.

  1. If current item priority = 1. Then get recently modified list item where priority equals one. From that item take the total value and assign it to a variable.

    • Increment value in variable and update current item Total field
  2. Else. Get recently modified list item where priority is not equal to one. From that item take the total value and assign it to a variable.

    • Increment value in variable and update current item Total field
2
  • 1
    Thank you for the answer it has been helpful, but I don't have any option in SharePoint Designer to get recently modified list items. Do you know if the is a specific action I can use to do that?
    – tmarsh
    Commented Apr 18, 2015 at 1:26
  • I was just throwing an idea. Next option is to add a hidden field of type Yes/No. And use that field to track the last updated total list item. You can use that in the lookup for getting item. Then set that row to No. And set current item to Yes. Hope you got the idea. Commented Apr 18, 2015 at 1:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.