Multiple responses in forms - send as email with bullet points

Like (0) Share

Report

Posted on 31 Mar 2022 00:54:31 by KatLane

Hi all,

I have a MS form that can be submitted by anyone, with two muliple choice answers where they can choose more than one answer.

I've used the following replace expression to remove the characters and separate each choice on to a new line:

replace(replace(replace(replace(outputs('Get_response_details')?['body/r77b2befd75cb4e0fab78b210bfd57145'],'[',''),']',''),'"',''),',','<br>')

before replace expression:

after replace expression:

However, I'd like to bullet each response.

How do I do that?

I have the same question (0)

All responses (6)

Answers (0)

takolota1 4,923 Moderator on 04 May 2022 at 03:57:12

Like (0)

Report
Re: Multiple responses in forms - send as email with bullet points

@KatLane

You can try putting each line in an expression in the action’s code view. Like

If(contains(InsertMultiChoiceResponse, InsertChoice), '<li>InsertChoice</li>', '')

Was this reply helpful? Yes No
KatLane 73 on 04 May 2022 at 03:26:49

Like (0)

Report
Re: Multiple responses in forms - send as email with bullet points

thanks @takolota, I haven't been able to get it to work how I wanted it but it's not the end of the world. I was hoping there was a simple solution that I was missing.

I can't see how to use the html when the responses are based on a multiple choice form.
So I can't set
response 1
response 2
response 3 etc
when I might only get
response 1
response 3
This is the email that I've set up:
The Outputs are the bits that I'm trying to format with the bullets, so it needs to be through the expression in the dynamic content pop out I think.

Was this reply helpful? Yes No
takolota1 4,923 Moderator on 05 Apr 2022 at 17:18:45

Like (0)

Report
Re: Multiple responses in forms - send as email with bullet points

@KatLane

Well dang, even that just returns a weird character. And even if I try using the HTML suggested for an unordered list with bullets, it returns * asterisks instead of bullets in the HTML to text.
But it does seem to work in the HTML of something like an email action if you are using that
Code
<ul> <li>Test</li> <li>Test2</li> </ul>

Example:

Was this reply helpful? Yes No
takolota1 4,923 Moderator on 05 Apr 2022 at 17:03:37

Like (0)

Report

Re: Multiple responses in forms - send as email with bullet points

@KatLane

Sorry, I oversimplified & forgot you might not be able to put a bullet point directly into the formula.
But this should still be possible.

Sometimes I've wanted to use a line-break without using a separate Compose action to create a line break character, so I reference a list like this: https://www.tutorialspoint.com/html/html_url_encoding.htm
Then I use the URL encode value in a decodeUriComponent expression.
So a bullet point is %95 in a url according to this list. So you should be able to insert decodeUriComponent('%95') where you want the bullet point.

Was this reply helpful? Yes No
KatLane 73 on 04 Apr 2022 at 23:23:51

Like (0)

Report

Re: Multiple responses in forms - send as email with bullet points

Thanks @takolota , I've found this previously, but don't know how to translate it into the replace Expression:
Can you please be more specific about the bullet symbol I should include? This isn't my wheelhouse so I'm learning on the fly.

Thank you.

Was this reply helpful? Yes No
takolota1 4,923 Moderator on 31 Mar 2022 at 02:02:23

Like (0)

Report

Re: Multiple responses in forms - send as email with bullet points

On the replace where you input the line-break, you could include a bullet symbol immediately after the line-break characters.

Was this reply helpful? Yes No