Creating a Coffee Roulette Automatically

Question

Hi all,

I've been trying to create a coffee roulette. Which is basically a way to match two people from a list of emails randomly and then automatically send them an email/google invite so that they can meet each other.

I created what is attached, which randomly selects 2 people. But I am struggling to find a way to send one email to the two people in the row, and how do I add their names in the email body?

ADVANCED:

Ideally, I would like to create a way that IF two people matched then redo the random selection. I created a list that writes down every single match, but not sure how to create a way to check that it match with current random selection or not.

Your help is much appreciated!

coffee_table.yxzp

FinnCharlton · Answer

Hi @MuhabHasan ,

I've made you something that should satisfy the "Advanced" part of your original post. It takes into account the "already paired" data, calculates random pairings that have never happened before, then emails both participants:

coffee meet no repeats.yxzp

FinnCharlton · Answer

Hi @MuhabHasan, this workflow will email both of them. As you can see there are 4 rows, so therefore 4 emails sent, one to each participant.

The email tool configuration can differ based on your provider, you can learn about it online, this is a good starting point:

Email Tool | Alteryx Help.

To create the email message I would use a formula tool to create it in a string field, then use the "Use Field" option to add it to the email. This will let you add newlines and to dynamically add the participants names:

MuhabHasan · Answer

This only sends email to one of the pairs instead of both. Also, how do I use the email tool to actually send the email? Furthermore, is there a way to add sections in the message? 
 doesn't seem to work.