Announcements
Hey guys, I need to not show data when a row is blank inside an HTML text...
Like this:
<td style='width: 213px;'>" & "$ " & If(IsBlank("-";'Resumo Transporte Total')) &"</td>
@Gorilla_8
Try to change your formula to the following:
... "$ " & Coalesce('Resumo Transporte Total'; "-") & "</td>" ...
I hope this is helpful for you.
@RandyHayes Thanks for the reply!
But the PowerApps says "The 'Coalesce' function has some invalid arguments"
Which argument is it complaining about? You can put your pointer over each for more detailed information.
All the function
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?
A gallery data...
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)
Yes, I get the item on HTML editor, but I wanna show a "-" if is blank or not show the field.
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'; "-")
Yes, I use ";", didn't work out...
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 534
WarrenBelz 416 Most Valuable Professional
Valantis 306
