Intro to PowerApps Variables

[@i10haulin]

Shane, this is the first video I have watched of yours and I have immediately subscribed. You rock man. I am soo eager to use and learn PowerApps and can't thank you enough for your videos. I hope you continue to make more. I'm going to watch the rest of your videos. Thanks.

[@ShanesCows]

Thank you for the kind words. Please let me know suggestions for future topics.

[@adamstathakis1128]

@Shane your videos are more helpful than all the MS documentation combined - thank you for doing such great work and making it available for everybody instead of putting up a paywall.. you rock Bro!

[@ShanesCows]

Thanks Adam. You kind of made me blush. :) Have a great weekend!

[@CuriousJo1122]

Gosh, I love you, Shane!!! Thank you for demystifying certain things for me around Power Apps!

[@ShanesCows]

You are welcome 🤗 Have a good day!

[@JL-eq7mg]

Shane, thank you! I've learned so much from watching your videos. You make things easy to understand and straight to the point. Thanks again

[@ShanesCows]

Glad to help Javier.

[@sukeshkumar7055]

Hi Shane, Thanks for helping in transforming my career into Powerapps. Do continue uploading the videos.

[@ShanesCows]

Awesome. Almost 100 😎

[@Richkotite1]

Thank you for your videos. They are amazingly helpful, you have taken me from beginner to intermediate. THANKS SO MUCH.

[@ShanesCows]

Great to hear! Keep up the learning and you will be a pro in no time.

[@jasonluckey2214]

Just found this. I appreciate the straightforward explanation. Thanks

[@ShanesCows]

Glad to help. 😀 there is a newer version also. Power Apps Variables: Global vs. Context and what you need to know kzbin.info/www/bejne/o3TNYotsgLeMm9k

[@maddiejacks5910]

Thank you for such a well-structured and informative video. Huge help for learning PowerApps as a non-developer!

[@ShanesCows]

Glad to help. 😀

[@vishalnagda7]

Hi Shandler (Chandler from friends [you reminds me of him]), you are a great man. I love you. Your work really needs to be appreciated and I wish Microsoft recognised it and make you there official trainer. and also wishing that they should show your channel videos on there learning portal. Thank you

[@ShanesCows]

Very kind of you Vishal :)

[@geetha1950]

Hi Shane ,this is the first video I have watched of yours. Thank you sharing knowledge

[@ShanesCows]

Glad it was helpful! I have over 200 more to help you keep learning. :)

[@nwankwoifesinachi4424]

Welldone shane....I wish i can get a tutorial video on Variable iteration...where a stock values changes based on the request made or the stock up done

[@ShanesCows]

Set(varCounter, varCounter + 1) Would increment the variable by one. Is that the concept you are looking for?

[@Paxofrouken]

Hi Shane! Great video, very helpful. My suggestion for a future topic: Take a picture from a powerapp and store it in a sharepoint list. Or get GPS information and show it on a map somehow :-) That would be awesome :-)

[@IQBooks-pub]

Shane, I may want a global variable x, and default it to 10 at the start of the application or at the form load of a specific form (without pressing a button). Your video doesn't show how to do this simple thing. Great videos so far I am learning alot. Thank you!

[@ShanesCows]

Use App OnStart to set a variable when the app opens. You can also put a formula on each Screen's property OnVisible. That should help.

[@rodmiddleton8268]

Very helpful information but have another question about variables, sequence etc. I want to lookup an employee id # based on current user email. I would like to store this and use it for filtering galleries etc. Doesn't seem to work. The way I work around it now is to have a gallery on a hidden screen filtered to the user().email. Works but seems clumsy and I think slows down the app. When are vairables populated and when can they be used? Thanks again for educating me on PowerApps!

[@ShanesCows]

Try setting the variable in OnStart for the app

[@stevenantinozzi3]

Hi Shane, awesome show on this one, was able to immediatly duplicate this process on the first try!!!!

[@ShanesCows]

Glad to help. 😀

[@altino91255268]

Congratulations on the video !! You understand a lot !! Don't stop making videos

[@ShanesCows]

Thank you! 😃

[@chankosol]

