09-06-2020 01:42 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!
Thank you for your work. I learned how to convert data to a string in csv format with the Ex37 case. But I want to download a csv file down directly. I try to use the "Export" control, but the downloaded file is a zip file and the unzipped file is a json file set, which doesn't meet my requirements. I've tried other ways but it doesn't work, any suggestions?
I absolutely love your tuts, blog, and clear instructions. Saved me a lot of anguish. I am struggling with understanding how to import a msapp file into Power Apps environment and also into the MS Teams development environment which requires a zip extension. have googled it with no luck on both. I am on a Mac and do not have PA Studio but use the web based environment . Am I missing something or do something wrong as I want to look at your Collections App and learn more about them. Thanks in advance for any advice or help. Cheers Jeff
An msapp file can be imported by creating a new app, then going to the top menu and browsing to File > Open > Browse. Then you can select the file from your local drive.
If you like the Collections Cookbook please be sure to give it a Thumbs Up on the 1st page if you haven't already.
Hello Matt, thanks for the prompt response and support. Yes, will give a thumbs up, new to this, so will get onto to it asap.
I have got the msapp to import into the Power Apps web dev, as you suggested. Thanks heaps for that.
My issue is that you cannot do the same in the MS Teams App dev environment. Not sure why, but made a new app, and there is not "File - Open"
It also falls when I export form Power apps and then try to import into teams environment. Will keep trying, but the integration into teams is a bit clunky.
Got it...had to make up a new solution in Power Apps, then import apps into the new solution, then export solution with "Unmanaged" set, and then import the zip into MS teams. Finally...lol. all good.