Collections Cookbook: 50+ Visual Examples & Code

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.

COPY + PASTE code from the cookbook into your own app.  Just change the Collection name and column names to match your own.

Add the app to a Microsoft Teams tab for instant access.  I like to keep the Collections Cookbook close by while coding PowerApps.  That way I can quickly look for code to solve the problem I am having and the solutions are all in one place. 

Calls To Action

Give a Thumbs Up if you liked the app to make it easier for others to find in the gallery

Post a reply for any suggestions for Collections Examples you want to see added in a future version.

Send me a message for any bugs your encountered and I will try to fix them quickly

Follow me on Twitter for more PowerApps tips https://twitter.com/mattbdevaney 

Full List of Collections Examples

Basics
What Is A Collection?
Create A Collection
Create A Single Column Collection
Insert A New Row
Insert Multiple New Rows
Change The Value In A Cell

Selecting Data

First Rows Of A Collection
Last Rows Of A Collection
Middle Rows Of A Collection
Get A Column of Values
Get Row Using LookUp On A Unique Value
Get A Value In A Cell
Filter A Collection
Filter A Collection With AND Condition
Filter A Collection OR Condition
Ungroup A Table Within A Cell
Get A Value From A Table Within A Cell

Summarizing Data

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 10 Values
Get The Rows With Bottom 10 Values
Rank 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 Data

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 Delimeter
Merge Two Columns Into A Single Column
Replace A Whole Row
Replace All Values In A Column
Fill Records With Missing Values
Round The Values In A Column
Randomly Shuffle The Order Of A Collection
Fill Blanks In A Column With Last Non-Blank Value
Add A Row Number Column
Rename A Column
Remove A Row
Remove All Rows
Remove One Or More Columns
Remove All Columns Except
Remove The Duplicates From 1 Column
Remove The Duplicates From 2 Columns
Get The Matching Values Within 2 Collections
Change Date Format In A Column
Stack Value From Multiple Columns In A Single Column

Exporting Data

Export Collection To A Datasource
Export Collection To JSON
Export Collection To CSV
Export Collection To HTML Table

(Screenshot Of The Menu)

I wish you the best of luck in building your PowerApp!