Unanswered

Filter HTML Table to show NoDataText in Email

(0) Share

Report

Posted on by PEBKAC

Hello,

I'm using an onclick function in powerapps that sends an email and within the body filters an html table. When I have data it works great, but what I'm looking to achieve if there is no data can I input a simple message to replace header row with a no rows? I've playing around with different way based on forms like isBlank or NoDataText with no luck in the html table. Simple example below. Thx!

"<table width='500' border='1' cellpadding='1' style=font-size:10px style='border:1px solid black; border-collapse:collapse'>" &
 "<tr style='background-color:#efefef'>
 <th>Item</th> <th> Adjusted Cost </th><th> Remarks </th>
 </tr>
 <tr>" &
 Concat(
 Filter(
 'Cost Report', Item ; 'Remarks') ,
 "<td>" & Item & " </td>
 <td>" & 'Adjusted Cost' & " </td>
 <td>" & 'Remarks' & " </td>","</tr><tr>") & 
"</table>"

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @PEBKAC

Try somehting like this:

"<table width='500' border='1' cellpadding='1' style='font-size:10px; border:1px solid black; border-collapse:collapse;'>" & "<tr style='background-color:#efefef;'> <th>Item</th> <th> Adjusted Cost </th><th> Remarks </th> </tr>" & If( IsEmpty('Cost Report'), "<tr><td colspan='3'>No data available</td></tr>", Concat( Filter( 'Cost Report', Item ; 'Remarks') , "<tr><td>" & Item & "</td><td>" & 'Adjusted Cost' & "</td><td>" & 'Remarks' & "</td></tr>") ) & "</table>"

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
PEBKAC 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SpongYe I appreciate your help and that's a thought I hadn't tried yet however not seeing any errors in the code something is breaking the send email step with the onclick function. I've tried to move both above and below the concat filter.