I have a multi-select box with a dozen locations--the options come from a smart object/SharePoint list which has additional info on each item, including an email address for a POC--these are stored in a single line text field--not as a "person/group."
When a person submits the form, the values selected are saved as they should be with semicolons between them in a single field.. What I need to do next is use that field in a workflow to build a Send Email's CC field.
So here's what I mean:
List:
Location: Anchorage | POC: Bob@anchorage.net
Location: Kodiak | POC: Bob @outlook.com
etc.
In the workflow, I have a field containing "Anchorage;Kodiak" I need to iterate through it and add the email addresses to the CC line. I cannot make the email addresses the "value" that gets saved on the form b/c there is actually another item I push there, which must be captured.
Is the "For each" option right for items collected within a field? Any guidance would be appreciated!
-Jeff