Intro to PowerApps Variables
Vložit
- čas přidán 25. 07. 2024
- In this video, you will get an intro to PowerApps Variables. We first start with an overview of why you might not need variables because of the Excel-like functionality. Then we dive into contextual and global variables. Fun stuff!
PowerApps Playlist
czcams.com/users/playlist?list...
For support, training, or more information about PowerApps check out www.boldzebras.com - Věda a technologie
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.
Thank you for the kind words. Please let me know suggestions for future topics.
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
Glad to help Javier.
@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!
Thanks Adam. You kind of made me blush. :) Have a great weekend!
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 :-)
Thank you for such a well-structured and informative video. Huge help for learning PowerApps as a non-developer!
Glad to help. 😀
Hi Shane, Thanks for helping in transforming my career into Powerapps. Do continue uploading the videos.
Awesome. Almost 100 😎
Thank you so much sir. Nice explanation on the topic of variables, and its types (contextual, global and collections.)
Gosh, I love you, Shane!!! Thank you for demystifying certain things for me around Power Apps!
You are welcome 🤗 Have a good day!
Really useful stuff there Shane. Keep it going...
Immediately subscribed after watching this video. Video provided the info which is helpful to me. Thanks
Thanks
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
Thank you for your videos. They are amazingly helpful, you have taken me from beginner to intermediate. THANKS SO MUCH.
Great to hear! Keep up the learning and you will be a pro in no time.
Thank you Shane. Good tutorial especially that exclamation mark for the toggle button. ❗
Awesome. Glad it helped.
Great Video. Excited to watch the rest.
PowerApps is awesome. 😎
Hi Shane ,this is the first video I have watched of yours. Thank you sharing knowledge
Glad it was helpful! I have over 200 more to help you keep learning. :)
Very good intro to variables. Thanks!
Hi Shane, awesome show on this one, was able to immediatly duplicate this process on the first try!!!!
Glad to help. 😀
awesome video!! trying to build my first app for work and this will help me heaps! subscribing straight away :)
Good luck. You go this! 👍
Just found this. I appreciate the straightforward explanation. Thanks
Glad to help. 😀 there is a newer version also. Power Apps Variables: Global vs. Context and what you need to know
czcams.com/video/mCj1X6KRYew/video.html
Congratulations on the video !! You understand a lot !! Don't stop making videos
Thank you! 😃
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!
Glad I could help. That is half the fun of PowerApps though, creative solutions like yours. Kudos!
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
Great video Shane! I learned a lot!
Awesome 😎
You rock! it took me 2 hours to find your video... but you save me two hours so im even haha... good info bro!
Maestro,,, felicitaciones, es un excelente vídeo,, gracias y que te vaya super bien
De nada 👍
Very nice as always! Thanks again
Glad to help. 😀
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)?
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.
thx Shane for this video. It was v.useful :)
Greate tutorial , Thanks you saved us a lot of time
Happy to help
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
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
Very kind of you Vishal :)
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.
Use the GUID() function
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.
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.
You need PowerApps Deep Linking powerapps.microsoft.com/en-us/blog/powerapps-deep-linking/
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.
It is on my list to cover.
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.
I need to do more Model Driven for sure. One day, one day.
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?
Yes. Variables are a bit weird.
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.
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.
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?
Start here czcams.com/video/CO6xfbjnYwc/video.html
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!
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.
very helpful, great video
Thanks
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
How Jennifer. Glad the videos are helping. 😀
I have some open requests to the product team for some of this functionality. Not possible today. 😑
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
Set(varCounter, varCounter + 1) Would increment the variable by one. Is that the concept you are looking for?
Thank you so much for the great effort, very hepfull
Glad to help. 😀
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!
Try setting the variable in OnStart for the app
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?
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?
And between each evaluation
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.
Nope. You need to write different ifs to replace the column based on the variable
Mate thanks for this thanks for sharing!
You are welcome.
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)
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.
Fabulous, it works. Thank you Shane.
Cool. Thank you for the update!
Wow this is very important explanation for powerApp
Glad to help.
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.
Set the name of the button to a variable when it is pressed. Show the variable in a label.
@@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.
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?
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.
There is not Jennifer. Sorry
@@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...
Great video. I'm new user of PowerApps!
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.
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})
Try this instead: UpdateContext({CalVal: CalculatedCells.Text})
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 ;)
Hi please can you give also your video Link about the Collection Variable? .. I'am learning from scratch. Looking forward.
This is the first on collection czcams.com/video/yS6mTRlmuls/video.html
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
Awesome! Shane
Thanks
Thanks Shane
With SharePoint lists can you do a 1 to many so one person many Phone records?
Yes. I show it in this video series for an expense report. czcams.com/video/xgznk4XlPCo/video.html
super training by super trainer...
Thanks
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!
Sorry, if I get the chance to share that feedback I will.
You are my own hero
Glad to help you
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.
DatePicker.SelectedDate can be called from the second screen.
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.
Interesting you had to use the full name. Glad you got it.
I like your teaching. Please teach on multiple check boxes, and camera click to attach pics using PowerApps
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.
I have a bunch of SharePoint videos. I think I show this technique in SharePoint Lookup video.
Shane, How do you send more than 1 variable to another screen?
Use Set and create global variables
Shane, any idea how to set a default email value within a (multiple selection) people groups field?
Example: Distribution field defaults to (TeamDistribution@gmail.com), users can select more groups if needed, but it defaults to one particular email.
This video might also help czcams.com/video/Ap3_Ea9H8b0/video.html
Shane do you have any videos related to -- If(variable = true, then change SP field value) ?
I think this one czcams.com/video/IvapIsBbM-U/video.html
@@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?
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.
czcams.com/video/imhxy3REgXc/video.html
Muchas gracias!
De nada
@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.
Set(variablename, lookup(datasource, creatorinfo=user().email))
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
You could have the OnVisible property of the screen set the variable. Or a timer.
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?
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.
Shane Young No, I’m not on Twitter. Sorry.
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!!
Yes. You have them already. put them in the body of the email and you are all set. 😀
@@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 :)
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
Not possible. :( SOrry
@@ShanesCows Thanks for your response :)
Hi Shane help me about Leave request system in power app ?
See my other comment
11:25 I owe you a beer (or beverage of your choice under $20) for this one. Offer valid for next 3 years.
Hope I get a chance to take you up on the offer
in the label when I type & I cannot find that variable what to do? it's giving error
Make sure you Set the variable.
Hi Shane, Heads up the link to the PowerApps Playlist
seems to be broken.
Thanks Ryan. I need to go check. Sigh
Fixed. Thanks again.
need tutorial for pagination in the list page
I haven't done that one yet. Sorry.
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.
OnChange for the Dropdown If(Self.Selected.Value = "Red", Navigate(RedScreen), Navigate(BlueScreen)) SOmething like that should get you close.
@@ShanesCows Thanks a lot!!!
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 ??
Set(varNumber, Value(TextInput1.Text))
@@ShanesCows wow THANKS done 👍
Very good video..
Thank you. There are a lot of PowerApps videos. Enjoy.
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?
Video on SQL czcams.com/video/CO6xfbjnYwc/video.html
Video on PowerBi czcams.com/video/H9yYzPg0LwM/video.html
Thank you.
@all FYI the "Collections" video link is here: czcams.com/video/yS6mTRlmuls/video.html.
Thank you Shane!
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)
There is a newer version of the video if it helps czcams.com/video/mCj1X6KRYew/video.html
form one number of checkbox checked=form two number of button with checked box name
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
Why wont this work. UpdateContext({WaterLines: Choices([@SurveyRequest_DB].ChkWaterLines)})
Not sure. What are you trying to do?
@@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
I got a fever, and the only prescription is more CalVal
😂
You can do that type of sh-fun😂😂😂 18:05
Whoops 😂
Yes "Whistles wet"
☺
5:13 for those who are impatinet and want to jump right in
Antique H-white LOL
Colors are fun!