Here's the scenario:
- Column A contains URLS.
- Column B contains Usernames (Owners of the URLs) - multiples, separated by commas
Many of the URLs have the same owners listed. I want to send an email to the owner of each URL but I don't want to send multiple emails to the same owner.
I want to send one email to each owner that contains a list of the URLs that they own.
Here's some sample data:
URL: google.com Owner(s): Bob Johnson, Sue Brown, Mary Jones
URL: bing.com Owner(s): Jason Low, Sue Brown
URL: ask.com Owners(s): Mary Jones
The point of the workflow is to send out notifications. At the end of the workflow the following emails should be sent
1 Email for Bob Johnson - Stating he owns 1 URL
1 Email for Sue Brown - Stating she owns 2 URLs
1 Email for Mary Jones - Stating she owns 2 URLs
1 Email for Jason Low - Stating he owns 1 URL
If I create a site workflow to parse the list, i feel like it will need to create new variables as it reads new names from the Usernames column. The usernames are not set and can be any employee name across the company. So the workflow would need to read the username and url, store both, then evaluate the next username to see if it matches one that already exsists, if so - add the new URL to the multiline text variable that holding all the URLs for that one owner. If not, create a new variable to start holding urls for this new Username.
Clear as mud?!
Anyone have any ideas on the best way to accomplish this?