Answered

Showing a Label well all fields are a specific output!

(0) Share

Report

Posted on by axt3641

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 LogicThe View of the Powerapp Nav Nav

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

PowerAddict 7,316 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
axt3641 69 on at

Like
a
(0)

Report
Copy link

Link copied!

Worked like a charm. Thank you so much! 🙂

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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

Thanks,
Hardit

Was this reply helpful? Yes No