Flow - email when form is completed

(0) Share

Report

Posted on by bguthrie

Hello,

I've created a form and a flow to email contents from the form.

There are multiple questions on the form. I want the email to include information from each response as long as it's not blank. I want to add the dynamic content for each response that contains data and ignore it if it doesn't.

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Rhiassuring 8,692 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi there,

Sure, you'll use an expression for that.

For example:

if(equals(outputs('Get_response_details')?['body/rff0b6cb059274e269bda63cde0759d2d'],null),'',outputs('Get_response_details')?['body/rff0b6cb059274e269bda63cde0759d2d'])

The orange bit is an an expression of null, not just typed in. The overall if statement is an expression.

So basically it's if(equals(FORMFIELD,null),'',FORMFIELD))

If form field is empty, then nothing, otherwise, put the form field.

Was this reply helpful? Yes No
bguthrie 26 on at

Like (0)

Report
Copy link

Link copied!

Wow. Thank you for the quick response. I think I'm still not sure how to add it. I've attached a screenshot. For "Contacts Per Hour" sometimes it will have data and sometimes it won't. In the email, if it has data, I want the email to display "Contacts Per Hour: 6.5", and if the field is left blank, I don't want the email to have anything in that spot, including the "Contacts Per Hour:" header. Does that make sense?

Was this reply helpful? Yes No
Rhiassuring 8,692 Moderator on at

Like (0)

Report
Copy link

Link copied!

Ohh you don't want the header, either. Okay!

It will look like this:

if(equals(outputs('Get_response_details')?['body/rff0b6cb059274e269bda63cde0759d2d'],null),'',concat('Contacts Per Hour:',outputs('Get_response_details')?['body/rff0b6cb059274e269bda63cde0759d2d']))

In the email, it will end up looking like this (one of these for each field):

Also I just copied in the 'null' without doing the expression so I guess in this instance it can just be typed. News to me!

Anyway, to enter those in, click in the body of the email, click on the Expression tab to the right of the Dynamic Content tab.

You can copy paste this in:

if(equals(FORMFIELD1,null),'',concat('FIELDTITLE:',FORMFIELD1))

For the orange bit, you'll type it right on in there. For the FORMFIELD1 (on both sides), use dynamic content and point it at the relevant form field.

Was this reply helpful? Yes No
bguthrie 26 on at

Like (1)

Report
Copy link

Link copied!

Got it! Thank you so much!!! That worked!

Was this reply helpful? Yes No
bguthrie 26 on at

Like (0)

Report
Copy link

Link copied!

wait, I'm sorry. It looks like when it's blank, it's still showing the header. This is what I'm using:

if(equals(outputs('Get_response_details')?['body/r8d9398739dfa4414a2e2558bd007e59b'],null),'',concat('Contacts Per Hour: ',outputs('Get_response_details')?['body/r8d9398739dfa4414a2e2558bd007e59b']))

It's still showing "Contacts Per Hour: " in the email

Was this reply helpful? Yes No