Improve company productivity with a Business Account.Sign Up

x
?
Solved

Email multiple people in Workflow

Posted on 2014-01-24
6
Medium Priority
?
377 Views
Last Modified: 2014-02-04
I made a security request form in InfoPath 2010.  It has a Multipl-Selection List Box that has the systems, that it gets from a list.  Something like; SAP, AR, AP, ORACLE BI.  In the list, each entry has an Approver, guy who is in charge of that area like Bob,Jim,Dan, Mike.  What I want my workflow to do, is start an approval process for each person in charge of each person that is picked.  So if the user checks off SAP and AR, Bob and Jim get a simple approval task.  My workflow seems to only work if one checkbox is checked, not more than one.  In my workflow I have very simple action like

Start <u>Approval<\u> process on <u>Current Item<\u> with <u>Systems:Approver<\u>.

If I choose one checkbox, the email is sent and approval process is started.  If I choose 2 checkboxes, nothing happens. Did I go completely down the wrong path is this not a good idea can a workflow even do what I am trying to do ?
0
Comment
Question by:Demosthenes
  • 3
  • 3
6 Comments
 
LVL 28

Assisted Solution

by:Clay Fox
Clay Fox earned 2000 total points
ID: 39806933
Are you using email submit data connections for the workflow or SharePoint?

for email with IP directly you would need to create a concatenated list of the email addresses.

you may also be trying to use a multiselection list control, which never works well. Better to have a list of check boxes or drop downs.
0
 

Author Comment

by:Demosthenes
ID: 39818879
I am using an infopath form to submit.  It has a multiple selection list box.
0
 
LVL 28

Assisted Solution

by:Clay Fox
Clay Fox earned 2000 total points
ID: 39818907
Yah, that is what I thought, it is the multiple selection list box, have yet to see one of those work in a production form.

Either way you would need a field for the to in the email.  It would need to be formatted as a concatenated list, email@email.com; email2@email.com and so for.  Just like they would look in an Outlook email.
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 

Author Comment

by:Demosthenes
ID: 39820789
How about, multi list checkbox has a action that pupulates a hidden field with concatenated choices.  Is that possible ?  I can get it to put the values into a field this way like:  Choice1Choice2Choice3.  If I could somehow get the values, email1email2email3.  Then somehow get commas in there, that would do my email field that I could use in my workflow.  I am thinking it probably cant be done but I wanted to run it by you.
0
 
LVL 28

Accepted Solution

by:
Clay Fox earned 2000 total points
ID: 39820827
That can certainly be done, just not certain if you can get it to work with the multilist, you will have to test, but just putting a repeating table or section will work for sure.

set field emailTo

concat(emailTo, field1, ";")

that will append an email and semicolon to the existing list. It gets a bit cumbersome when they make a mistake and want to remove one or start over.
0
 

Author Comment

by:Demosthenes
ID: 39832426
Nothing I have tried has worked I don't think InfoPath by itself can do this.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question