Hi Shane Young, Thanks for sharing, can you help me to fix this issue, I have customer form and Staff for entering data and now I'm trying to create a "Chat Form" for entering chat information but when I click on button go to "Chat" I want to bring "Cuustomer Name" and "Staff Name" to Chat Form, the result only Staff Name load on FormMode.New, but the "Customer Name" not Load. my formula : "Customr Card" on "Chat Form": If(ChatForm.Mode = FormMode.New,varCusName, ThisItem. 'Staff Name Ref') -Not work "Staff Name" on "Chat Form" : If(ChatForm.Mode = FormMode.New,varStaffName, ThisItem. 'Staff Name Ref') -Work

[@peanuttv6748]

Hi please can you give also your video Link about the Collection Variable? .. I'am learning from scratch. Looking forward.

[@ShanesCows]

This is the first on collection kzbin.info/www/bejne/r4SZnoeIodKootU

[@NayanRingane]

Immediately subscribed after watching this video. Video provided the info which is helpful to me. Thanks

[@ShanesCows]

Thanks

[@adriancelis9691]

Thank you Shane. Good tutorial especially that exclamation mark for the toggle button. ❗

[@ShanesCows]

Awesome. Glad it helped.

[@fjvaldes]

You rock! it took me 2 hours to find your video... but you save me two hours so im even haha... good info bro!

[@bennysamuelraj308]

Hi Shane, your video's are very useful and subscribed it as well. I have a quick question, can i use multiple conditions in a single text box events for example, i have 3 input box 'A' + 'B' = 'C', in 'C', i have written A+B also i want to check if C < 0 fill with Red else Green How should do this?

[@ShanesCows]

And between each evaluation

[@shinshae7882]

Hi Shane, I have set one global variable called varStatus on the approve button click (variable value will be approved) And I assigned that value to status field (textbox default property). When I am clicking approve button it is reflecting in status field, and I published it to SharePoint site. But when I submit the form and approved it , form status field is empty. But the SharePoint list is showing correct value

[@verdijason11]

Shane do you have any videos related to -- If(variable = true, then change SP field value) ?

[@ShanesCows]

I think this one kzbin.info/www/bejne/f6fEoXypd8eAY7c

[@verdijason11]

​@@ShanesCows Hey Shane, Thanks for the response. Unfortunately, I'm not finding the solution here. Hoping you can help - This is for a custom SharePoint form. I can't get patch correct either, but the goal is when user selects (OnSelect of Submit) button in form, it updates a SharePoint choice field on submit / OnSave - Any ideas?

[@6himanshusharma]

Hi, Please let me know. how can I export CSV on desktop? And unable to use variable on showcolumns function. There are two issue. Kindly support.

[@ShanesCows]

kzbin.info/www/bejne/n57Lqaxph6qajsU

[@sheosanjaykumarsingh7440]

On the fill of screen i had to use --->If(cow = true,Color.Red,Color.Green) , it was showing error when I was just entering Red instead of Color.Red. Thanks a lot, your video is very helpful.

[@ShanesCows]

Interesting you had to use the full name. Glad you got it.

[@sheosanjaykumarsingh7440]

I like your teaching. Please teach on multiple check boxes, and camera click to attach pics using PowerApps

[@joshualee9768]

Shane you should make videos for model-driven powerapps, and triggering flows within that app. For example a shipment request model-driven app that triggers a MS Flow for approvals. Thanks again for your videos.

[@ShanesCows]

I need to do more Model Driven for sure. One day, one day.

[@kevinbriz17]

These are some great videos Shane, really helping me right now as my workplace joins the 21st Century. I have a question on Filtering that I can't find a solution for. Is it possible to use a global variable directly in a Filter formula as a replacement for the column heading in an excel table? I've tried and failed. I have an excel table (a star chart) with 16 columns B1, B2, B3... to B16, each column has about 200 rows of with just a"x" in cells as required. Each row is relative to a particular maintenance task. I would like to apply a filter on one chosen column so the Gallery only shows the required maintenance activity rows. In my App, I have 16 buttons (B1 to B16), when a button is pressed it sets a GlobalVariable to Bx. However, using the syntax: Filter(Table,GlobalVariable = "x") I don't get any errors just a blank Gallery. If anyone else knows, please help.

[@ShanesCows]

Nope. You need to write different ifs to replace the column based on the variable

[@eschrader]

11:25 I owe you a beer (or beverage of your choice under $20) for this one. Offer valid for next 3 years.

