cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
NderonH
Level: Powered On

How to check whether status is equal to "Completed" for all items in Gallery1

I have a button named `Dergo` and I have a gallery which shows my sharepoint list items. Foreach item in my Gallery I have a field named `Verified` and by default it is false, Now I want the button to be displayed if `Verified` is set to true in everyItem

errorPW.PNG

 

foreach item in this gallery the Verified field needs to be true to show the button.

I have tried this formula in Visible functuon but it is not working 

 

If(Gallery1.AllItems.Verified=true,true,false)

I have also tried this but still with no luck

 

 

If(ForAll(Gallery1.AllItems.Verified,Verified=true),true,false)

Help me

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: How to check whether status is equal to "Completed" for all items in Gallery1

Hi @NderonH

 

Here's a formula that might work better for you:

 

CountIf(Gallery1.AllItems, Verified=true) > 0
3 REPLIES 3
Super User
Super User

Re: How to check whether status is equal to "Completed" for all items in Gallery1

Hi @NderonH

 

Here's a formula that might work better for you:

 

CountIf(Gallery1.AllItems, Verified=true) > 0
NderonH
Level: Powered On

Re: How to check whether status is equal to "Completed" for all items in Gallery1

it is working perfect, thank you so much for your quick answer

Super User
Super User

Re: How to check whether status is equal to "Completed" for all items in Gallery1

You're welcome!