ForAll and other Functions in Power Apps

#powerapps #PowerPlatform #canvasapps

Dive into the world of Power Apps with this comprehensive tutorial on the 'ForAll' function. This video is a must-watch for anyone looking to master data manipulation and looping in Power Apps. You'll learn how to use 'ForAll' to iterate through tables, whether they're collections, data sources, or manually created tables. The tutorial covers practical examples like updating data sources in bulk, adding row numbers, and even comparing 'ForAll' with the 'AddColumns' function for different approaches to similar problems. Whether you're a beginner or an experienced Power Apps user, this video offers valuable insights and tips to enhance your app development skills.

Up your Power Apps Skills Today!

0:00 PowerApps For All
1:03 Add a button with the ForAll Function
4:45 Things you cannot do in ForAll
7:56 ForAll to upload multiple files
8:59 Adding row numbers
10:58 Returning a table from ForAll
14:45 Make a table of random numbers

Do you need some help with something that you are working on, contact us!

PowerApps911

Let's connect on social!

[jaddfigaro]

Never really took the time to learn forAll even if I used it in an important app for my team … but now wow😮
It will be my new best friend

[MichaelDeBlasis]

The force is strong with this video. Thanks again Shane. Nailed it. and more.

[dougydoe]

I really liked the AS STUFF bit which definitely makes things smoother and less cumbersome. I do use the ForAll but will now be adding the STUFF bit going forward. Thanks for sharing.

[BenLinfordUK]

Lots of value packed into this video Shane - thanks!

[michaelm]

5th Comment, you may see this😃
First, thanks, this cleared a few things up about forAll.
Since July I have used your videos as a primary learning source in building a Govt web site as part of their cloud migration initiative. A team member use your videos as well. ... So, you also have thanks from a grateful Nation

[RicksterLuna]

Love it as usual! thank you for bringing this up again with us.

[Glentp]

Great work! Is it possible to take each item in the ForAll and send each selected item to a print page to print each item individually like an order slip? Thanks in advance!

[craigwhite]

ForAll with nested Patch can be super slow, the more records you want to process. Patch with a nested ForAll is much faster for higher volumes of records :)

[ealexander]

Can you send an email for each record in a ForAll Patch? If so, where would you put it in the code?

[whitneymeyer]

Is there any way to force a sequential patch order?

[aneeshpc]

I have 3 lists, item, IN & OUT all lists have Item_code column common, I want to update the stock availablity in item list automatically while running my powerapps
Total sum of group by item_code IN list - Total sum of group by item_code OUT list

[josecarlosbenitezmeyer]

If I have a Sharepoint list where I have 12 colums for each month of the year with points in each column, is there a way to get the average of three columns, like if we're in April to get the points of January, February and March / 3, and so on and so on.
My biggest challenge is to make ir dynamic, I am currenly using the calculated columns of SPL, wich has gave another 12 columns where I store the values, like:
January, February, April || May, June, July || August, October,
But even doing that I cant make to show only the correct column.
Someone can help me please?

[XuejiaoRen-lqvg]

For all is very slow how can i make it faster ?