[@ShanesCows]

Hope I get a chance to take you up on the offer

[@vishaljhaveri7565]

Thank you so much sir. Nice explanation on the topic of variables, and its types (contextual, global and collections.)

[@wookawsh]

Shane, Terrific Video. So helpful!!! I noticed that you used a colon “:” for a CONTEXTUAL variable the UpdateContext seems to be a different syntax to set the value - UpdateContext({CV: CalVal}), but an equal “=“ for a global variable SET(Cow, True) There are also no brackets. Is this typical?

[@ShanesCows]

Yes. Variables are a bit weird.

[@MrAbueslam]

What a great work you do. Can you do a video on reporting system for business as it includes incident report and automate approval process with look up on scertain categories to where this report belong to for solutions. THanks you work is much appreciated.

[@nannairu]

Hi Shane, thank you very much for all video you've produced. Really interesting. One question: how could I show as text in a label the name of a button whenever I click on it? Is it a property available for an object that can get the name? Many thanks again.

[@ShanesCows]

Set the name of the button to a variable when it is pressed. Show the variable in a label.

[@nannairu]

@@ShanesCows Hi Shane. Thank you. I don't know how to set the name of the button to a variable. All the rest for me it's clear.

[@fatemahalsubaiei5649]

This is so weird. I do not know why do I have to use buttons or any other action-taking control in order to be able to use variables. I want to save the lat/lon in a variable and compare it with my current location. how can I do so without doing it manually with buttons that is if my location keeps changing the new location gets updated in the variable???? I hope i can find an answer

[@ShanesCows]

You could have the OnVisible property of the screen set the variable. Or a timer.

[@learningperson8105]

Hey Shane, That's good video for understanding variable in Power Apps. I want to create dynamic variable name not value. Is it possible? Ex: Something like that. in UpdateContext as well as Set UpdateContext({var&Gallery1.Selected.Title : Gallery1.Selected.Title}) or UpdateContext({var+Thisitem.Title: Gallery1.Selected.Title}) Thanks

[@ShanesCows]

Not possible. :( SOrry

[@learningperson8105]

@@ShanesCows Thanks for your response :)

[@kimsalas8197]

Hey, Shane. How about doing a video on the Microsoft Translator Connector? I’m working on an employee recognition app based on points earned and redeemed. I’d like for our Spanish speaking employees to read comments that originated in English by the sender to be received in the target language of Spanish when emailed. Is that possible to do a video on that?

[@ShanesCows]

Interesting. I have never messed with it. Are you on Twitter? I might see if anyone out there has thoughts before I dive in too deep.

[@kimsalas8197]

Shane Young No, I’m not on Twitter. Sorry.

[@healthsys2551]

Very good intro to variables. Thanks!

[@jennifervitug1494]

I love your videos and especially the one for Consent Form with PenInput and sending email from PowerApps (which I used to do with a buttone the calls a FLOW) Can you maybe create a video that sends the whole Consent Form with the attached Signature (from PenInput) as an attachment (e.g. as pdf ) Or which just SAVES the Consent Form with signature as a PDF form ? More Power to you Shane :) Thanks in advance

[@ShanesCows]

How Jennifer. Glad the videos are helping. 😀 I have some open requests to the product team for some of this functionality. Not possible today. 😑

[@brentclemmer]

Question for Shane or others. I am altering a sharepoint entry form and changing the control type to a drop down list. When I do this I get red X's in various places but one that is consistent is the update field. Seems to lose its mind on where to save the data. When i publish the form and use it the data i select in those fields dont save in the sharepoint list. Haven't figured out what im doing wrong, been working on it for days. Please help.

[@ShanesCows]

I have a bunch of SharePoint videos. I think I show this technique in SharePoint Lookup video.

[@Guycjohnsen]

I've stored a changed order record to varChangeRecord. On my attachments screen, I use a form to add documents, and then I patch those documents I've added to the list and then the varChangeRecord. I was trying to control how I could then remove the documents so I'm using another form in edit mode to display the documents added from the other "add form". However, whenever I patch a document to the varChangeRecord, the recently added document won't immediately show up on the edit form unless I go back to the original gallery and click the ">" icon to again access that varChangeRecord. How do I fix this?

[@jones-geekzone4363]

