ForAll and other Functions in Power Apps

[@jaddfigaro7246]

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

[@ShanesCows]

Glad to help you keep building those skills. It is a powerful function for sure. 😎

[@MichaelDeBlasis1369]

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

[@ShanesCows]

Happy to help. Have a great day. 🐶

[@michaelm8460]

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

[@ShanesCows]

Happy to help Michael! This is my fith favorite thing today. 😁 Maybe higher but have to stay on theme 😉

[@michaelm8460]

@@ShanesCows Copy. I🤜🤛 I am having an issue writing to lists. The so called datasource is typical a couple lists from combine. So when told to patch the data source. patching the combine lists doesnt update the field on its source list, but update the source lists, and it may not update the combined list until something else refreshes. This freaks out QA and the PM. So how should I insure the right field gets the right data from a combined datasouce with a min of overhead?

[@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.

[@ShanesCows]

Yeah As STUFF just removes all confusion. 😊

[@BenLinfordUK]

Lots of value packed into this video Shane - thanks!

[@ShanesCows]

Happy to help Ben. Have a great week!

[@scoozilife]

#4! Love the channel Shane!!

[@ShanesCows]

You are my fourth favorite. 😹

[@RicksterLuna]

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

[@ShanesCows]

Glad you enjoy it!

[@craigwhite5429]

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 :)

[@ShanesCows]

Yeah. ForAll with nested Patch, one of my favorite way to do things 😲, is so slow. Change was hard. I did talk about all of that in this video kzbin.info/www/bejne/pJzTaoCod62BY9U

[@craigwhite5429]

@@ShanesCows I thought you might have a video for it! I’ve probably watched it but defo add to the list for a refresher 💪

[@Glentp75]

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!

[@ShanesCows]

Not with the print function, but you could with a Print API :) kzbin.info/www/bejne/o2WppmyXm5ebZ8U

[@paolovr1970]

Thanks 😊

[@ShanesCows]

You're welcome!

[@whitneymeyer5546]

Is there any way to force a sequential patch order?

[@ealexander2488]

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

[@ShanesCows]

Something like ForAll(Table, Patch(...); SendEmailv2(...))

[@XuejiaoRen-lq2vg]

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

[@ShanesCows]

This talks about how to deal with the problem when it comes to Patch kzbin.info/www/bejne/pJzTaoCod62BY9U

[@keuleule]

you are just great

[@ShanesCows]

Thanks, that is very kind of you.😊

[@josecarlosbenitezmeyer645]

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, November||..... But even doing that I cant make to show only the correct column. Someone can help me please?

[@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

[@SriKrishnaVlogs143]

First comment shane 🎉

[@ShanesCows]

Thank you, thank you! Have a great day. 🐶

[@mudassirsyedrashidali9787]

Second comment Shane😁😁

[@ShanesCows]

Second Thank You 😎