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

Showing a Label well all fields are a specific output!

Hello PowerApps community!
Just getting started with PowerApps 🙂

I have created an application to track the statuses for IT emergencies.
My PowerApp is connected to a SharePoint List. On the SharePoint List, there is a column called "Status" which has 2 potential options:
1. Resolved
2. Open

What I am trying to do:
I'm trying to create a way for the PowerApp to check the Status field to say:
If ALL the values in the "Status" field is "Resolved", then hide this button. Otherwise if there is anything different including "Open", then show this button.

Thanks much and here are some screenshots/documentation!

1. On the button's Visible property, I have tried to add the following:
If(HomeGallery.Selected.Status.Value = "Open", true,false)


*this does not seem to work because it only checks the last value that I clicked on

Attached are some helpful pics!
Button Logic.PNGButton LogicPowerApp Status.PNGThe View of the PowerappHomeGallery Status Label.PNGNav

1 ACCEPTED SOLUTION

Accepted Solutions
PowerAddict
Level 10

Re: Showing a Label well all fields are a specific output!

There are many ways you can do it. One of them is: 

 

If(CountIf(HomeGallery.AllItems, Status.Value = "Open") = CountRows(HomeGallery.AllItems), true, false)

 

I am counting the rows within the gallery for which the status is Open. Then I am counting the total number of rows in the gallery. If the two are equal, then I am setting the visible property to true, if not, then false. 

 

Let me know if this helps. 

 

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit(Haman)

View solution in original post

3 REPLIES 3
PowerAddict
Level 10

Re: Showing a Label well all fields are a specific output!

There are many ways you can do it. One of them is: 

 

If(CountIf(HomeGallery.AllItems, Status.Value = "Open") = CountRows(HomeGallery.AllItems), true, false)

 

I am counting the rows within the gallery for which the status is Open. Then I am counting the total number of rows in the gallery. If the two are equal, then I am setting the visible property to true, if not, then false. 

 

Let me know if this helps. 

 

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit(Haman)

View solution in original post

axt3641
Level: Powered On

Re: Showing a Label well all fields are a specific output!

Worked like a charm. Thank you so much! 🙂

PowerAddict
Level 10

Re: Showing a Label well all fields are a specific output!

Glad it worked! Good luck with the rest of the app! Feel free to reach out in case of any questions!

 

Thanks,

Hardit

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 (6,057)