cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate V
Advocate V

Make a label visible when a column is blank

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Advocate II
Advocate II

Re: Make a label visible when a column is blank

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!

View solution in original post

3 REPLIES 3
Highlighted
Advocate II
Advocate II

Re: Make a label visible when a column is blank

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!

View solution in original post

Highlighted
Microsoft
Microsoft

Re: Make a label visible when a column is blank

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

 

Highlighted
Advocate V
Advocate V

Re: Make a label visible when a column is blank

Thanks Laura,

That worked perfectly.

 

Thanks Again,

Joe

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (7,362)