cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Microsoft RusselThomas
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

 

jaylou
Level 8

Re: Make a label visible when a column is blank

Thanks Laura,

That worked perfectly.

 

Thanks Again,

Joe

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (3,668)