PowerApps With Function

[@elizabethshort9632]

I discovered the With function and didn't really see the point after reading the documentation. I was really hoping there was a Shane video on it and here we are. Thank you as always

[@ShanesCows]

Awesome. It is one of my favorite functions. So helpful once you get the hang of it.

[@emmanuelmaceda2475]

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!!!

[@ShanesCows]

Fantastic!

[@Bekesam]

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

[@zero2herobeatspaul882]

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

[@ShanesCows]

Wonderful! Thanks for watching and putting up with me. 🐶

[@laelheasman3482]

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!

[@ShanesCows]

Thanks for the kind words! Means a lot to me. 🐶

[@andrewnunes8113]

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.

[@ShanesCows]

With is awesome! I use it a lot for performance optimization.

[@berggrog1]

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

[@ShanesCows]

Appreciate that. 😎 Have a great weekend 😎

[@lescolle4268]

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

[@ShanesCows]

Thanks. Enjoy learning 😎

[@webwatcher188]

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.

[@ShanesCows]

Thanks John :)

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

[@ShanesCows]

Yeah this function is cool

[@AdamHaas]

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

[@ShanesCows]

IsBlank(record) should work but I always like to be specific. In some serious you make record something like Defaults(Datasouce) which isn't actually blank but record.ID would be. So habit I always choose a primary field.

[@terrisepulveda627]

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

[@ShanesCows]

Glad you like it.

[@edakarajillo]

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

[@ShanesCows]

Not yet, their goal is to bring Power FX (the formula language where With lives) but they haven't yet.

[@stephendarier1390]

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

[@ShanesCows]

Thanks :)

[@anats3008]

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?

[@ShanesCows]

Sadly they are 2 different languages. Power Apps - Power Automate Concatenate - Concat 1+1 - Add(1,1) 1-1 - Sub(1,1) 1/1 - Div(1,1) Value - Int Text(Now(), "MM") = formdatetime stuff Month(Now()) would also just return 3 directly. Those are off the top of my head but should be close.

[@bradlystewart1156]

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

[@ShanesCows]

Bradley leave a new comment with an example of a complex calc you are challenged by and I will see what I can do.

[@altino91255268]

Hi Shane, great video! Could you talk more about the With function?

[@ShanesCows]

I love the With function. What else would you like to see covered with it? I open to ideas.

[@altino91255268]

@@ShanesCows We could try to use this function together with an AddColumns column or even with a gallery

[@syedhussain6393]

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.

[@ShanesCows]

Just different way to do the same thing. If you need the value somewhere else then use a variable. IF you just need it for that one call then With is more effecient.

[@canasman11]

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

[@ShanesCows]

Thanks

[@philipmarno4989]

Great video, has really helped me rethink good code structure. I’ll be working “With” this for sure.

[@ShanesCows]

I love this function! ❤️

[@juanpablohernandezorozco7796]

Thank you very much shane you are the best, with this function it is possible to create a "FOR" loop and be able to use variables with the following syntax ForAll( Sequence(10), With( {Chewys: ThisRecord.Value}, Collect( Table_Dogs, { ID_Dog: Chewys, Name: "Chewy" } ) ) )

[@vishaljhaveri7565]

For loop!

[@priyanit]

Hi Shane, Trying to insert data into existing row in SP list with the following onSelect Functions: UpdateIf( CyAt, Title = User().FullName && Text(varDT, ShortDate) = Text(DateOfEntry, ShortDate), { 'Work Location': Dropdown1.Selected, DST: Now(), Scoord: Label3.Text, status: "In" }); Please tell where and why does it fail to add any data.

[@ShanesCows]

That updates existing rows. You want to use Patch to add a new row. This should help kzbin.info/www/bejne/g5TPe5KFbq2pgLM

[@csandford2]

Hi, Is there a way to update a data table depending on what is selected in multiple drop down menus? I have it so that all 3 have to be selected, where as i need it that 1, 2 or 3 could be selected. Great content BTW!

[@ShanesCows]

Yes it is possible with lots of If but more that I can post here. Sorry

[@rajum5453]

can we use Isblank(record) insteadof Isblank(record.Id) in the if condition..pls clarify...

[@ShanesCows]

I don't see why not.

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

[@ShanesCows]

Probably not. You will have to log on periodically but to be fair I have not tried.

[@bryancampbell8942]

Came across something use WITH, it seems it cannot return a blank or "" value. Seems like a major limitation? I'm using With in the default property of a text box and it shows "false" when it should be empty, this creates a real problem.

[@ShanesCows]

