Unanswered

Skip a HTML Table Row if data is blank?

(1) Share

Report

Posted on by PT-19081038-0

I'm using a HTML Element to display a table of data that's retrieved from a Sharepoint List.
The HTML table is currently templated for 5 rows of data.
But sometimes only 1 or 2 rows are needed so I'd like to skip blank rows if the first data check is blank.

My HTML row looks like this:

<tr>
<td style='width: 93px;'>" & sideGal.Selected.'Name 02:' & "</td>
<td style='width: 120px;'>" & sideGal.Selected.'ID 02:' & "</td>
</tr>

I assume I need something like:
// This is row 2 inside of already existing HTML so use an ampersand/& to interrupt
& If(!IsBlank(sideGal.Selected.'Name 02:'), [TABLE ROW CODE HERE]) & /* back to HTML */

But I'm struggling to combine the Power App code with the HTML.

Can anyone assist, please?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Nandit 1,568 Moderator on at

Like (1)

Report

Hi PT-19081038-0,

Is there a reason why HTML control is required to display a table?

You can make use of the Table control and just update the Items property with your SharePoint List.

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
PT-19081038-0 22 on at

Like (0)

Report

@Nandit
A Data Table doesn't allow for any sort of customisation (as far as I can tell). And creates one long row of data which isn't readable.

Was this reply helpful? Yes No
Suggested answer

CA1105 545 Super User 2025 Season 2 on at

Like (0)

Report

May be you can create one variable with the HTML which you are getting from SharePoint list and remove those rows which are not needed and then bind HTML control with that variable?

Was this reply helpful? Yes No
Suggested answer

timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report
Hi PT-19081038-0

I think you're close with your If statement. I'd suggest something like this:

"<Table>" & If( !IsBlank(sideGal.Selected.'Name 01:'), "<tr> <td style='width: 93px;'>" & sideGal.Selected.'Name 01:' & "</td> <td style='width: 120px;'>" & sideGal.Selected.'ID 01:' & "</td> </tr>" ) & If( !IsBlank(sideGal.Selected.'Name 02:'), "<tr> <td style='width: 93px;'>" & sideGal.Selected.'Name 02:' & "</td> <td style='width: 120px;'>" & sideGal.Selected.'ID 02:' & "</td> </tr>" ) & If( !IsBlank(sideGal.Selected.'Name 03:'), "<tr> <td style='width: 93px;'>" & sideGal.Selected.'Name 03:' & "</td> <td style='width: 120px;'>" & sideGal.Selected.'ID 03:' & "</td> </tr>" ) & If( !IsBlank(sideGal.Selected.'Name 04:'), "<tr> <td style='width: 93px;'>" & sideGal.Selected.'Name 04:' & "</td> <td style='width: 120px;'>" & sideGal.Selected.'ID 04:' & "</td> </tr>" ) & If( !IsBlank(sideGal.Selected.'Name 05:'), "<tr> <td style='width: 93px;'>" & sideGal.Selected.'Name 05:' & "</td> <td style='width: 120px;'>" & sideGal.Selected.'ID 05:' & "</td> </tr>" ) & "</table>"

Was this reply helpful? Yes No