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.
@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!
Glad to help. 😀 there is a newer version also. Power Apps Variables: Global vs. Context and what you need to know ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mCj1X6KRYew.html
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
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 :-)
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!
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
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
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
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, 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 ??
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?
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!
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 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 :)
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)
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.
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?
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.
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.
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.
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 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?
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
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.
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.
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.
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
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.
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!
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
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
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.
@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.
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.
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?
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?
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 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...
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.
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.
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.
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})
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 ;)
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.
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 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
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?
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.
Video on SQL ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-CO6xfbjnYwc.html Video on PowerBi ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-H9yYzPg0LwM.html