I'm creating an app with a SharePoint list as the data source. I have a Status column that is a dropdown with Not Started, In progress, Completed, Cancelled as the different options. I have a Gallery (RecordView) that has a list of all records. The screen (MyHomeGallery) will show records based on what team they are on, so I don't want to count all the records of each Status in the list. I'm trying to use the UpdateContext, outside the Gallery, to count the number of records for each type when the page loads.
I've tried a couple things with no success. Here is what I have now in OnVisible of MyHomeGallery screen:
I have a Label above(outside) the Gallery, at the top of MyHomeGallery screen that has in Text:
I've tried many different formulas and can't figure out what I'm doing wrong.
I appreciate any help! Thanks!
Try this code
CountIf(RecordView.AllItems, Status = "New")
Please Accept as Solution if this post answered your question so other members can find it. If you found this post helpful consider giving my post a Thumbs Up!
Hi @Kay_DeFries ,
Did you mean that you want to count the number of records for each kind of status? If so, then you should use below formulas in the Texy property of each label controls to show the numbers instead:
I do want to count all of the variables, but in different labels at the top of the screen. I thought if I could get one to work, I could figure the rest out.
I tried your suggestion and am getting the error message: Invalid argument type Location
Any other thoughts/suggestions?
Hi @Kay_DeFries ,
What is the formula you use? And what is the column type of Location?
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand