In this video, you will learn how to use the PowerApps With Function. This makes for cleaner formulas and better performance. PowerApps Training www.PowerApps9...
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!!!
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!
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.
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
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.
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
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?
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.
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
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" } ) ) )
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.
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.
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.
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.
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.
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?
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.
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!
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
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 ?
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?
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...
