Answered

How to do i get the HTML viewer with a checkbox to get data from yes no field of a sharepoint list for report genertating

(0) Share

Report

Posted on by Theatreguy

Hello everyone,

Im sooooo close to being able to being able to generate a "report" from a inspection checklist i have created. One of the final pieces to be able to do this is this.-

To create this report I'm using HTML viewer and pulling data from a sharepoint list that has been updated when the user completes the checklist. I have created a Table to display this data (see picture attached) I have with the question being asked, a checkbox and a notes section. I have the questions displaying using LookUp(Questions,ID = 1).Title. same for notes. I have tried to do the same for the checkbox but with no success, The column that contains the checkbox in the sharepoint list is set to Yes/No .

Does anyone know how i can can get the HTML code to look at a that certain field and apply it to the checkbox and display a tick if it was selected during the inspection?

Any help would be really appreciated,

Thanks,

Rob

Categories:

Building Power Apps

All responses (15)

Answers (1)

Sort by

Michael E. Gernaey 53,970 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I am sorry, I do not understand what you are trying to do. Can you explain just the checkbox (leave the other fields out) and how it relates to the list and the report, please

Are you trying to get the value of the checkbox (check or unchecked) from the SharePoint list, so it shows checked or not in the Table?

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Theatreguy 48 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @FLMike

That's exactly what I'm trying to do. You got it pretty much spot on, I want do get the value of the checkbox (check or unchecked) from the SharePoint list, so it shows checked or not in the Table with in the HTML viewer.

Thanks,
Rob
Theatreguy 48 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @FLMike,

I have tried so many different ways to make this work but no luck. Do you of a way or somewhere i might be able to find the solution?

This is the HTML code i have for one of the sections. In bold is where i struggle to get the data
<tr>
<td>" & LookUp(Questions,ID = 1).Title & "</td>
<td><label class='checkbox-label'><input type= 'checkbox'> </label></td>
<td><textarea placeholder=''> "& LookUp(Questions,ID = 1).Notes & "</textarea></td>
</tr>

thanks,
Rob
Michael E. Gernaey 53,970 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Give me a few, also.. i am certain I owe you an answer for another thing doesn't I? and I said i would do it the next morning.. if so can you ping me with that link on this thread please.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Theatreguy 48 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @FLMike ,

I managed to figure it out the other thing. I ended up using power automate and it works well.

But yes any help with this would be amazin

thanks,
Rob
Theatreguy 48 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @FLMike

Just wondering if you had any thoughts on this? I was trying
"<input type='checkbox' id='myCheckbox' " & If(YourSharePointList.Selected.YesNoColumn, "checked", "") & " />" & "<label for='myCheckbox'>Checkbox</label>"
That i found online but i cant seem to figure this out.

Thanks,
Rob
Michael E. Gernaey 53,970 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Theatreguy

Sorry for the long long delay. I was curious though why use the HTML Text control to build the report?

Anyway the answer is
"checked='checked'" not just checked

If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Theatreguy 48 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @FLMike

Thanks for answer. I'm still struggling to implement this solution.

This is the HTML code im using for the table
<td>" & LookUp(Questions,ID = 2).Title & "</td>
<td><label class='checkbox-label'><input type='checkbox'> </label></td>
<td><textarea placeholder="& LookUp(Questions,ID = 2).Notes & "></textarea></td>

Where about would i add the code to make this work and how would it look?

The the sharepoint list is called questions, the ID is 1 and the checkbox column is called Complete.

Thanks again for all your help so far
Rob
Verified answer

Michael E. Gernaey 53,970 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Here @Theatreguy

<td><label class='checkbox-label'><input type='checkbox'> </label></td> Change this <input type='checkbox'> to "<input type='checkbox'" & If(LookUp(Questions, ID = 1).Complete, " checked='checked' ") & "></label></td>"

That is how I would build THAT specific line. I have no idea how you are building your lines, but that is what you need.

If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
Theatreguy 48 on at

Like
a
(1)

Report
Copy link

Link copied!

@FLMike

You are a legend!! This worked!

I'm sure i have build my lines wrong but when i entered what you put it worked.

Cant thank you enough for your help
Rob