cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jaylou
Level 8

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
LauraEmberson
Level: Powered On

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
LauraEmberson
Level: Powered On

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

Super User
Super User

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

 

jaylou
Level 8

Re: Make a label visible when a column is blank

Thanks Laura,

That worked perfectly.

 

Thanks Again,

Joe

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 274 members 6,222 guests
Recent signins:
Please welcome our newest community members: