Make a label visible when a column is blank

[jaylou]

Hi all,

I have a list where I make columns Visible based on other columns.  

I would like to hide a label with the same criteria, but it is complaining about the IsEmpty function.

the error is "The function 'IsEmpty' has some invalid arguments"

I am using  If(IsEmpty(AuditedBy),true,false) in other columns to hide them when Audit did not approve yet.

Ultimatly, what I want, is to have 2 labels one for when "AuditedBy" is empty and another when it's not. 

Is this possible?

TIA,

Joe

[LauraEmberson · Accepted solution]

Hi Joe

I use

If(IsBlank(Datacardvalue5),true,false)      true,false = Then show it!

Basically if you want something to show if it is NOT blank then use:

If(!IsBlank(Datacardvalue5),true,false)        ! is to say if it isn't blank... if it is remove the !

Hope this helps.

Sorry that seems a rather confusing way to type it!

[RusselThomas]

Hi Joe,

Do you perhaps have some screenshots to show what you're doing?

Reason I ask is that IsEmpty() checks to see whether a table is empty or not. 

When you say 'list' do you mean a sharepoint list, or a gallery, form or data table displaying that list or a collection of that list in PowerApps?

I'm not really sure how it's working for you in the current context, some screenshots might help 🙂

Kind regards,

RT

[jaylou]

Thanks Laura,

That worked perfectly.

Thanks Again,

Joe