AnsweredAssumed Answered

Automatically Generate Variables in Workflow

Question asked by koolgeex on Dec 12, 2017
Latest reply on Dec 12, 2017 by krishnachaluvadi

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?

Outcomes