Solved

Email multiple people in Workflow

Posted on 2014-01-24
6
340 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 28

Assisted Solution

by:clayfox
clayfox earned 500 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:clayfox
clayfox earned 500 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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:
clayfox earned 500 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
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…
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…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

735 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