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
I’m having a hard time following what you’re trying to do. To get the count, you can use Call HTTP Web Service action to make a CAML query on the list for all of the items that meet your requirements (passed since an action is due.) This will return a dictionary of said items. There is a workflow action that will count the number of items in the dictionary, so that would be your count.
