cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HannahSelbie
Frequent Visitor

Form Submissions with Multiple Conditions - To send an email to a certain person

Hello, 

 

I need help building a flow - I have created a form, with 2 multiple choice drop down menu's. 

 

Q4: CLUB LOCATION: 5 DIFFERENT OPTION 

Q5: WHAT DO YOU NEED ASSISTANCE WITH? 8 DIFFERENT OPTIONS 

 

Screen Shot 2022-08-16 at 7.42.57 am.png

 

I have created a condition that allows my automation to send an email to my Bibra Lake Location and works. 

But now I want to be able to condition the location and assistance question. 

 

Screen Shot 2022-08-16 at 7.45.38 am.png

 

 

EXAMPLE: 

If someone selects Bibra Lake and Customer Support - I want that to go to my customer support department. 

When I have formatted the condition, it sends an email to everyone not just that department. 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
MarconettiMarco
Super User
Super User

Hello @HannahSelbie ,

please follow these steps:

1. After the "Get response details" action, please add a "Compose" action where putting the following expression, in order to remove unwanted characters:

replace(replace(replace(replace(outputs('Get_response_details')?['body/r2ef9e7cf3b34464eb17dd32a2493ba61'], '"',''),'[',''),'\',''),']','')

Instead of "r2ef9e7cf3b34464eb17dd32a2493ba61", please put your Forms question code.

MarconettiMarco_0-1660631314236.png

2. Add another "Compose" action where putting the following expression, in order to remove unwanted characters:

replace(replace(replace(replace(outputs('Get_response_details')?['body/r0394fa09e0b54bcbba759eb13490c3ad'], '"',''),'[',''),'\',''),']','')

Instead of "r0394fa09e0b54bcbba759eb13490c3ad", please put your Forms question code.

MarconettiMarco_1-1660631480236.png

3. Then, add the "Condition" control, in which you should add the Compose outputs as first parameters, and the choice values as second ones:

MarconettiMarco_2-1660631506888.png

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

 

View solution in original post

HannahSelbie
Frequent Visitor

Thank you, but I have multiple conditions for the same email. Or do I need to configure a new condition for each? 

It doesn't send to any email if I configure 'BIBRA LAKE' & 'CLASS BOOKINGS; as an example. 

 

Screen Shot 2022-08-16 at 3.22.09 pm.png

 

 

View solution in original post

6 REPLIES 6
MarconettiMarco
Super User
Super User

Hello @HannahSelbie ,

please follow these steps:

1. After the "Get response details" action, please add a "Compose" action where putting the following expression, in order to remove unwanted characters:

replace(replace(replace(replace(outputs('Get_response_details')?['body/r2ef9e7cf3b34464eb17dd32a2493ba61'], '"',''),'[',''),'\',''),']','')

Instead of "r2ef9e7cf3b34464eb17dd32a2493ba61", please put your Forms question code.

MarconettiMarco_0-1660631314236.png

2. Add another "Compose" action where putting the following expression, in order to remove unwanted characters:

replace(replace(replace(replace(outputs('Get_response_details')?['body/r0394fa09e0b54bcbba759eb13490c3ad'], '"',''),'[',''),'\',''),']','')

Instead of "r0394fa09e0b54bcbba759eb13490c3ad", please put your Forms question code.

MarconettiMarco_1-1660631480236.png

3. Then, add the "Condition" control, in which you should add the Compose outputs as first parameters, and the choice values as second ones:

MarconettiMarco_2-1660631506888.png

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

 

HannahSelbie
Frequent Visitor

Thank you, but I have multiple conditions for the same email. Or do I need to configure a new condition for each? 

It doesn't send to any email if I configure 'BIBRA LAKE' & 'CLASS BOOKINGS; as an example. 

 

Screen Shot 2022-08-16 at 3.22.09 pm.png

 

 

@HannahSelbie ,

please set the first operator to OR:

MarconettiMarco_0-1660634827467.png

 

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

 

HannahSelbie
Frequent Visitor

Thank you - However it just returned this.  

 

Screen Shot 2022-08-16 at 3.28.54 pm.png

@HannahSelbie ,

please share the Send an email action in Edit Mode.

 

BR,

Marco

HannahSelbie
Frequent Visitor

Thank you Marco - I managed to get it working 🙂 

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,093)