Send Email Based on Form Checkbox Selection/s

(0) Share

Report

Posted on by dm_elementwa

I've got a really basic Form set out like the below:

Name

Email Address

Which opportunities would you like more information on? (Check all that apply)

[ ] Option 1

[ ] Option 2

[ ] Option 3

I want to then have my flow send an email based on which checkbox/s the user has selected.

Where I'm getting stuck is what expression/formula to use. I've scraped through several threads and articles but can't find one that matches what I'm after.

So if I were to fill out the form and select Option 1 & Option 3, it will send me 2 separate emails that are custom to those options.

Here's a link to a screenshot of what I currently have.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

Re: Send Email Based on Form Checkbox Selection/s

Hi @dm_elementwa

Your screenshot looks good but presumably it doesn't ever send an email for any of the options? I think that you need to single quote your strings in the condition loop. i.e. 'option 1'. Also, can you take a look at the history of your flow and specifically check "get response details" and show raw outputs. This will allow to see exactly what is passed to your flow via the form submission and it maybe that your case switch is not searching for the exact string 'option 1' etc.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

Was this reply helpful? Yes No
dm_elementwa 58 on at

Like (0)

Report

Re: Send Email Based on Form Checkbox Selection/s

Hi @DamoBird365 , thanks for your prompt reply.
OK, so taking one step back - I circled the value boxes because I still need to know what Expression to use.
Going by your response, I changed it to string so it reads: string('Option 1')

My flow is now showing as successful however it didn't detect the checkboxes in their 'true' state (I selected option 1 and option 3, but all are showing as 'false'). It's put all Conditional results as false according to the raw inputs.

The Raw Outputs from Get Response show:
"[\"Option 1\",\"Option 3\"]"

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Re: Send Email Based on Form Checkbox Selection/s

What we need to establish is, what data is being evaluated by your expression in order to get the false outcome. You need to step up one in your flow and specifically check "get response details" and show raw outputs where we can see what is being captured by the form. This will then influence what you evaluate in the next step above.

If you can share with me the get response details history i.e. the raw outputs and look for option 1, 2 3, etc, we can then setup the correct condition.

Was this reply helpful? Yes No
dm_elementwa 58 on at

Like (0)

Report
Re: Send Email Based on Form Checkbox Selection/s

Hi @DamoBird365 ,

Here's what I got for raw outputs from 'get response details' (I've substituted some info for privacy reasons):
{ "statusCode": 200, "headers": { "Pragma": "no-cache", "Transfer-Encoding": "chunked", "Vary": "Accept-Encoding", "X-RoutingOfficeCluster": "sea-003.forms.office.com", "X-RoutingOfficeFE": "FormsSingleBox_IN_9", "X-RoutingOfficeVersion": "16.0.13807.34201", "X-RoutingSessionId": "ebc3b3dd-dfd4-4ace-afd3-938f52ab8eb7", "X-RoutingCorrelationId": "9f854175-d88e-4abc-b107-7d957cbcbd43", "X-CorrelationId": "9f854175-d88e-4abc-b107-7d957cbcbd43", "X-UserSessionId": "ebc3b3dd-dfd4-4ace-afd3-938f52ab8eb7", "X-OfficeFE": "FormsSingleBox_IN_7,FormsSingleBox_IN_19", "X-OfficeVersion": "16.0.13807.34201", "X-OfficeCluster": "sea-003.forms.office.com", "X-Robots-Tag": "noindex,nofollow", "X-Content-Type-Options": "nosniff", "Strict-Transport-Security": "max-age=31536000; includeSubDomains", "X-MSEdge-Ref": "Ref A: 86FA8053F4AF4CEDB42EE9E6915FC8AA Ref B: SYD03EDGE0819 Ref C: 2021-02-17T08:27:24Z", "Timing-Allow-Origin": "*", "x-ms-apihub-cached-response": "false", "Cache-Control": "no-cache", "Date": "Wed, 17 Feb 2021 08:27:23 GMT", "P3P": "CP=\"CAO DSP COR ADMa DEV CONi TELi CUR PSA PSD TAI IVDi OUR SAMi BUS DEM NAV STA UNI COM INT PHY ONL FIN PUR\"", "Content-Type": "application/json", "Expires": "-1", "Content-Length": "298" }, "body": { "responder": "anonymous", "submitDate": "2/17/2021 6:51:33 AM", "r3b8b5cff23db430693ed2a48f2d7f3e2": "Joe Bloggs", "r467e544b0cd640be88e74303020101c4": "joe.bloggs@company.com.au", "rade5f7928a7e40dc8c9bb82940e4a217": "[\"Option 1\",\"Option 3\"]" } }

Was this reply helpful? Yes No
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Re: Send Email Based on Form Checkbox Selection/s

Hi @dm_elementwa,

Thanks for that info. It looks like we have to convert the responses to an array first using the function json(). You can then use an apply to each to traverse through all of the answers in the array using your conditions. No need to include single quotes as I had originally suggested either.

Here is a working flow for you to try (hope it views OK):

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

Was this reply helpful? Yes No
dm_elementwa 58 on at

Like (0)

Report

Re: Send Email Based on Form Checkbox Selection/s

Woo!! That works beautifully! Thank you!! 🙌

Was this reply helpful? Yes No