Power Apps CountRows, CountIf, CountA, and Count vs Delegation 

Got your explanation the first time. Coming from someone with a learning disability, you explained it very well (though watching your delegation video helped with providing context)! I also enjoy the shorter format. I would love to see more dataverse videos. You did a great video on relationships using dataverse tables but I would love to learn how to relate tables that are “grandchildren”. Example: if you have a product table related to a parts table and then the parts table is related to a supplier table and the supplier table is related to a supplier contact table which that table has an attribute called primary contact. So then I to filter a product and show a portal with all the suppliers for the given product with the primary contact name for that supplier.

Essentially, we need to filter down to the set delegable limit for our apps. Thanks Shane.

That was more information than any other source.Thx.!

CountRows('PowerApps issues', 'Solved by Shane with a video of his' = true)... Not delegable, and the number is too large. Cheers for the video. PS. I'm surprised you haven't mentioned our favourite function (or one of our favourites): With. What I usually do is grab the records into a variable with Filter, thus delegable, then use CountRows on the temp variable, thus delegable, problem solved, as a Power Apps guru would say, easy peasy lemon squeezy.

Great video, thanks! The bonus at the end was awesome. A simple solution in front of my nose that I didn’t see it.

Great video Shane and thanks for the heads up on the new Dataverse setting that will certainly come in handy as I'm trying to do a lot more with Dataverse.

Needed this exactly, thank you so much!

Hi Shane! I loved this video. I use countif for counting confirmed appointments by person. Your option is way better. Thanks. Could you consider to make a video on how to populate Word / Excel template without premium license?

Thank you Shane , amazing as always

Great video Shane; I was able to resolve my issue BUT I'm having to do a filter for everything I want to count in the gallery. Sooo, if I want to count the number of students that completed a class, and the number of students that canceled a class how can I do that based on what's already filtered in the gallery control and avoid doing a FILTER for each?

I always ended up making a flow in power automate to grab large data from SQL/Sharepoint and pass to powerapps in a collection to get around delegation limits, since its not always possible to ensure that your Filter query will return less than 2000 rows, especially on large datasets.

Another great video from your studio Shane. THX

Gallery.AllItems represents only the first 100 records in the gallery until you start scrolling down the gallery, so counting AllItems will confuse users. Relying on there never being more than the delegable number of records in the filtered datasource seems like a bad idea. And countRows still throws delegation errors even though "Enhanced delegation" feature is checked in the settings. I am still afraid to count rows **Edit** CountRows was throwing the delegation error when I was using a view for the gallery. It seems to work on large sets if you use the whole table.

Thanks buddy. your videos are funny and informational at the same time.

Great video! After I apply my needed filter, the row count exceeds the delegation limit of 2,000. It is around 4,500 rows. Is there a way I could get the true count (4,500) in power apps? Note: I am using SQL server as my data source.

Super helpful Shane!! Thank you!

Awesome tip. Will buy you coffee when you are in India/Bangalore. I'm also hoping to steal apps you may have developed for learning purpose.

Hi, Wonder if you can help with a different delegation issue I am having with the Value() function as below: Sort(tableName, Value(fieldName), SortOrder.Descending) This is using a Dataverse table and an AutoNumber field name, from which the Value(fieldName) is returning a delegation warning. Is there an alternative to using Value() that is not delegable? thanks Tony PS - I incorrectly assumed the AutoNumber was a numeric data type (but is actually alphanumeric). As such I am trying to use the Value() to sort this correctly within a gallery.

Thanks Shane, I think I have now watched everyone of your PowerApps Videos, some more than once. They have been a great help getting started with my Apps. A couple of Ideas for new videos. 1, The New PowerApps push notification V2 (what is dynamic parameter?) can it be used to trigger an action within the app? 2, The new Map connector, is there a way of drawing on the map by circling pins and adding them into a collection? I was thinking it might be possible using maps drawing JSON outputs (Latitude and Longitudes), then collecting the pins within that area.

Another great video Shane.

Super helpful, thanks!

Shane, Something interesting happened. When importing a view into a collection, columns created "virtually" are not imported: Example: Table: vw_Quant_students(quant numeric); Creating the view: CREATE OR REPLACE VIEW VW_Amount_alunos AS (select 'ALU' ALU_TYPE, COUNT(*) QTDE from vw_Quant_students) The view will have 2 columns: ALU_TYPE, QTDE. When importing into a collection, the collection only shows QTDE. Is this a limitation from powerapps or me? lol

Thank you Shane 😊

Hi Shane, On the beginning I would like to thank you for your last tip :) You saved my day. I'm not sure if you have seen my post on previous video. I have another problem and I believe you can help. I have created Sharepoint form in Power Apps. I have question in the form and possible answers are 1,0,N/A. Is it possible to display only "Yes", "No", "N/A" instead of 1,0,N/A. So for example when I select "Yes" and submit form I can see on sharepoint list 1. I'm trying to migrate form from infopath when it was set up somehow. Thank you. Regards, Pawel

I'm using a sharepoint list that has about 10 rows of data and when I use the count function to display a dashboard of how many records there are it returns 0. :(

Hi Shawn, great video as always :D, can you please made a video about click counting? So that we can now how many clicks the user did in a session and how to save that in sharepoint

Awesome, as always 😊

Hi Master Shane, I believe that creating views in the database to perform counting operations would be more performative. Am I right ? I created a collection and populated it's content with data from a database view. I couldn't add new columns in the same command as the collection creation. AddColumns(ClearCollect(ColCopia;'VIEW_BASE_DATA');"Type";"Y") I needed to create the first collection with the view data, and the second collection adding the fields. Did I do something wrong ? tks

Super Useful Shane

Can the app delegation limit be called into a variable. Perhaps to use as a check with count rows to see if the is a delegation risk on the filtered data?

Hi Shane , Thanks for the video. I have 4 dropdowns with S & U as common options of all dropdowns. I need the count of Selection of S. That count, I need to place in another text input column. How can we achieve this. Any help is appreciated. Thanks in advance

Danke!

But the gallery only shows the first 100 records unless you scroll. It is amazing to me that I can write and app that links to a SharePoint list of 2000+ records and nowhere in the app can I get an effective count of the number of records to display. Such a simple request that is way too complicated.

Excelent! tks very much!

What about countif using flow to count dropdown / or radio selections

hi Shane, i realy like this video, just that it does not work for mi, i put this formula: Count('vacation pool'.NAME) and it says that there's something wrong, even the name of the Colum is correct, i also add a table and put Count(NAME_Column1), and it doesn't work heather, do you know what could happened, if you help me ill follow and like, thanks for your time... ps it works with countrows

how to use a COUNTIF for checking Choice column Text...

I'm so tired of searching, Sort CountRows in the Gallery, please please please if you are reading and you know how to do it please reply,.

Hi Shane! Your timing is impeccable. I just hit the delegation wall of 2000 records using CountRows and CountIf in a PowerApp. I'm trying to use the Count/Filter process, but I'm having trouble. The PowerApp code I'm using is "CountRows(Filter(PARS, Status = "New")). PARS is the SP list name, Status is the column name, and New is the value I need to count. PowerApps doesn't like it. Can this be made to work with text fields? BTW, Status is a choice field in the SP list. Thanks! Lisa White

gRACIAS

...... Muito bom.

No Countif or Count functions make Homer something something.... ;)