01-09-2020 00:51 AM
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
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
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
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
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
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!
Awesome, this is a great collection of info 😹
Thanks so much for sharing, I've just imported it into my environment as a reference for me to use 😺💜
I've sent you a bunch of corrections too 🙀
Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!
Thanks for helping me out with the bug fixes @iAm_ManCat.
I've made the following adjustments to the app:
Ex00 - Collections can have up to 2,000 rows if you increase the delegation limit
Ex3 - ProductName is now showing the correct product
Ex4 - ProductName is now showing the correct product
Ex12 - Solution 12b is now showing 3 rows
Ex14 - Changed Title To Top 3 Values
Ex15 - Changed Title To Bottom 3 Values
Ex20 - Fixed Date Formmtting Issue
Really helpfull, thanks for all the content!
@mdevaney thanks so much for the share. I will definitely be picking up some great tips for my apps ... I already have!
Just for anyone, like me, who struggled a little to download and open this app, I followed along with this solution:
Since then, I've setup a shortcut to the PowerApps Studio, which I didn't have before 🙂
Love it! One of those page turners that just keeps giving 😀