cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dm_elementwa
Helper I
Helper I

Send Email Based on Form Checkbox Selection/s

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.

1 ACCEPTED SOLUTION

Accepted Solutions

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):

 

DamoBird365_0-1613637687696.png

 

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

View solution in original post

6 REPLIES 6
DamoBird365
Microsoft
Microsoft

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.

 

DamoBird365_0-1613548852031.png

 

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

 

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. 

Screen Shot 2021-02-17 at 4.28.49 pm.png

 

The Raw Outputs from Get Response show: 

"[\"Option 1\",\"Option 3\"]"
DamoBird365
Microsoft
Microsoft

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.

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\"]"
    }
}

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):

 

DamoBird365_0-1613637687696.png

 

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

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,699)