Power Apps Collections Examples

Imported reference from Matthew Devaney's blog for learning purposes. Original: https://www.matthewdevaney.com/powerapps-collections-cookbook/. Author: Matthew Devaney.

PowerApps Collections Cookbook

Welcome to the PowerApps “Collections Cookbook”.

Inside you will find over 50 examples of how to do various tasks with Collections. Each page contains code and a visual to show what the code is doing. My favorites are: add a row number , remove duplicate records , group by column and find the sum , and join two tables on a single column .

COPY + PASTE code from the cookbook into your own app.  Just change the Collection name and column names to match your own. Did You Like The Collections Cookbook? 😺

Subscribe to get new Power Apps articles sent directly to your inbox for FREE. Enter your email address Sign Me Up Basic Examples What Is A Collection? Create A Collection (manual) Create A Collection (from a datasource) Create A Single-Column Collection Insert A New Row Into A Collection

Insert Multiple New Rows Into A Collection Change The Values In A Row Selecting Collections Examples First Rows Of A Collection Last Rows Of A Collection Middle Rows Of A Collection

Get The First Row With A Matching Value (Lookup)

Get A Value From A Record (LookUp & Positional) Get A Column From A Collection Filter A Collection Filter A Collection With AND Condition Filter A Collection With OR Condition Ungroup A Table Stored Within A Cell Get A Value From A Table Within A Cell Get Collection Column Names Summarizing Collections Examples

Calculate the SUM, COUNT, AVERAGE, MAX, MIN Group By And SUM Values Group By And COUNT Values Group By And AVERAGE Values Group By And MAXIMUM Values Group By And MINIMUM Values Get The Rows With Top Values Get The Rows With Bottom Values

RANK Rows from Highest To Lowest With Ties COUNT The Unique Values In A Column Calculate The SUMPRODUCT Of Two Columns

Add A Column Showing Percentage Of Total Transforming Collections Examples

SORT a Collection By One Or More Columns JOIN One Column From Another Collection

JOIN All Columns From Another Collection SPLIT A Text Column By Delimiter MERGE Two Columns Into A Single Column REPLACE A Whole Row In A Collection REPLACE All Values In A Column

REPLACE Cells In A Collection With Blank Values ROUND The Values In A Column Randomly SHUFFLE The Order Of Rows

Fill Blanks In A Column With Last Non-Blank Value Add A ROW NUMBER Column To A Collection RENAME A Column From A Collection REMOVE A Row REMOVE All Rows REMOVE One Or More Columns REMOVE All Columns Except UNIQUE Values From A Collection Column

UNIQUE Values From A Collection Column With Blank At The Top UNIQUE Records From A Collection Matching Values Within 2 Collections Change The Date Format In A Collection

Stack Values From Multiple Columns In A Collection Exporting Collections Examples Export Collection To A Datasource Export Collection To A JSON Export Collection To A CSV Export Collection To HTML Table