01-05-2020 20:42 PM - last edited 09-17-2020 09:44 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!
Very useful! Thanks a lot!
Amazing! This is very much appreciated.
I hope that there will be an additional update about camera , image and add picture control too!!!!
Kudos to @mdevaney !!!!
Yes you are right, it is not the same as Zip package import.
The technique here: How To Open .MSApp Files is the one which would work for files attached in this showcase that are .msapp
Made two bug fixes and re-uploaded the msapp
Ex4 - Add 2 Columns from another table
Ex13 - Get The Last Rows
Improved this pattern
Example 4 - Add 2 Columns from another table
Now it is called
Example 4 - Add All Columns from another table
This way as many columns as are in the other table will be added... not just 2.
how to create a variable within an application and have a selection field and a quantity field?
In this case, the total value below is the product of the item record selected by the user, at the value entered by the user.
It is not possible to assemble a variable that reads the selection data of the registered item.
Can you help me?