We have a process with items that are pending approval are routed to a user folder for them to review and approve. We want that user to be notified only when there are items in the folder and only once per user no matter how many items they have.
For example if John has 3 items to review on Tuesday the email schedule would run and send him the email that he has 3 items to review, but not send him 3 separate emails. It would also only email him if items are in the folder waiting for him.
My workflow right now is setup to perform the search on the correct folder tree and only retrieve items that are set as "pending". I then setup a "For Each Entry" process to retrieve the field names. This is followed by a "For Each Value" as it retrieves the username and then sends an email. The workflow sends the email however as you can guess it does this "For Each Entry" and so users get multiple emails.
Basically I want to combine this so only ONE email goes out for users with items in the pending state. Thank you!