PowerApps With Function

In this video, you will learn how to use the PowerApps With Function. This makes for cleaner formulas and better performance.

[Bekesam]

It's been a struggle getting my mind wrapped around the With function, till I came across your video, thank you!!!

[emmanuelmaceda]

Yesterday, I made a comment in your other video about using a variable to sort columns in a gallery and getting a delegation warning. I used the WITH function you showed above and it now works!!! Thank you so much!!!

[zeroherobeatspaul]

On a Shane Young marathon right now in January 2021, improving my PowerApps skills. Thank you for your teaching and your energy!

[lescolle]

Excellent training ... I'm an IT guy just starting inside PowerApps and your training is super .. plenty of reasosn ... for sure because super easy to understand even for the Frenchie I'm but also because show at the same time a simple but also rich example

[andrewnunes]

Wow, they're like Pivoting variables! Because the definitions pivot at the beginning of the code, and that bit never needs to change. This is even better than components.

[laelheasman]

Hi Shane. I have watched so many of your videos and learnt such an incredible amount from you. I watched this video last week, and have found opportunity to use "With" multiple times daily since. It is such an incredibly useful function, and is cleaning up my code all over the place. You are an amazing teacher, and I just wanted to give you huge thanks for all you do for us citizen developers. Keep up the sterling work!

[webwatcher]

Shane, thank you so much for this wonderful lecture on how to use With function. I am building a gallery which, on each line item, needs to join (LookUp on IDs) couple other SQL tables to get text names. Using With function hugely improved the gallery performance. Your examples are great and actually cover one of my cases. I really appreciate your teaching.

[AndreasMake]

As usual. Grateful for you making my life easier. Potentially help keeping my variables down to a minimum outside of the with function. Thanks Shane!

[berggrog]

You don't get enough feedback man. Thank you. Was trying to do some ForALL With & Patch Magic loading for example a collection or tasks, Then using forall patch to Assign Users to that task and then of course patching Checklist Items back to the first Task Item. Getting a delegation warning something like "A One to Many or Many to Many is being referenced in this functions record scope...." Crypes... well this started me on the right route. Thanks Shane. Hope all is going well

[terrisepulveda]

Gradz on the growth of the number of viewers for your training! And as always, great content. I see myself referencing this many times!

[stephendarier]

Hi Shane it's so awesome I surch something I'm struggling with and your videos pop love it man keep them coming.

[edakarajillo]

Could I use this kind of functions in a model-data driven apps? Or even in power pages?

[anats]

Thanks Shane! I've learned PowerApps using your videos. Very useful!
I'm still struggling to find the match functions between flow and PowerApps. For some reason these functions have different names in flow and PowerApps.
Example: In flow this formula works: concat('Q', add(div(sub(int(formatDateTime(utcNow(), 'MM')), 1), 3), 1))
but in PowerApps it doesn't.
Any trick how to find those names?

[hailm]

Thank Shane! It's what i looking for

[syedhussain]

when you used "With" function with "Lookup" function. Why did you not store lookup returned row in variable because in "With" function we save values in variables.

[AdamHaas]

14:00 In the IF statement, do you need to reference the ID? Or can you just reference the record with IsBlank(record) ?

[canasman]

This is awesome Shane. This is gonna be so useful when writting this kind of code now. Keep up the great work!!

[bradlystewart]

Hey Shane,

I know this video was along time ago but came i came in a little late lol.

If you were to do a video on complex calculations I’ve been having a few issues. My company deals with steel pipe so the prices and weight calcs can get pretty crazy. I think the “with” function is the answer tho

[SegioVillalta]

Great video as always. Thank you Shane 🤘

[dfheiland]

A little off topic, but would it be possible to use PowerApps as a digital signage. Let an app run 24/7 and push some info out to a screen?