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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

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

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,983)