I’m running into a problem, I need to loop through all items in a list, and when a certain condition is true (a yes/no column will have the value “yes”), I need toĀ do a calculation.
I have the calculation in place, the conditions are in place, evenĀ a (reusable)Ā workflow on a single item works, but my client would like to have one button in the ribbon which he can click and then the workflow will go trough all items in the list.
Please help! Thanks
PS: working with O365 and SP Designer
Sorry if I’m being unclear. I’ll give it a try to explain it better š
I have a list with Tasks, those are actions from a meeting. Actions are open or closed (ofcourse). The client would like to flagĀ open actions after the due date, even better, he would like to monitor how long the action is open after due date. The “how long” part is not set by time, but set when the next meeting takes places. Therefor, instead of some automatic workflow that runs every now and then, he would like to have a workflow that he can start himself.
So I have an action (task) that is passed due, the next meeting takes place, the workflow should set the KPIĀ to 1. After the next meeting, when the action is still not done, the workflow should set the KPI to 2.
The client doesn’t want to go throughĀ a long list of items and fire workflows one by one (understandable, right?).Ā So he wants a workflow that goes through every item in the list, and when due date is passed, calculate the KPI + 1
I’ve already given him the option that he can set a value to yes which will start a list workflow that will do the calculation, but he knows that his colleagues won’t do that. Therefor he asks for a single button that will do the trick on the complete list.
I hopeĀ this explanation makes it any clearer….
