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.

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