Solved

Email multiple people in Workflow

Posted on 2014-01-24
6
311 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: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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

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…
The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
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…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

747 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now