CountRows, CountIf, CountA and Count in Power Apps
The article explores four primary count functions available in Microsoft Power Apps: CountRows, CountIf, CountA, and Count. These functions allow users to retrieve counts of records within various data sources without necessarily loading all records, which is ideal when dealing with large lists or tables. Each function has specific use cases, such as CountRows for total record counts, CountIf for conditional criteria, CountA for non-blank text field values, and Count for numerical records. The effectiveness and limitations of these functions are demonstrated using SharePoint and Dataverse as examples, highlighting how delegation affects results and the potential need for workarounds. While CountIf is particularly effective in Dataverse, achieving higher record counts may require alternative approaches like Power Automate or collections, especially with large datasets.
Article 2w
Login now to access my digest by 365.Training
Learn how my digest works
Features
- Articles, blogs, podcasts, training, and videos
- Quick read TL;DRs for each item
- Advanced filtering to prioritize what you care about
- Quick views to isolate what you are looking for right now
- Save your favorite items
- Share your favorites
- Snooze items you want to revisit when you have more time