Answered

Blank check fails for RichText field

(0) Share

Report

Posted on by Poweruser32490

126

I have a multiple lines of text column in Powerapps which is of type RichText. The column has content like below when exported to excel.

</div>

I am using this column in Powerapps visible property to show/hide this column. I noticed that the blank check passes for and but fails for </div>. May i know why?

Blank Check OnVisible of Datacard

If(
    !IsBlank(
        Trim(
            PlainText(
                LookUp(
                    'DataSource',
                    Country.Value = varCountry && State.Value = varState,
                    Q14
                )
            )
        )
    ),
    true,
    false
)

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Poweruser32490,

Please try below formula:

If( !IsBlank( Trim( Substitute( PlainText( LookUp( 'DataSource', Country.Value = varCountry && State.Value = varState, Q14 ) ), UniChar(8203), "" ) ) ), true, false )

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Poweruser32490,

I will add something here as @Kalathiya's response is almost correct except substituting "" (empty string) for a value fails the IsBlank test. The easiest way is use Len (length) of the returned data. Also you do not need If/true/false to return a Boolean value - just make a statement that has to be either true or false (see this blog of mine)
Len( Trim( PlainText( LookUp( 'DataSource', Country.Value = varCountry && State.Value = varState ).Q14 ) ) ) > 0

So if the length is greater than zero (there are characters left in it), the statement will return true, otherwise it will return false. Note that there are also some hidden zero-length characters present (8203), however the Len() test also takes care of these in the code above.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Verified answer

Assisted by AI

Bitcot Automations 23 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Poweruser32490

Your formula is logically correct, but it fails because Rich Text fields contain hidden characters even when the field looks empty.

Your expression:
If(

!IsBlank( Trim( PlainText( LookUp( 'DataSource', Country.Value = varCountry && State.Value = varState, Q14 ) ) ) ), true, false )

Problem occurs in this case:
 </div>

Inside  there is an invisible Unicode character (usually Zero-Width Space – Char(8203)).
So Power Apps reads it like this:

Step Result

PlainText() ""

Trim() ""

IsBlank() False

Even though visually it looks empty, Power Apps does not consider it blank.

Also note:
Trim() only removes normal spaces, not invisible Unicode characters.

Best Solution

Remove invisible characters before checking.
Clean + Check pattern

Len( Trim( Substitute( PlainText( LookUp( 'DataSource', Country.Value = varCountry && State.Value = varState, Q14 ) ), Char(8203), "" ) ) ) > 0

Was this reply helpful? Yes No
Assisted by AI

Poweruser32490 126 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Bitcot Automations

I get an error while i apply above code. May i know how to solve this?

The first argument to the char function must be between 1 and 255

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Poweruser32490,

Did you try what I posted ? The reason I did not use Substitute was exactly that - the character is not able to be referenced using Char(). As the character is zero-length, the Len (Length) function will test all other characterspresent, but not that one.

Was this reply helpful? Yes No
Poweruser32490 126 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz,

Yes i tried what you posted. However the issue occurs for </div>

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Poweruser32490,

The PlainText() function should delete those.

Was this reply helpful? Yes No