Answered

Total created and total completed based on branch dropdown

(0) Share

Report

Posted on by ShadowTech

Hello,

I have a couple labels that I want to show the total SharePoint list count based on the Gallery being filtered by the Branch dropdown. Branch is of course the Office Location.

So basically I have a button that when pressed shows stats (In a label) for the current branch chosen from the dropdown.

Total items created (not sure about the rest)

If(BranchStatsButton2,CountRows(Filter(AllBranches,BranchDropdown.Selected.Value,

Total Completed (Status field) based on chosen branch. (Not producing required results)

If(
 BranchStatsButton2,
 CountRows(
 Filter(
 AllBranches,BranchDropdown.Selected.Value,
 Status.Value = "Completed"
 )

Any help would be much appreciated.

Thanks in advance.

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@ShadowTech ,

I assume this is the complete current problem you have posted.

If you want all records created

If( BranchStatsButton2, CountRows(AllBranches) )

Assuming the name of the field in AllBranches is Branch and it is a Choice column

If( BranchStatsButton2, CountRows( Filter( AllBranches, Branch.Value = BranchDropdown.Selected.Value && Status.Value = "Completed" ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
ShadowTech on at

Like
a
(0)

Report
Copy link

Link copied!
@WarrenBelz Right. Basically I need both labels to show counts for total of the SharePoint list (gallery) if Branch drowpdown is "All" or by the branch choice.

So I changed total items to this which counts all records per branch dropdown choice.
If( BranchStatsButton2, CountRows( Filter( AllBranches, Branch.Value = BranchDropdown.Selected.Value ) ) )

but for some reason when the dropdown choice is "All", I get a zero.

Thoughts?
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@ShadowTech ,

You might go back to some previous code I did for you and see if you can see the concept

If( BranchStatsButton2, CountRows( Filter( AllBranches, BranchDropdown.Selected.Value = "All" || Branch.Value = BranchDropdown.Selected.Value ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
ShadowTech on at

Like
a
(0)

Report
Copy link

Link copied!
@WarrenBelz Awesome, that did it. So to finish off my question, what would be the best way to apply to the status label?

If( BranchStatsButton2, CountRows( Filter( AllBranches,Branch.Value = BranchDropdown.Selected.Value && Status.Value = "Unopened") ) )

Thanks again for the help.
Verified answer

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@ShadowTech ,

You just need to apply the correct and/or bracketing

If( BranchStatsButton2, CountRows( Filter( AllBranches, ( BranchDropdown.Selected.Value = "All" || Branch.Value = BranchDropdown.Selected.Value ) && Status.Value = "Unopened" ) ) )

I assumed you might be able to put the two bits together.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
ShadowTech on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Thank you sir.