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!
