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

[TheKermit]

Great vid Shane - love these baby step vids on breaking down functions using practical examples

[maripower-nhtz]

Hi Shane! Thank you very much for your videos and all your work :) You have been a great teacher.
I have been watching this several times because of the shuffle function.
On the min 5:49 you said you can run it again and again and again by deleting the parenthesis.

Can you do that using a button?
Reactivate the shuffle on the gallery ?

Best regards,

[oluwatobiyusuf]

Thank you for this awesome video. I learnt some new tricks around data manipulation

[wendymason]

Great video, thanks once again . I have a requirement for selecting the month and year only in a date, would you use a sequence for this and do you have a tutorial for this?

[geralddahl]

Thx for prompting me to think of using As in forAlls. I hope I remember the text and value trick that added 000 to the invoice, not sure why this works the way it does but thanks as always for pointing it out.

[poojashetty]

Hi Shane,
Do you have any idea how we can get more than 1000 rows of data in powerapp when using powerbi as a datasource?

[HollyIsBest]

Big fan Shaun! You have taught me so much, thank you. I’m trying to find out if currentuser can determine the output in one of my dropdown choice fields, though the data doesn’t have a connection. So if currentuser is me, Holly, I want the ‘Area’ dropdown to auto-fill with ‘TV Products’. Is this possible?

[cvkealey]

Great info! I just keep a bunch of lists in a SharePoint site for doing "proof-of-concept" type stuff in Power Apps, but your approach is much simpler (although not as accurate for testing delegation stuff).

[EE-kwcm]

Up to now I have been working with MS Access and know the possibilities to change data by e.g. queries. How does that work with model driven power apps? Which possibilities do I have there for mass changes ?

[BokyJ]

When I type Sequence(10, 10, 10) I got the numbers 10, 20, 30, 40, 50, 60, 70, 80, 90 and the last one is again 10. Can you tell me how can I format this to be a 100? Thanks in advance.

[alljomar]

@Shane Young. Good day can make a simple Rating app for the employer and the employee rate will store to share point. Hopefully you can make the app. thank you and god bless