Display SP list with numbering

lunalovegood · ‎10-05-2023

Good day everyone!

I have Sp list named "ABC LESSON LEARNED" and have multiple columns, one of the columns titled "Recommendation", sometimes there will be more than 1 recommendation per row, so i numbered the recommendations (refer figure below)

but when i call the column and display it in powerapps, the powerapps reads the row as plain text (refer figure below),

btw, i display it using html text.
by any chance, can anyone help me to figure out how can i display the recommendation column sequentially .

Thank you so much for the help !

FLMike · ‎10-05-2023

Hi @lunalovegood

Is the column a Multi line Regular Text or is it Multiline Rich Text (probably this one?)

And is it a Table. You said you display it with HTML Text, but you didn't specific with what.

Lastly, what type of control are you using to display is it the HTML Text Control? If not then use this and it should show up fine as long as you have it, how I talk about in my next point.

My answer would be this. If you created the HTML as a Table, where each one was a row, it technically would be in sequential order, however, depending on how wide they are etc and the form its possible they wouldnt always line up. They SHOULD, as long as your Table TR and TD have the text aligned to the left.

That is what I would do.

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

lunalovegood · ‎10-05-2023

This is the column setting :

This is the HTML code that i insert in HtmlText Property:
"<!DOCTYPE html>
<html>
<head>
<title>Checklist Interface</title>
<style>
table {
font-family: arial, sans-serif;
width: 100%;
}
th:nth-child(2),a
td:nth-child(2) {
width: 2%; /* Adjusted width for Completed column */
}
th:nth-child(3),
td:nth-child(3) {
width: 2%; /* Adjusted width for Remarks column */
}
th {
padding: 5px;
border: 1px solid #dddddd;
text-align: left;
font-weight: normal;
font-size: 25px;
}
td {
padding: 5px;
border: 1px solid #dddddd;
text-align: left;
font-size: 18px; /* Reduced font size by 2 */
}
input[type='checkbox'] {
transform: scale(0.7);
margin-left: 40%; /* Adjusted margin to center the checkbox */
}
p {
font-family: arial, sans-serif;
width: 100%;
font-size: 18px; /* Reduced font size by 2 */
text-align: justify;
}
</style>
</head>
<body>
<h1 style='font-size: 15px;text-align: center;'>Checklist Form</h1>
<p style='font-size: 15px;'>Department : </p>
<p style='font-size: 15px;'>Checked By : </p>
<table border='1%'>
<thead>
<tr>
<th style='padding: 5px; font-size: 14px;text-align: center; width: 80%;'>Recommendation</th>
<th style='font-size: 14px;text-align: center; '>Tick</th>
<th style='font-size: 14px;text-align: center;width: 70%;'>Remarks</th>
</tr>
</thead>
<tbody>
" & Concat(
Gallery1.AllItems,
" <tr><td><p style=' text-align: justify; font-size: 12px;' >" & Recommendation & "</p></td><td></td><td></td></tr> "
) & "
</tbody>
</table>
<div class='footer'>
<p style='font-size: 15px;text-align: right; margin-right: 200px;'>Approved By: </p>
</div>
</body>
</html>
"

FLMike · ‎10-05-2023

Hi @lunalovegood

Thank you for sharing that made it make perfect sense as to why its happening

The issue being that if you just had 1 item, per recommendation they would line up, but we have to split your Recommendation text, not just place it in the HTML Text property

We need to find something we can split it on, do you have any ideas? Or, is this live yet? Could we change how the Recommendations are put in so that not only would it have a number, but it needs something at the end of each recommendation to split on (when there are more than 1 per row).

So like

1 My Text@@@My Next Text@@@

So we could split on

That or you have something already like a carriage return ? or something?

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

lunalovegood · ‎10-05-2023

you mean that i need to do modification on SP list is it ?

FLMike · ‎10-05-2023

Hi @lunalovegood

I am asking how are the Recommendations created and saved into the List?

So I guess the answer is, yes, kind of. There is no way to really help you do what you want, if you have multiple things in there and have no way to split the values into individual strings so they can be put in a Table (per row) or at least add carriage returns in the data.

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

lunalovegood · ‎10-05-2023

can you explain more about add carriage returns in the data?

lunalovegood · ‎10-05-2023

i just notice that in my html code , i use concat() function that will join multiple strings together, so im guessing that's the reason why , i think i need to use function that will directly call the column without changing the format of the column

Display SP list with numbering

Helpful resources

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Summer of Solutions | Week 4 Results | Winners will be posted on July 24th

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

Updates to Transitions in the Power Platform Communities