0

I have an Infopath form library where one of the fields is a repeating string bound to a Multiple Selection List Box. The user can select one or more of the items from the list.

That List Box is populated from a separate Sharepoint List. One of the columns associated with that list is the email address of a user who is the 'owner' for that given item.

I would like to use a Workflow to send an email to all of the users who are 'owners' of all of the items that are selected in the List Box. This could be just one user, or it could be 10 users, depending on how many List Box items are selected.

I can't imagine that this is a new question, but I cannot find a solution. I'd be grateful if someone could please point me in the right direction.

Thank you

JR

Improve this question

1 Answer 1

Reset to default
0

SharePoint workflows can only look up one item, so it will return just the first item it finds that matches your specifications. Options for iterating through items are limited. Working with parent/child relationships OOTB is also a struggle. (I believe there's more capability for iterating through list items in 2013, but I haven't seen it myself.)

This tutorial does something similar for tasks created by a workflow. I'm not sure whether or not this could be used with an InfoPath library.

Improve this answer
3
  • Thanks Erin. That's a bummer. I have also tried concatenating the email addresses in a field within the Form Library (from within InfoPath), using the methodology show here: infopathdev.com/forums/p/7306/104796.aspx But when I do, the concatenation only occurs if an item is REMOVED from the List Box. Do you know have any thoughts on what could possibly explain this?
    – Jason
    Dec 10, 2015 at 20:37
  • It's hard for me to know without seeing it. I'm assuming you used a rule? It sounds like the rule is running when the select items are changed or removed. Have you tried running the rule to do the concatenation when the submit button is hit?
    – Erin L
    Dec 11, 2015 at 21:18
  • Yes, thank you. That worked. Incidentally, it seems as though this issue only existed in the InfoPath Preview Mode, but once I uploaded the form to a SharePoint server, it was all good. Thanks for your help! JR
    – Jason
    Dec 14, 2015 at 14:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.