SharePoint Workflow

I need to create a workflow to send an email containing the count of new items added weekly. We are adding items weekly so basically a count of items added such as : "You have 100 new items added".

This workflow needs to go to the specific user associated with the category. Such as the below:
If the category is West, and email goes to
If the category is East, and email goes to

How do I set this up?

PS I have SharePoint Designer
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jamie McAllister MVPSharePoint ConsultantCommented:
Wouldn't it be far easier to create an alert summarizing new items?

A little compromise but nothing to develop or maintain.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
kwarden13Author Commented:
It would be, however, how would I just send a count in the alert. I tested the alert and I get a really long email w/ form after form (looks like the display form). I have about 250 new items a week.

Thank you-
Jamie McAllister MVPSharePoint ConsultantCommented:
I hear you, Alerts are unwieldy for the volumes you're working with.

Alas without answering your question directly again, one approach I've taken is to create a mini-dashboard using JSOM showing the item count in given libraries. If dashboard rather than email were acceptable, you could create a view per category then query each view and display the count.

I have some sample code for this, though you'd have to work in the specific view querying.

The code can be embedded on a given page simply using a Content Editor Webpart.

However, if it has to be workflow, I'm probably confusing this thread and apologize if so.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

kwarden13Author Commented:
We don't even know if the users would be able to navigate the site. So we are only providing them a link to the form so we do not confuse them.

I agree a dashboard would be easier however they want an email.
Jamie McAllister MVPSharePoint ConsultantCommented:
Understood. Apologies for my tangents! :)
kwarden13Author Commented:
No worries. I appreciate your input!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.