Hello Shane, again a great short introduction tutorial. What I however don't really get is why you would use the UpdateContext formula instead of the Set formula. Isn't it easier the just use the global variable all the time? Thank you for sharing and keep up the great work.

[@TrainExplore]

No, that is not the case. Scope is important while working with variables, as mentioned, u might want to store the state of the variable and use it in future, like a storage where u can utilise the state of that variable at later point of time.

[@matthewpinholster7688]

I have a Sharepoint list that has a cell with CAT:DOG I am trying to generate a flow email where if i type in DOG that any cell with DOG in it will pull that entire row from sharepoint and create a table in an email. Do you have a video that has an example like that?

[@DataSpinners]

Super vid Shane. I didn't know about Global variables, so I ended up inventing my own way of creating them by using a one row one column collection and referencing that. It works but the code and experience is terrible though!

[@ShanesCows]

Glad I could help. That is half the fun of PowerApps though, creative solutions like yours. Kudos!

[@BeckyGribble]

Hey Shane. I have quite a big app and want to add a "report bug" button to my pages. Is there a way to get all the variables that are on that page and their value at the time of clicking the button? Thanks!!

[@ShanesCows]

Yes. You have them already. put them in the body of the email and you are all set. 😀

[@BeckyGribble]

@@ShanesCows oh ok, so I'm passing the variables through flow, and I wanted to avoid initialising all 25+ variables. I was hoping there was a quick way to grab them all in one command or something! Thanks for the reply :)

[@dmytrokovach5059]

