Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Email multiple people in Workflow

Posted on 2014-01-24
6
Medium Priority
?
357 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 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:clayfox
clayfox 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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 

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 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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
These days socially coordinated efforts have turned into a critical requirement for enterprises.
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…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

722 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