PowerApps 'With' Function - Basic Introduction (Tutorial)

[@jeemeewong]

Got stuck w every other presenter except this one here. Awesome. I feel ready to talk about powerapps tmw then. Thanks so much!

[@jimfitch]

When I first heard of With function, I thought, “This is the LET function in Excel.” I love the LET function: it makes complex formulas easier to read & maintain; it can more efficient b/c it calculates the variable value once in the formula. I imagine the same would be true here? If our formula uses the same expression more than once in a formula (like, say, ListName.ColumnName.Value), then we can use With to calculate the value of that expression (once), store it in the variable, then feed the variable to the formula where that expression would be used. Good stuff! Thanks. Good explanation.

[@s1hl3]

Great addition to PowerApps

[@bobhoover1066]

Very clearly explained - thankyou.

[@DavesTechTips]

Thank you for the feedback Bob, glad you found it useful.

[@davidnourie6713]

Great variable video!!!

[@DavesTechTips]

Thank you so much for the feedback David! Tell your friends ;)

[@DavidGerard76]

Hey Dave, thanks for the great video. I'm just watching that now, at the time that Excel is coming up with something very similar with the LET () function.

[@DavesTechTips]

Thank you very much for the feedback David, much appreciated and it is great to know you found this useful. I wasn't aware of the Let function in Excel but will definitely check it out 👍🏆

[@NKBobcat]

With( { selAction: "Subscribed", selEmotion: "Liked" }, "I am " & selAction & "and I" & selEmotion & "this video" )

[@DavesTechTips]

Thank you so much for the feedback Bob. Looking forward to see what else you dish up 'WITH' the new function ;)

[@lesterknome]

it didnt work :/

[@lesterknome]

nvm i got it working now

[@DavesTechTips]

Cool lesterknome, glad you came right.