I have a large list which contains 30K items. I want to send mail notification to Site Owners. For that I have created site workflow which read the item and send the mail notification to site owners (inside the loop).
While executing the site workflow, it work for some items (Max 140 to 160) and WF is gaining an error. So is there any limitation to send multiple mail form site workflow?
Can you please suggest solutions for this issue.
There is a limitation of number of operations to be executed in one batch..
Assuming you are using ForEach action (not a Loop), you could add addtional logic to pause after executing x times the actions inside it.
But you seriously need to consider to not spam the users :) I wouldn't be happy to receive emails for each item where I'm listed as the Site Owner of... Imagine I own the half... :)