I'm attempting to build functionality into an existing workflow. My workflow runs on a server and is scheduled. It is creating a report and sending it out to a list of email recipients. That piece is working just fine. I would like to add functionality for when the app is run manually to allow a user to select the email recipients from a list (text input, already in the workflow) My text input looks like this: Recipient1Email012 Email02 3Email034Email04 I Summarize/Concatenate those into a single field comma separated value that goes into the recipient field of the email tool. I've attempted multiple options to limit the list that gets concatenated, but none of them have worked. The "must have" is that the full list of recipients must be passed to get concatenated when the flow is run without external input. Does anyone have any thoughts?

List Box to choose email recipients

I'm attempting to build functionality into an existing workflow. My workflow runs on a server and is scheduled. It is creating a report and sending it out to a list of email recipients. That piece is working just fine.

I would like to add functionality for when the app is run manually to allow a user to select the email recipients from a list (text input, already in the workflow)

My text input looks like this:

	Recipient
1	Email01
2	Email02
3	Email03
4	Email04

I Summarize/Concatenate those into a single field comma separated value that goes into the recipient field of the email tool.

I've attempted multiple options to limit the list that gets concatenated, but none of them have worked. The "must have" is that the full list of recipients must be passed to get concatenated when the flow is run without external input. Does anyone have any thoughts?

Workflow

Accepted answers

JFurda

JosephSerpis, With your foundation, I got it to work! I had to modify it slightly, but it certainly does what I need it to do now. Thank you.

Selecting email recipients.yxzp

All comments

JosephSerpis

Hi @JFurda I mocked up a workflow that should produce the output you described. Let me know what you think?

Listbox_011119.yxzp

jrgo

Hi @JFurda

Here's an option you can explore. The List box will generate a custom list that can be used in an IN operator which then updates a Filter tool that's staged with a placeholder value that the action tool replaces.

JFurda.yxzp

JFurda

JosephSerpis, With your foundation, I got it to work! I had to modify it slightly, but it certainly does what I need it to do now. Thank you.

Selecting email recipients.yxzp

JFurda

@jrgo, this wouldn't pass the entire list through the filter if it was run without user selection. I managed to get a slightly different flow to work. I appreciate the help in getting me on the right track!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703