cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pjotaramos
Frequent Visitor

IsBlank Function for all items in gallery

Hey guys!

 

I want to set a button to be visible only when all my dropdownboxes (in a gallery) are not blank. 

 

In "Visible" field I coded: 

 

 

!IsBlank(DropdownBoxInGallery.Selected.Value) 

 

 

It works but only when the first Item is not blank, I need it when all the Items are not blank.

 

I tried to use some other functions but nothing seems to work.

 

Any idea?

1 ACCEPTED SOLUTION

Accepted Solutions
eka24
Super User
Super User

I will suggest this approach;

Insert a Label3 in the Gallery and put in the Text property: 

If(DropdownBoxInGallery.Selected.Value="",0,1)

 

Then in the Visible of the Button;

CountRows (Gallery1.AllItems)= Sum(Gallery1.AllItems, Value(Label3.Text))

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

3 REPLIES 3
eka24
Super User
Super User

I will suggest this approach;

Insert a Label3 in the Gallery and put in the Text property: 

If(DropdownBoxInGallery.Selected.Value="",0,1)

 

Then in the Visible of the Button;

CountRows (Gallery1.AllItems)= Sum(Gallery1.AllItems, Value(Label3.Text))

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

v-siky-msft
Community Support
Community Support

Hi @pjotaramos ,

 

Please try to put the following code to Visible property of button.

Not(true in AddColumns(GalleryName.AllItems,"A",IsBlank(DropdownBoxInGallery.Selected.Value)).A)

Hope this helps.
Sik 

pjotaramos
Frequent Visitor

Wow! Such a clever idea. 

 

Thanks bro!

 

Regards,

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,253)