SharePains by Pieter Veenstra on MSN

CountRows, CountIf, CountA and Count in Power Apps

How often would you like to count the number of records without really wanting to load all the records that exist in a list ...
Cloudflare recently announced support for aggregations in R2 SQL, a new feature that lets developers run SQL queries on data ...
Nest CHOOSECOLS inside UNIQUE to extract non-adjacent columns, and use INDIRECT for interactive header dropdowns.