Hey guys, I need to not show data when a row is blank inside an HTML text...
<td style='width: 213px;'>" & "$ " & If(IsBlank("-";'Resumo Transporte Total')) &"</td>
Solved! Go to Solution.
"<tr>" & Concat(MasterGalleryHTMLDADOS.AllItems; If(IsBlank('Resumo Transporte Total'), "", "<td style='color:#61033A;'> RESUMO TRANSPORTE </td> <td style='width: 213px;'>" & Text('Resumo Transporte Total'; "[$-pt-BR] $ #,00")) & "</td>" ) ) & "</tr>"
Try to change your formula to the following:
... "$ " & Coalesce('Resumo Transporte Total'; "-") & "</td>" ...
I hope this is helpful for you.
Which argument is it complaining about? You can put your pointer over each for more detailed information.
It should give more specifics on the issue, but anyway...
What is 'Resumo Transporte Total'?
What context is this Html control in? A gallery, a Screen, a Form?
If 'Resumo Transporte Total' is in AllItems of the Gallery and it is a text field, then the formula provided - Coalesce('Resumo Transporte Total', "-") - should work just fine.
If you take all the logic out and just put 'Resumo Transporte Total' in your Concat function/Html builder, do you get the results? (i.e. take out your original If function and my Coalesce function and just put the field name in)
Yep, Coalesce will do the trick.
Are we having a comma vs semicolon issue? I was reviewing your original posting and noticed you are using semicolon separation in your formulas...If that is the case, then my formula to you should have been:
Coalesce('Resumo Transporte Total'; "-")
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.