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
Community Champion
Community Champion

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
Community Champion
Community Champion

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

View solution in original post

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

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (2,927)