Great video!!! Shane, could you show how to generate a unique name for the new photo. If the app will use several people it`s possible than some of them use existed name, and then the new item does not be created but rewrites the item with the same name.

[@ShanesCows]

Use the GUID() function

[@juan07241981]

Maestro,,, felicitaciones, es un excelente vídeo,, gracias y que te vaya super bien

[@ShanesCows]

De nada 👍

[@koutlaw30]

Shane, How do you send more than 1 variable to another screen?

[@ShanesCows]

Use Set and create global variables

[@jenniferchilds7568]

Hi Shane. Thank you for taking the time to make all these videos. Is there a way to print and/or export all the coding to be able to QC? I have a pretty extensive app I created (and you deserve all the credit for my ability to have done so) but I had to change where the information was pulling from on one of the lookups. Because it is used in a lot of different places, I'm having a hard time making sure I have caught them all. Is there an easy way to just look over all the coding? Thanks.

[@ShanesCows]

There is not Jennifer. Sorry

[@dustinrocksvold8650]

@@ShanesCows Could she have stored the lookup location in a variable on app start and then referenced that variable in the other locations? I seem to recall seeing one of your other videos using this technique and that you only had to update in one location...

[@estherlopeznavarro6100]

Shane, how does the variables work with date field? I have a form and can see a way to pass a date to the next screen, because once this date is selected and pass to the list it will be filtered out, so i need for it to be a variable. I cannot have to buttons either, so i have use the date dropdown onselect for that.

[@ShanesCows]

DatePicker.SelectedDate can be called from the second screen.

[@206010613]

Hi Shane, I want to display the current ID of my SP list on a TextBox or label every-time a new Item is created

[@Worrelpa]

Really useful stuff there Shane. Keep it going...

[@fabfreesoli4844]

Nice Shane, This it the best video tutorial ever.. I learn how to use powerapps with you... i have only a question, do you ever made a tutorial about SQL in Powerapps? Did you ever make a procedure or somethings on Powerapps with connection SQL?

[@ShanesCows]

Start here kzbin.info/www/bejne/eYCZqZmYn9OMrcU

[@miguellito25]

Hi Shane, Thanks for your videos! How could i change the language from spanish to english inside poweapps? I dont know but some commands and syntax are different in spanish! Yesterday when i was trying to make a context variable following your instructions,powerapps notified me an error! Numero de argumentos no válido! (Invalid number of arguments). It happened when i create this variable context: Navigate({CalVal: CalculatedCells.Text})

[@ShanesCows]

Try this instead: UpdateContext({CalVal: CalculatedCells.Text})

[@miguellito25]

Shane it works!! Thanks! I'm watching your video again, and it was my fault because I confused Navigate and Updatecontext. I feel a little bit stupid lol ;)

[@chaitanyachavan9411]

Shane, do you have a video on combobox control? I cannot find anything concrete related to combo box. The documentation is also vague. By any chance if you have missed combo box video, can you make one? would be of so much help. Thanks.

[@ShanesCows]

It is on my list to cover.

[@miguellito25]

I have changed the language inside my settings in my office account to english langaguage, but everytime i use powerapps the default language is spanish!! Its much easier for me to work and to program always in english! But microsoft changed the commands in most office apps for spanish commands and syntax!

[@ShanesCows]

Sorry, if I get the chance to share that feedback I will.

[@piusjoseph3192]

Hi Shane, I tried to replicate the solutions in the video and it's flagging me, it state the value of text imput cannot be converted into numbers Any help ??

[@ShanesCows]

Set(varNumber, Value(TextInput1.Text))

[@piusjoseph3192]

@@ShanesCows wow THANKS done 👍

Hi I need the dummiest thing EVER . got a dropdown with some values, so I have a "goto" button, I need the button to go to a screen with the name selected on the dropdown. I cant get it working Thanks for anyhelp.

[@ShanesCows]

OnChange for the Dropdown If(Self.Selected.Value = "Red", Navigate(RedScreen), Navigate(BlueScreen)) SOmething like that should get you close.

@@ShanesCows Thanks a lot!!!

[@Jean-kc5zx]

Great Video. Excited to watch the rest.

[@ShanesCows]

PowerApps is awesome. 😎

[@alexintel8029]

Great video and thanks for tip on reference vs Text value. Is there a way to navigate from one page to another based on a contextual variable? e.g. OnSelect = Navigate( {myFormName}, ScreenTransition.Fade)

[@ShanesCows]

Great question. I had never tried but turns out yes. I made a button and set OnSelect to UpdateContext({GoToScreen: Screen1}) I made a second button and set OnSelect to Navigate(GoToScreen,ScreenTransition.Cover) Give it a try and let me know how it goes for you.

[@alexintel8029]

Fabulous, it works. Thank you Shane.

[@ShanesCows]

Cool. Thank you for the update!

[@shefalikalia8662]

Hey Shane thanks for the videos. Do you know how can I add a Hyperlink inside HTML text that will go to my second screen since there is no separate webURL for different screens. Appreciate your response in advance.

[@ShanesCows]

You need PowerApps Deep Linking powerapps.microsoft.com/en-us/blog/powerapps-deep-linking/

[@sayaligaikwad8144]

in the label when I type & I cannot find that variable what to do? it's giving error

[@ShanesCows]

Make sure you Set the variable.

[@sarbeshkumarsingh1328]

Hello Sir, I developing an app in this I want to select checkbox from one from and dynamic button on other form equals to selected no of checkbox help in this senario

[@davenadine9719]

Great video. I'm new user of PowerApps!

[@ShanesCows]

Welcome aboard! Lots of videos here to help. I also have a free getting started class training.powerapps911.com/courses/power-apps-and-power-automate-getting-started that you might like.

[@sconsalter]

Very nice as always! Thanks again

[@ShanesCows]

Glad to help. 😀

[@tnorman3329]

Great video Shane! I learned a lot!

[@ShanesCows]

Awesome 😎

[@pixelb0i255]

@Shane I am having a hard time setting a variable on a button based on a column in my SharePoint list. Here is the syntax which is not working User().Email = LookUp(SPDataSource, CreatorInformation). any help is much appreciated.

[@ShanesCows]

Set(variablename, lookup(datasource, creatorinfo=user().email))

[@dustinrocksvold8650]

Shane, thanks for the awesome videos! They have been a big help in my journey so far. I have an app I am working on for inspections. There is one field for "deficiencies noted" that I wanted to set to a calculated value based on the questions on the various pages in the app. If any of the items are marked as deficient I need this calculation to show true. So I set a global boolean variable to false. My question is how do I change the value of the boolean variable? Do I do that with massive if statement (there are ~180 possible items on the inspection list)?

[@ShanesCows]

I would put all the responses in a collection. Then countrows (filter(collection, defiencecolumn)) if that is greater than zero then you know your answer.

[@GHLim]

The syntax seems to be already changed after many years, I'm just starting to learn PowerApps and seems like your syntax is already obsoleted. I created 2 inputs, and a label to display the result when adding 2 inputs together Cell1 + Cell2 doesn't work, instead I have to do Value(Cell1.text) + (Cell2.text)

[@ShanesCows]

There is a newer version of the video if it helps kzbin.info/www/bejne/o3TNYotsgLeMm9k

[@chrishartmann9967]

With SharePoint lists can you do a 1 to many so one person many Phone records?

[@ShanesCows]

Yes. I show it in this video series for an expense report. kzbin.info/www/bejne/rpjdn55qjdGDedE

[@imranfc]

Hi Shane help me about Leave request system in power app ?

[@ShanesCows]

See my other comment

[@CrushersRide]

Hi Shane, Heads up the link to the PowerApps Playlist seems to be broken.

[@ShanesCows]

Thanks Ryan. I need to go check. Sigh

[@ShanesCows]

Fixed. Thanks again.

[@verdijason11]

Shane, any idea how to set a default email value within a (multiple selection) people groups field? Example: Distribution field defaults to ([e-mail]), users can select more groups if needed, but it defaults to one particular email.

[@ShanesCows]

This video might also help kzbin.info/www/bejne/d6GWkHiXbq1rmJI

[@saedkamel8184]

Thank you so much for the great effort, very hepfull

[@ShanesCows]

Glad to help. 😀

[@luca-rw7ss]

@all FYI the "Collections" video link is here: kzbin.info/www/bejne/r4SZnoeIodKootU. Thank you Shane!

[@fadiahdab]

Greate tutorial , Thanks you saved us a lot of time

[@ShanesCows]

Happy to help

[@pongpitisripolpaew6979]

Wow this is very important explanation for powerApp

[@ShanesCows]

Glad to help.

[@colby4390]

Why wont this work. UpdateContext({WaterLines: Choices([@SurveyRequest_DB].ChkWaterLines)})

[@ShanesCows]

Not sure. What are you trying to do?

[@colby4390]

@@ShanesCows I have 4 checkboxes. I also have a combo box. I want to change the options in the combo box based on which of the 4 checkboxes is checked. I wanted to load each choice field and its choices from sharepoint into a variable so I can make the code look cleaner so the code isnt a mile long

[@bradstaples4592]

awesome video!! trying to build my first app for work and this will help me heaps! subscribing straight away :)

[@ShanesCows]

Good luck. You go this! 👍

[@mARCEpABLO85]

very helpful, great video

[@ShanesCows]

Thanks

[@mohammedhammad5389]

Awesome! Shane

[@ShanesCows]

Thanks

[@petereriksson6859]

You are my own hero

[@ShanesCows]

Glad to help you

[@coolbeing163]

thx Shane for this video. It was v.useful :)

[@logeshwarijayaraman5982]

need tutorial for pagination in the list page

[@ShanesCows]

I haven't done that one yet. Sorry.

[@SAULSM17]

Muchas gracias!

[@ShanesCows]

De nada

[@tjvillanueva396]

Mate thanks for this thanks for sharing!

[@ShanesCows]

You are welcome.

[@sarbeshkumarsingh1328]

form one number of checkbox checked=form two number of button with checked box name

[@ShanesCows]

You need to set the default of the second check box to be a variable. Then update the variable with the OnChange event of the first check box

[@Productivity365]

Thanks Shane

[@aparajith1159]

Very good video..

[@ShanesCows]

Thank you. There are a lot of PowerApps videos. Enjoy.

[@aparajith1159]

Is it possible to use power apps to create a page which allows the user to modify the data in a sql table? Also does it work with PB report server?

[@ShanesCows]

Video on SQL kzbin.info/www/bejne/eYCZqZmYn9OMrcU Video on PowerBi kzbin.info/www/bejne/fmrciq2GnJV_ra8

[@aparajith1159]

Thank you.

[@ptrinh123]

Yes "Whistles wet"

[@ShanesCows]

☺

[@blurblursky]

5:13 for those who are impatinet and want to jump right in

[@Supersony92]

I got a fever, and the only prescription is more CalVal

[@ShanesCows]

😂

[@ultraviolethd5545]

You can do that type of sh-fun😂😂😂 18:05

[@ShanesCows]

Whoops 😂

[@hiram4578]

Antique H-white LOL

[@ShanesCows]

Colors are fun!