Announcements
I created a power app from a list. I need help showing the total number of open tickets that are assigned to a particular area. Currently, I can see a number of all tickets with the status of "Open" using formula CountRows(Filter('Production Stoppage - DRAFT 1',Status.Value="Open")). However, I need to narrow it down to show the number of tickets with an "Open" status from the area "Vertical".
Hi @Evan_S1,You can use && || operator to add another condition to your formula -CountRows(Filter('Production Stoppage - DRAFT 1', Status.Value="Open" && Area.Value="Vertical"))Assuming Area to be of choice type.
This works perfect, thank you!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 339 Most Valuable Professional
11manish 180
MS.Ragavendar 88 Super User 2026 Season 1
