How to convert multiple choice answers from Form into bullets in Email via Flow

(0) Share

Report

Posted on by Suuz

Hi there,

I am trying to create a flow that sends an automatic confirmation email to the e-mail address given on a Form.

And in this email I want to confirm the options they have selected answering a multiple choice question in the Form.

Right now it sums up the multiple choice answers in one line, like this: ["Optie 1","Optie 2","Optie 4"]
But I need them to be summarized underneath eachother with, preferably bullit style.

I already did some research and found a suggestion to seperate the answers with Parse JSON, but then it just sends out separate emails per answer, not what I need.

Also tried to add step to first create HTML table, but I am not able to get this to work.

Hope someone can help me with this.

When this works I would also like to add to my flow an automatic outlook calendar invite for the chosen options.

Thanks,

Suzanne

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Suuz 22 on at

Like (0)

Report

This is what I have so far.

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@Suuz

I have multiple choices- Cough, Fever and Respiratory Distress

You need multiple compose actions to store each result in separate compose action.
1. In first compose i am putting dynamic column name from MS Form.
2. Follow rest of the steps-

Thanks
Hardesh

Was this reply helpful? Yes No
Suuz 22 on at

Like (0)

Report

@Hardesh15

Hi Hardesh,
Thank you so much for helping me out.
I followed all the steps you suggested but it is not working for me yet.

This is a screenshot of the flow run failing at Compose 3. What I can see that is different from yours is that at my compose 2 the ] is still at the end.

Here is what I did in the flow:

Any idea what I am doing wrong?

And also what should I do when I have more than 3 options in my multiple choice? (I actually have 9).

Looking forward to your response!

Thanks,
Suzanne

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@Suuz

you need following expressions-
1.
first(split(split(outputs('Compose'),'[')[1],']')) --> Used in Compose 2
2.
split(split(outputs('Compose_2'),',')[0],'"')[1] ----> Used in compose 3.
When you use point 2 expression it will give you first selected choice.
Change the number mark in red from 0 to 8, this will give you each choices in separate compose.

Thanks
Hardesh

Was this reply helpful? Yes No
Suuz 22 on at

Like (0)

Report

@Hardesh15
Hi, I tested this and it only works when all multiple choice options are selected.
How do I get it to work when only some are selected?

Thanks again for your help!
Suzanne

Was this reply helpful? Yes No
Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report

@Suuz

For this kind of situation you need to redesign your flow. Idea is- Suppose we have 3 multiple choices in forms and User selected only 2. When we check items in array it will give out of bound array because there is no 3rd item in array. To overcome this restriction- i appended dummy elements in array. In my example i have appended dummy element 1 in array. and later i used condition block to check if Variable value is 1 or not. if it is not 1 then get clean choice in compose action.
1234
You need to append as many elements based on your number of choices. Suppose you have 5 choice then you need to append 5 elements in array. This way when user select 2 choices then array have [choice1, choice2, 1,1,1] and When you compare in condition only choice1 and choice 2 will be filtered. Later you can use all in Email.

Thanks
Hardesh

Was this reply helpful? Yes No