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
The looping part I get, still not sure where I can view the output, but that is not so important right now.
Creating a ribbon button, I’ve managed that before, so no prob.
What is puzzling me, is that I have a list on a site (Task List), and I need to update a value. The client counts the number of meetings that have been passed by since an action is due. So first meeting after action is due and action is still open: 1.
When during next meeting action is still open: 2.
The calculation of this part: got it, no prob.
However, how to get this calculation into a site workflow….. And how will the site workflow update the specific column on a specific item (only passed due dates) in that specific list?