Interesting can you email me how to recreate and I will look into it. Shane at PowerApps911.com

[@karlnixon5606]

Thanks Shane, are you able to use the with() variable in formatting the Fill property of the same item? ie in your example if the Dog is Chewie set the fill property to Red ?

[@ShanesCows]

Yes, as long as you return a color Power Apps doesn’t care how you get it

[@SegioVillalta]

Great video as always. Thank you Shane 🤘

[@ShanesCows]

Glad to help. 😀

[@anantnd393]

Can you make a video to show us how to integrate Azure Functions with PowerApps? Including the part where we will need to make a swagger JSON

[@ShanesCows]

Maybe one day. We did cover that in my Advanced Power Apps class. training.powerapps911.com/courses/advanced-power-apps-and-power-automate Pretty deep stuff.

[@luca-rw7ss]

Very useful man! ;) thank you!

[@ShanesCows]

Glad to help. 😀 It is one of my favorite functions!

[@LPadillaCR]

Dear Shane... Just another super hit video! Thanks! Quick question. How can I make a contacts app collect data offline for later update it once it gains connection again?

[@ShanesCows]

I need to make a video on offline. 😑

[@LPadillaCR]

@@ShanesCows No one better than you to go for that task!!

[@ryanbond8022]

@@ShanesCows Yes please!

[@kiranboligarla5057]

Shane, Did you do a video to built milestone charts in powerapps.

[@ShanesCows]

I didn’t. Sorry.

[@kiranboligarla5057]

Thanks Shane. I tried to build it in power BI and able to integrate in power apps screen.

[@hailm03]

Thank Shane! It's what i looking for

[@ShanesCows]

Awesome. This is one of my favorite functions!

[@javierzorromorales4333]

Thank you Shane, In the future are you going to work with a model?

[@ShanesCows]

Yes. Soon I hope. Soon.

[@pkp044]

Thank you so much Shane❤

[@ShanesCows]

Happy to help :)

[@StephanOnisick]

Great Examples!

[@ShanesCows]

Thanks! 😃 I love With

[@jray1429]

This is Awesome!! 😎

[@ShanesCows]

Thanks! 😁

[@muthuperumalkonar4874]

How to browse excel file and insert VBA module and run it in powerapps?

[@vishaljhaveri7565]

Difference between using UpdateContext vs With function in Power Apps? (performance)

[@ShanesCows]

Performance is probably similiar with With being slightly less impactful. Why make a variable if you only need the info in one place. :)

[@iamnotcool42]

Thanks man. your videos are really helpful

[@ShanesCows]

Glad to help. 😀

[@K6TJO]

Great tips Shane thanks!!

[@ShanesCows]

You are welcome

[@petrinnn]

Shane, Is it possible to use this With Function in another button? For example, i have this code.. that i have to use in a lot buttons.. ForAll(Filter(arrusuarios;varNovo="NOVO");Patch('ATAS - Possíveis Usuários';Defaults('ATAS - Possíveis Usuários'); {Nome:Nome;Empresa:Empresa;Telefone:Telefone;Email:Email; EditarUsuario:EditarUsuario; varNovo:"FOI"}));; I dont want to write the same code in ALL buttons.. i would like to call this function like... all my code are a function called SEND_OFFLINE... and just to use SEND_OFFLINE in my buttons?

[@ShanesCows]

Nope. 😑 You will have to copy the code around. Sorry.

[@petrinnn]

@@ShanesCows Thank you!!

[@TioXpi]

Shane for President!

[@ShanesCows]

Love it! 👑

[@jeanpierreragequit1726]

Thx u so much Shane !

[@accmahmoud84]

In the gallery I have: A field for a vessel name A field for the cost I want to lookup the cost from a data source based on the vessel name Lookup(name of the table where the cost is stored, name of vessel name in the data source=name of the gallery.Selected.name of the field of the vessel name). Name of the column of the cost When I apply the above I get blank

[@Radioguy00]

Very good!

[@ShanesCows]

Glad to help. 😀

[@Magayshibeo]

Great!!!

[@ShanesCows]

Thanks

[@bootsbax]

thanks Shane

[@ShanesCows]

Happy to help

[@ayoubtourabi6836]

👏🏻👏🏻👏🏻👏🏻👏🏻

[@ShanesCows]

😎

[@kal9001]

Trying to be respectful here, but isn't powerapps generally a bit stupid?!... It seems like a lot of things could be done so much easier by getting rid of the WYSIWYG and get a scripting editor up where you can make proper variables and change stuff how you like...