How to dinamically change text in text tool with analytical app?

Spoiler

Morning all.

I am trying to dinamically change some inputs in a text tool:

The user will input multiple e-mails, and text tool should add thoses e-mails one after one, without destroying the order of rows, only adding lines of emails after X-UNSENT: 1 and "Subject..."

I tried using text interface tool but it only updates one cell. How can I change multiple cells respecting the structure?

Thanks

Sample.yxwz

Apps

Accepted answers

Christine_Assaad

Hi @Joker_Hazard

Sure. See attached

I added a formula tool to prepend "To:" to every single row created after Text to column.

Dynamically change text_App.yxwz

All comments

Christine_Assaad

Hi @Joker_Hazard

Can't you have all emails in one cell, separated by a comma, and just allow the end user - via text interface tool to add as many emails as needed? The email tool should accept this format.

If you need every email to be on its own row, you can use text to column but after the user input emails. Cheers!

Dynamically change text_App.yxwz

Joker_Hazard

@christine_assaad Hey christine!

I wish I could use e-mail tool. Unfortunatelly I had to find a workaround to create a draft e-mail before sending. Its basically a 4 eyes check. Alteryx does not have any feature to help us with that.

So, I'm using this solution here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Creating-an-Outlook-Thunderbird-Draft-Email-including/td-p/602207

About your workflow, very clever idea! I was just wondering, can you show me how to add a To: before each email in your workflow? I really need that to feed the html in .eml.

Thanks in advance!!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703