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 these cool Power Apps & vote on your favorite!
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021