Power Apps Data Functions - Manipulate and create sample data quickly

Learn to use your Power Apps Data Functions like Sequence, Shuffle, AddColumns, First, Nested ForAlls, and Nested Galleries to quickly manipulate data. This isn't a video about do these steps in your app, more a video on things you need to know and understand to be better and faster at building Power Apps in general.

0:00 It Starts
1:25 Look at the Power Apps data we are going to create
2:10 Use a Power Apps Gallery and Sequence function to make a table of numbers
3:35 AddColumn function to create a department column by pulling from a Shuffle Table with First function
6:07 Create an Invoice Number by Adding a column and concatenating a string, then dividing, and the Power Apps Text function
8:23 Create an Invoice Date by using the DateAdd function and Today()
9:36 A deep dive into the Power Apps Mod function
12:10 Put your dynamic data into a collection with the Power Apps ClearCollect function
12:53 Use the GroupBy function and a Nested Power Apps Gallery to group the invoice by a department
15:53 Create a gallery and create a collection of employees using Nested ForAll functions in PowerApps
20:28 Create a cascading filter to show employees associated with the selected department

Power Apps Consulting and training at https://www.PowerApps911.com