Answered

HOW TO NOT SHOW A SPECIFIC DATA INSIDE A HTML TEXT WHEN IS BLANK...

(0) Share

Report

Posted on by Gorilla_8

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>

Categories:

Building Power Apps

I have the same question (0)

All responses (34)

Answers (1)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report
@Gorilla_8

Try to change your formula to the following:

... "$ " & Coalesce('Resumo Transporte Total'; "-") & "</td>" ...

I hope this is helpful for you.

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report

@RandyHayes Thanks for the reply!

But the PowerApps says "The 'Coalesce' function has some invalid arguments"

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@Gorilla_8

Which argument is it complaining about? You can put your pointer over each for more detailed information.

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report

All the function

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@Gorilla_8

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?

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report

A gallery data...

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Gorilla_8

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)

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report

Yes, I get the item on HTML editor, but I wanna show a "-" if is blank or not show the field.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Gorilla_8

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'; "-")

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report

Yes, I use ";", didn't work out...

Was this reply helpful? Yes No