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 (Last 30 Days)
Users online (5,698)