Answered

Crafting a dynamic email message (body) content.

(0) Share

Report

Posted on by dougowens

I have a large MS form that has multiple Y/N questions (40+) with a comment (long text) response required if "Y" is selected for the preceding Y/N question. I'm using branching on the MS form to require the comments.

My question is how do I craft an email response with the body of the email only displaying the questions/comments where the question boolean is "Y", skipping any questions that are answered

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

365-Assist 2,324 Moderator on at

Like (0)

Report

I suggest using an Array variable to store the comments then add the Array to your email. Something like this:
You may have to format your string to make it look the way in your email.

--------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No
dougowens 8 on at

Like (0)

Report
Ok so I've successfully created my array and am appending three separate sets of answers to it.

The flow looks like...

The hard thing for me to figure out is how to format the output of the variable, whether or not I have one or all three conditions are met.

The output when I have all three conditions met, looks like...

[
"Complaint,07/15/2022,,concerns / issues / observations",
"Complaint,07/12/2022,07/15/2022,concerns / issues / observations",
"Both Annual & Complaint,,,concerns / issues / observations"
]

How do I format to put in an email body to look something like this...

Survey Type: (first field of the first line of my array)
Entry Date: (second field of the first line of my array)
Exit Date: (third field of the first line of my array)
Survey comments: (fourth field of the first line of my array)
Repeat for all lines of the array.

Thanks in advance for any assistance.

Was this reply helpful? Yes No