How to write multiple choice answers in html ?

Like (0) Share

Report

Posted on 31 Jul 2023 10:16:48 by Community Power Pla...

Hello everyone,

I have a form in Power Apps, where users can select multiple answers :

These choices are saved in a SharePoint list.

Then, in power automate, I want to create a PDF file from the item in the list using html code.

Every thing works except the fields where users can select multiple answers (such as the one above) :

In my flow, I use the "compose" action to write html code :

For multiple choice questions, I have these three options.

Here, I chose the last one since the first two add a "for each" loop on the "compose" action and completely mess up my pdf file.

Thanks,

Max

I have the same question (0)

All responses (6)

Answers (0)

Community Power Pla... on 07 Aug 2023 at 09:11:41

Like (0)

Report

Re: How to write multiple choice answers in html ?

@ManishSolanki I'm still working on that flow and am facing a new issue.

Basically, the flow used to run on one single item of my sharepoint list ("when an item is created"). Now, I want to change that flow so that it does the exact same thing but on every item in the list.

I understant that I have to use "Get items" instead of "Get item" and that I need an "Apply to each" loop to do the same actions on each item of the list. However, some of the old actions don't seem to work correctly in this loop, like the "Select" action for example.

This "Select" action is automatically put in a new "apply to each" action and I don't understand why. I wrote a post (https://powerusers.microsoft.com/t5/Building-Flows/Run-flow-on-multiple-lines-of-SharePoint-list-filter/m-p/2281364#M253502) about this but can't find a solution so I thought you might have an idea.

Thanks,
Max

Was this reply helpful? Yes No
Community Power Pla... on 01 Aug 2023 at 11:21:12

Like (0)

Report

Re: How to write multiple choice answers in html ?

Forgot to mention that this was the output of the multiple choice field in final "Compose" action :

<p><input type="checkbox" checked/>Lettre d'accompagnement de la révision<br><input type="checkbox"/>Communication dédiée<br><input type="checkbox" checked/>Formation spécifique</p>

Was this reply helpful? Yes No
Community Power Pla... on 01 Aug 2023 at 11:18:08

Like (0)

Report

Re: How to write multiple choice answers in html ?

@ManishSolanki Thanks for your help !

I have the flow works (no errors) but the pdf doesn't correspond to what I expected.
This is what I picked from the multiple choice dropdown in Power Apps :
But this is what I get in my PDF :
No checkboxes and not the selected choices 🤔

This is what my flow looks like (I followed your flow but did it twice since I have to fields where there are multiple choices questions) :
Then in my main "Compose" action :
Not sure what happened.

Thanks,
Max

Was this reply helpful? Yes No
ManishSolanki 15,089 Super User 2025 Season 2 on 01 Aug 2023 at 10:01:35

Like (0)

Report
Re: How to write multiple choice answers in html ?

Hi @Anonymous

I know you are making something special using power automate 🙂

I tried designing a snippet that will create an html tag (checkboxes) based on the options selected in the multichoice field.
1. I have taken all the possible values of choice fields in an array in Compose action, but you may store in SP list or variable as per your need and initialize an array variable 'varCheckBoxHTMLTagsArray' that holds the final checkbox input tags:

2. Next, we will store all the selected choice from list item in an array. We use "Select" action to separate it from the other properties to make an array of it:
Click "Switch to text mode" on the right side of the Select action:
Choose the value of multichoice field from Dynamic content to set its value in Map property:

3. Now, we will iterate all the possible choice values and find those which are being selected in SP list item. If selected, we will add an attribute checked to input field.
You need to write an expression in the If condition to check if choice is being selected or not.
Expression used for left hand operand:
contains(body('Select'),item())
Expression used for right hand operand:
true

In "Yes" section append the variable with checked attribute:
In "No", no need to add an attribute:

4. Finally, you can join the array variables with line break tag (<br>):
Expression used in the above screenshot:
join(variables('varCheckBoxHTMLTagsArray'),'<br>')
The output of 'Compose 2' action will give you the required html code.

I hope this helps you in designing the logic to complete your flow.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Community Power Pla... on 31 Jul 2023 at 11:52:15

Like (0)

Report

Re: How to write multiple choice answers in html ?

@ManishSolanki Thank you very much !
Do you know if instead of joining the choices with a comma, I could put all the choices in checkboxes and only check the ones corresponding to the users choice ?
Something like this :

Seems complicated to me but we never know 🙂

Was this reply helpful? Yes No
ManishSolanki 15,089 Super User 2025 Season 2 on 31 Jul 2023 at 11:11:32

Like (0)

Report
Re: How to write multiple choice answers in html ?

Hi @Anonymous

One workaround is to join the choices with comma (,) and then add that single string in the html code. To make a string for multi choice field, pls follow the below steps:

1. Use the "Select" action, to make an array of choices, here 'MultichoiceCol' is the field in SharePoint list:

2. Next, press "Switch to text mode" button present on the right side of "Select" action:

3. Set the multichoice column value in the Map textbox from the Dynamic content:

4. Now, add a Compose action and write an expression using join() function to make a single string. The expression needs to be put in the expression window as shown below:
Expression used with join() function:
join(body('Select'),', ')

The output of the compose action will give a string that contains are the selected choices separated by comma (,). This can be used in another in html code for showing the values of multiple-choice field.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No