• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 371
  • Last Modified:

Email multiple people in Workflow

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
Demosthenes
Asked:
Demosthenes
  • 3
  • 3
3 Solutions
 
Clay FoxDirector of Business IntegrationCommented:
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
 
DemosthenesAuthor Commented:
I am using an infopath form to submit.  It has a multiple selection list box.
0
 
Clay FoxDirector of Business IntegrationCommented:
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
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 
DemosthenesAuthor Commented:
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
 
Clay FoxDirector of Business IntegrationCommented:
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
 
DemosthenesAuthor Commented:
Nothing I have tried has worked I don't think InfoPath by itself can do this.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now