Shane Young I looked at trying to save pen input images into a SharePoint list in the past and it didn’t look like it could be done at the time. If that can be done now, a video on how to do it would be incredibly useful.
There is not a pretty way. This is the most recent way I came across but I have not tried. If you do let me know how it goes. community.powerapps.com/t5/General-Discussion/Pen-input-save-image-to-SharePoint/td-p/81575
I just started working with PowerApps on Monday of this week, and I have two weeks to build a full scale app alone, and the primary reason I'm having success (and that I'm able to sleep at night instead of just going into panic mode!!) is because of all your amazing, helpful videos. Thank you so much for these!
For resetting the values once you hit the button on the popup, instead of copying the whole formula in the refresh icon, you can use the select function which can invoke the function of another button (select (refreshbutton)). Worked for me.
Hello Shane. Thank you very much for your videos! For the formula at 5:00, I preferred to use: If(IsMatch(txtMailAdress.Text, Email), false, true) && If(IsBlank(txtMailAdress),false, true) Just sharing!
Hey Shane - I've never commented on a youtube video before, but I wanted to thank you for the work you put into each video to make them easy to follow. About a week ago I had never even seen a powerapps. Since then, I have watched every video and have built a fully customized app that is going to change the way we work in my company. Thank you again.
Thanks Taylor! That is so awesome to hear and the type of thing that keeps me making content. Be sure to let us know how things go as you build awesome apps! :)
For the visible, I think we can define 3 virables, virable A=if(isblank(emailadress.text),0,1), Virable B=if(Ismatch(emailadress.text,email),1,0) Virable C=A*B ; then for the visible we can just use if(c=0,true,false) I haven't watched following videos so I don't know if there're other solutions.But this is just simple enoughfor me to understand. And thanks for your videos Shane, I'm one learning this from China, it's really hard to find something that I can follow, but hanks god you're there!
I enjoy your videos Shane! Great work. Just a comment regarding the "Visible" property of the label "* Please check your email"; I think you can simplify the formula by dropping the if() function, especially since your outcomes are 'true' or 'false'. Your And() and Or() functions should be sufficient because they return 'true' or 'false' based on the conditions; so the if(x, true, false) is overkill since x will yield either true or false by itself. Hope that helps :) And keep up the videos!
Hi Shane, I was following along with you. But this Image check solution is not working anymore. Here is the workaround which works for me (may be it helps some other viewers) Instead of OnVisible property of screen what I did is OnSelect property of Signature input I used your formula i.e. UpdateContext({BlankImage: Signature.Image}) and then for consent button's.DisplayMode property I updated the condition i.e. If(And(BlankImage = Signature.Image, Age >= 18, !IsBlank(Name), !IsBlank(EmailAddress)), DisplayMode.Edit, DisplayMode.Disabled) And now it is working perfectly for my app.
Great video Shane. Thank you very much! For the formula at 5:00, I preferred to use: If(And(!IsBlank(EmailAddress); !IsMatch(EmailAddress.Text;Email));true;false) It got the same results! Just sharing!
Nice video. Very usefull. I used the 'show controls' option to hide the controls on the signature box. Looks way better and you won't use colors for signatures anyway.
For the expression at 5:00, I was able to do the same using something like this: If(And(!IsBlank(InputEmail), !IsMatch(InputEmail_2.Text, Email)), true, false) Not sure if it is more or less confusing than your approach. Just sharing :) Thanks for this pair of videos, lots of useful tips.
Thank you for the great Video! I used “ If(!IsBlank(Email.Text) && !IsMatch(Email.text,Email) , true , false )” on visible property of the Error message . Error will only show if there is an entry that doesn’t match Email pattern.
great videos chief. keep up the work. I am a data engineer and they threw me on this mini app building project where I have ZILCH experience. Allowed me to make a sexy interactive form.
I always watch your videos with pleasure and learn many things. Thanks Shane. But I think this solution is not work with PenInput in Forms. Right? I applied all you did in video but it doesnt work in my app.
Thanks Shane for this intuitive video. As far as logic goes, I'm just missing out one functionality. And that is to disable the email-copy if a valid email is not being entered. =) Keep the great videos coming. Greetings from Sweden.
I have been through about 10 ways to do this. The darn pen input control kept changing underneath me. So this is what I came up with to get through it on this video. Sadly UA-cam doesn’t let me edit videos after the fact.
Hi Shane! Great video! I wrote below condition for the "Please check your email" text's Visible attribute, which I think is a bit easier to read/write. Let me know what you think? If(IsBlank(EmailInput), false, If(IsMatch(EmailInput.Text, Email), false, true))
Hey Shane, great video, I'm your Chinese fan, sorry for my break English, I spend 1 day to fix a powerapps problem in this video, about "If(And(blankimage= sign.Image,Age.Value >=18,IsMatch(EmailAddress.Text, Match.Email)), DisplayMode.Edit, DisplayMode.Disabled)" doesn't worked(variables last 2 digits was always 2 less), the correct steps should be 1.Click signature box, 2.select "Onselect" and enter "Set(blankimage, sign.Image)" then the above conditional statement can be used, In this video, it is wrong to enter Updatetext(blankimage:signature) in Screen1-Visable.😀
Thank you Shane for this wonderful Video, just one question. Instead of hiding the buttons for certain users who don't have the access, how can i grey out a button ? so a user cant click a button (its greyed out) if they don't have access to it instead of hiding it?
Appreciate the video. Our form is fairly complex, different fields depending on selection from two different dropdowns, but some fields are present on all iterations, So I just used those fields for the DisplayMode Property of our Submit button. While I have you, I have a quick question. We have a SP form we are customizing in PowerApps. In the OnCancel Property of SP Integration, is there a way to redirect them to another SP page or maybe even another screen in PowerApps? Currently it just takes them back to the all items view of the sp list. I've tried using the Launch function, but it didn't work. Next I was going to try the Navigate function. Any advice you can provide would be greatly appreciated!
Hi Shane, Thank you for sharing the videos. Have a question regarding the context variable "BlankImage" set here to use Signature.Image value. In my case, both BlankImage and Signature.Image are having different values always, especially when loading the form for the first time. After adding values to other fields (Name, Email and Age), the consent button gets enabled even when PenInput field is not touched. Is that the expected behavior? My understanding is when the form loads for the first time, both BlankImage and Signature.Image should have same values.
Old question, but thought I'd take a crack at this for anyone new to learning Power Apps like me and going through Shane's old videos. I was running into your exact situation and was banging my head trying to figure it out. Whenever my form loads and even when I reset the form, the values for both BlankImage and Signature.Image were always different. Here was my way around this: I set the OnSelect property of Signature to: UpdateContext({BlankImage: Signature.Image}) By doing this, I was at least able to get both BlankImage and Signature.Image values to match. Then I made the Consent button become available if both values matched instead. I changed the DisplayMode property of Button_Consent to: If(And(BlankImage = Signature.Image, Age.Value>= 18, !IsBlank(Name), !IsBlank(EmailAdress.Text)),DisplayMode.Edit,DisplayMode.Disabled) If you reset the form, BlankImage and Signature.Image values will be different. Then once you draw in the peninput area, their values will match.
Thanks Shane for this great video.Can you please make a video on filtering the datasourse on the button click.Lets say I have two buttons with text "Inprogress" and "Completed". It should filter the gallery items based upon toggling the above buttons.
Shane, thank you for your tutorial(s) !!! Really helps me understand how to get forward with Powerapps. at the end of this video you ask your viewers for any ideas. Is it possible to use data in a form to fill variables in a powershell script and to run a powershell script? A little context I'm working on an app for our HR department for enrolling new empoyees. Again, Keep it UP! your video's are clear, and easy to follow!
Someone asked something similar the other day. I think you would have PowerApps write the data to a SharePoint list. Then have Flow collect the info and send it to PowerShell. I haven’t done it but in my head it is possible. This will be a video sooner than later. 😀
Shane, love your videos. I have a SharePoint list that has client info. I want to count the number of days from signing until moving to the next phase. I have that down how to count the number of days from signing until today. When the status changes I want to end that and count the days in the next phase until that ends. Maybe a short video on how to do that.
Thanks for your video Shane, Learning a lot. Thanks a ton. I have a question, where does the data from this form get stored? how to retrieve that data?
I need to create a form for user with few fields to select . they must check if the selection (of all those 4 fields ) are according to some conditions. can you advise how to start?
Hey Shane. For the refresh on the pop-up couldn't you just call something like button_Refresh.OnSelect that way you only have to define refresh once and call it several times.
Hi Shane, finding your videos very helpful but i'm having an issue and i think it could be due to a Microsoft update to PowerApps, i followed your steps for the consent button display mode and all works well except the consent button becomes active as soon as name, email and age are filled in before the signature is even touched. If(And(BlankImage Signature.Image, Age>= 18,!IsBlank(Input_Name),!IsBlank(Input_Email)),DisplayMode.Edit,DisplayMode.Disabled).
Great stuff, Shane, the whole playlist is a gem! Quick question: am I right in thinking that the Consent button will become visible even if the email address is not correctly typed in? As in the app does not check if the address is in the right form, just checks if the field is populated. If yes, how do we add that in the nested If Or/And formula, please? If no, please disregard the message except the first paragraph, the videos are awesome!
I will have to go back and look. If I didn’t show you how then for the consent button you just need to add the IfMatch function like we did for the red text. Thank you for the kind words. Shane
@Shane , great video thanks .Have been struggling with a way to close the app once the a user has submitted the form .We want to exit the PowerApp completely and close the browser tab / windows . Any ideas ?
Hey Shane! thanks for another cool video!... I have a question... In the pop up box, instead of a fixed message, can I show information from the objected selected?? For example, if I select purchase order xyz, when i click it, it shows me the information from the Comments column listed in Sharepoint?
Your tutorials help a lot though this one still cannot implement yet to test. Can I know is this still validate correctly when user click 'cross' button on pen input control after scratching something on it and make it blank again?
Hi Shane, thanks for your video first of all, it is really helping to understand Power Apps more and more by using your guides! I have a question about the Consent button being available when input is given into required fields. I am trying to set something up in one of my own apps, but I struggle with 1 thing. Is it correct that you cannot use a into the IF function to check wheter this gallery is blank or has input? I have created a gallery, like you showed in one of your video's, which will be storing different scanned items. In my app it seems that it always has input, however I will only see the input when I play the app and scan multiple items after eachother. Keep up the good video's !
how to create popup in poweshell which will not minimize and we will not able to click outside popup. in simple work, similar to close button popup but using powershell
Hello.. I was wandering if we can have a Popup visible if we click or Hover over a label which is in display mode 'Disabled'. The idea is that when a user would like to pres a item which is 'disabled' , than a a popup would explain to him why he can't go turther or what he shoud do in order to continue normally the process. Thank you for your help.
Thank you for another great video! I made the form with this video, however, the delay is not working for me. I followed all the steps, but as soon as I get to the point to @ in my email the alert will show up. Does anyone else has this issue? Thank you again for all you do.
It is a goofy little setting. It works but the delay isn't long enough. You have to type pretty quick for it not to work. I would also test it not in preview and see if it works better for you.Thanks for watching!
Thanks for this! I have a 6 screen app, each team populates and saves their own page. do you have a suggestion on a popup or save confirmation to use? the streaming dots along the top do not seem to cut it? Thanks!
Hi Shane, what still bug me is when or why the Signature in "And(BlankImage Signature.image)" need to put ".image" whereby others just need to addressed their control name such as "EmailAddress" Understood you have video about variables, but still I can't sort this out. However it is cool video. Thanks.
@@ShanesCows Yes, but how to differentiate or recognized, this command need to put the reference with their property and other command is just the control name, provided there is quick help on its selection as we typed. Thanks for prompt response, so cool. :)
Hi Sean great video . I used the pop up message example when a form is submitted. Minor setback I have a unique field (checks for duplicate entries) that doesn’t work now any idea? It appears the pop up is initiating before the form data is being checked for errors. Thanks
hi thanks you so much for your work great job if its possible would you mind make a serie about a sharepoint list to select a customer populate all the field when you select a customer then add the form in another sharepoint list it's an idea what do you think about this?
Hey Shane, While formatting our consent button it shouldnt light up when the email address entered is not valid, so here is a quick update If(And(Blank Image Signature.Image, Age >= 18, !IsBlank(Name), IsMatch(EmailAddress.Text, Match.Email)), DisplayMode.Edit, DisplayMode.Disabled) Keep up the good work
Great video! Save button working great, but in my app there is required fields so need to add an error handler if one or more fields not filled in as found out that with this pop up the data won't save at all if one or more of these fields is empty, but won't inform the user. It appears as though it saved as expected. Any advice on this? Thanks
@@ShanesCowsthanks Shane, will try that. Would that likely mean making an if error handler to cover each of the fields, which would make a very long piece of code or is there an easier way?
Thanks for the awesome video! How can you get a popup when you are trying to delete an item in the gallery? I am unable to use "ThisItem" in the popup's button since its outside of the gallery's item
Shane, First off, thank you for sharing so many great tutorials. I've watched quite a few of them while hacking away at some apps for my company. One thing which would be awesome for you to cover is how to perform a join function on SQL tables within PowerApps. This would be great. Also, are you coming to the Microsoft Business App summit in July? Thanks.
Hi Don - What are you trying to accomplish with the join? I wonder if this video would help you. Ignore that I talk about SharePoint in the video. I think the concept would be exactly the same with SQL. SharePoint was just the data source I chose. ua-cam.com/video/43ekj5MlNJU/v-deo.html Does it help?
I'll check it out and let you know. I found an example on how to do it but your way will probably explain it more clearly. Again, appreciate the videos, keep them coming.
Hi Shane, great video, I know you made this video a long time ago, but I wanted to highlight that the OnVisible creation of a new variable to capture the Peninput image signature value is not working anymore for the validation field since the Peninput.Image text itself is returning a new url every time we return to the screen even though no changes happened to it. Maybe you could suggest a workaround. Thank you and happy weekend ahead.
Shane, I have a new request screen with three popups where I collect info ( when you click on popup button he open popup, user populate fields and on that page save button just hide popup ) and on same page I have one button where I patch all info from popups. I patch all forms collected though popups and I reset forms after that and navigate on requests. Problem is when I have multiple users logged and when they try to submit new request, I got info mixed from their requests and most likely overwrite data from one to other request.
Hey Shane, it's having a issue these days, it adds blank value in BlankImage on first load to screen and if we go to and fro it updates old value of penInput where as pen input has already been updated to a new value so it's not working anymore
Hey Shane, this is another excellent video but I'm having a problem. Rather than a consent button I have a submit button. Everything works great with the popup except once I hit the Close button the app gets stuck on "Getting your data" rather than returning to a blank form. Any ideas?
Hi, Shane! Thank you for the video - always helpful! I don't know if this question contextually belongs here or if this is an idea for a future video. What I am trying to do is have a notification for when someone is trying to remove a record from the parent table (in SQL back end) and it has child records attached to it. When the back end child table FK has Delete Rule set to "No Action", it won't delete the parent record, but Power Apps doesn't really treat this event as an error, therefore my IfError(RemoveIf(Source, Notification(...))) does not work. Any ideas on how to best handle this?
Hey Shane, I love your videos and have learned a lot. I'm definitely a novice to all of this. Anyway, dumb question. I'm trying to create an app that won't let a person in unless they've been approved. I followed your approval vid and everything works great. Now in the app I'm trying to create a condition that says they can enter IF they have been approved on the sharepoint list. How do I create a statement that refers to the sharepoint list? It seems like it should be simple but right now I want to punch my screen. Thanks, guy and keep up the generous work! You help us lost souls!
Hello Shane, Thanks for such a detailed PowerApps tutorial. i have doubt if i would like to pass parameters in web URL (not in app url) and grab that in POwerapps. Is it possible? its requirement in my project. Any help would be great.
Hi Shane. I'm trying to create a Popup based in time. I used in Visible field: If(Value(Text(Now(); "hhmm")) > Value(1449); true; false) but it's not working when I run the App. Any idea? Thansk in advance from Brazil.
Hi Shane I'm having real trouble with what I think is a basic command. I have a basic budget app which is working nicely. I want to add a popup warning box when the budget is nearing its limit. My labels total and sum data from a main Excel table. These work. I cannot get PowerApps to do a basic IF statement to then popup a warning box e.g. IF(Label with the spend => label with the total amount, "Overbudget", ""). Doesnt work with > or
@@ShanesCows thanks Shane. For some reason, although I have used Value(label.text), I can do subtraction but I cannot use any > or < in an IF statement as it keeps telling me the label isnt a value. But it does allow = in an IF statement, with no issues I have also just tried a very simple formula by inserting two labels, updating the text to "100" in each. And then in a seperate label, doing a few sums. For some reason it is telling me the one label isnt a value (error type control) even though both are inserted as new labels and input identically. This is why my IF isnt working - for whatever reason the labels arent all converting to values (despite also doing the Value() formula).
Any chance you know why a popup would work when previewing the app, but once it's saved and published to the sharepoint form the popups do not launch in actual use? If I go to edit the powerapp and preview it works every time in the preview mode.. it's driving me batty
Hi Shane, has something changed recently with the peninput control? After resetting the input control and updating the context (to store the empty image value as JSON), for some reason the peninput image value changes (slightly), making it hard to keep track. Can you re-visit the app you demoed to see if it still works?
Great tutorial brother. On the topic of dialogs, I've been trying to come up with a way to create a popup in a gallery, to no avail, I have a column in SharePoint for "LineNotes" that I'm using in a repeating table gallery for receiving products. The text input is too small for a multiline mode and I don't want the end users to have to squint to see the text. so I thought a popup would do nicely. Any pointers would be awesome. Thanks again.
@@ShanesCows Yeah, it's a real head scratcher for me too. I'm trying another approach, I'm gonna have the visible on the Gallery set from a varible to show hide based on a dropdown from a form on the same screen as you explained in "PowerApps Hide Button Based on User and other fun" around "23:00".
@@ShanesCows My solution was to make the gallery row size kinda dynamic, I put an icon in the row with "UpdateContext" onSelect and set the text input visible to varShowNotes.
Hi Shane, I think your way in the video doesn't work anymore. You can check the Power Apps Community, under your question: "How do you determine if Pen Input is blank?". @seadude and @grahampasmurf contributed to an updated solution following your initial idea, and it still works well now. And @newbie101 has got another way to solve the problem, also works really well and is quite simple, only problem is not able to adjust stuff like color, but it doesn't really matter. Anyway, this is a problem worth digging in and I am happy that we got solutions here.
Hi Shane, I love your videos, keep up the good work! About the formula for the "Check your email" label, isn't the following good enough? Visible = And(!IsBlank(EmailAddress), !IsMatch(EmailAddress.Text, Email)) as we only want to show the label when the user entered something that does not match the format of an email address. Thanks again for all your videos!
Hi Shane, what a great video!! I have one little question: how could I show a banner pop up (like what's app message and others apps, who drops from the screen) in my power apps? Just for explain, I want to every time I'm near from a store, my power apps show me a pop up "You're near from Store X, do you want to visit?", even if i'm not using the app on the moment. Can i do that? Thanks for your support!
I tried using this for a checkbox and an image. Tried visible, onselect, uncheck, check in both the checkbox and the popup. So if the box is checked then popup(image), if the box is uncheck then no popup(image). So far I check and it pops up so halfway there. When I uncheck popup stays. Still working on that. BTW I love the videos!
Hi Shane, Love your videos. I have question i am working on an app where i am using the formula below based on visible vs not visible and want to show a label based on wether the has information based on one section i want the box to dissapear but if there is no field with specific data then i wan the box to be visable. Is this function possible? If(Or(IsBlank(TCampus.Text),If(And(!IsBlank(TCampus.Text),!IsMatch(TCampus.Text,"SC North")),true,false)),true,false)
Great video Shane. Very helpful. Need a help with clearing a data card value conditionally. I have two fields. One is a drop down field. If the value in the drop down field changes to "RED", then the other field data should be reset/cleared. I wrote this formula to the "Reset" property of the second field value but it works only on the new form and not on the edit form: If(DataCardValue11.Selected.Value="RED",true, false) Can you please help on how to make this work even for the edit form?
@@ShanesCows Hi, thanks for the videos, they've helped me do my project for school. I have a problem though, I have one application that I have shared with my instructor. If I try to launch it from the Home page, it loads the old version of the app I have saved, but if I press the Edit button right next to it it loads the app in the studio to the version that I have built up until now. I'm worried that if I am asked to present my project, and I press Play (instead of Edit) it will load the first version of the application. Have you encountered this problem before? Do you know how to fix it? I can mention that I don't have duplicate apps, in fact I have only one app saved, I saved the application and logged off and logged back. I'm not sure that to do. Thanks in advance if you can help.
Hi, nevermind, I figured it out, I had to go through the additional step of publishing it.. now I wonder if my instructor is going to see v1 or v2, humph, humph. Thanks once again for the videos.
Great video, lots of useful bits of info.
Thanks. What else can I cover to help you?
Shane Young I looked at trying to save pen input images into a SharePoint list in the past and it didn’t look like it could be done at the time. If that can be done now, a video on how to do it would be incredibly useful.
There is not a pretty way. This is the most recent way I came across but I have not tried. If you do let me know how it goes. community.powerapps.com/t5/General-Discussion/Pen-input-save-image-to-SharePoint/td-p/81575
Is it possible to create training video about an app for tracking activities by week for a period of four weeks?
hey Shane can u do a video to add address details dynamically & with maps to visualise the address too. #awesomeshane @boldzebras 😉
I just started working with PowerApps on Monday of this week, and I have two weeks to build a full scale app alone, and the primary reason I'm having success (and that I'm able to sleep at night instead of just going into panic mode!!) is because of all your amazing, helpful videos. Thank you so much for these!
Awesome and good luck
Dido here
For resetting the values once you hit the button on the popup, instead of copying the whole formula in the refresh icon, you can use the select function which can invoke the function of another button (select (refreshbutton)). Worked for me.
Yup. :) Thanks for sharing!
Hello Shane. Thank you very much for your videos!
For the formula at 5:00, I preferred to use:
If(IsMatch(txtMailAdress.Text, Email), false, true) &&
If(IsBlank(txtMailAdress),false, true)
Just sharing!
Thanks for sharing. Lots of different ways to do the same stuff. 😊
amazing
I have enjoyed your entire series on the Consent form
Awesome!
Hey Shane - I've never commented on a youtube video before, but I wanted to thank you for the work you put into each video to make them easy to follow. About a week ago I had never even seen a powerapps. Since then, I have watched every video and have built a fully customized app that is going to change the way we work in my company. Thank you again.
Thanks Taylor! That is so awesome to hear and the type of thing that keeps me making content. Be sure to let us know how things go as you build awesome apps! :)
OMG! Powerapps Teacher and Rock Star all in 1..............Thanks Shane!
Glad to help. (You made me blush)
For the visible, I think we can define 3 virables, virable A=if(isblank(emailadress.text),0,1), Virable B=if(Ismatch(emailadress.text,email),1,0) Virable C=A*B ; then for the visible we can just use if(c=0,true,false)
I haven't watched following videos so I don't know if there're other solutions.But this is just simple enoughfor me to understand.
And thanks for your videos Shane, I'm one learning this from China, it's really hard to find something that I can follow, but hanks god you're there!
Glad to help. :)
Accidentally found your channel yesterday and I’m addicted. Excellent content. Thank you very much!!
Awesome! 😻 Glad it is helping and thanks for the feedback. If you have ideas for future videos let me know. -Shane
I enjoy your videos Shane! Great work. Just a comment regarding the "Visible" property of the label "* Please check your email"; I think you can simplify the formula by dropping the if() function, especially since your outcomes are 'true' or 'false'. Your And() and Or() functions should be sufficient because they return 'true' or 'false' based on the conditions; so the if(x, true, false) is overkill since x will yield either true or false by itself. Hope that helps :) And keep up the videos!
Good call Wayne. I do it and teach this more correct way these days
Shane you are the Power Star ! Great videos and thank you so much
Glad to help. 😀
Late to the party but excellent training, thanks Shane! and also to the contributors below!
Never too late. 😎
Great Videos Shane. Simple, useful and to the point.
Thanks! I use these concepts in just about every app.
Hi Shane, I was following along with you. But this Image check solution is not working anymore.
Here is the workaround which works for me (may be it helps some other viewers)
Instead of OnVisible property of screen what I did is OnSelect property of Signature input I used your formula i.e. UpdateContext({BlankImage: Signature.Image})
and then for consent button's.DisplayMode property I updated the condition
i.e. If(And(BlankImage = Signature.Image, Age >= 18, !IsBlank(Name), !IsBlank(EmailAddress)), DisplayMode.Edit, DisplayMode.Disabled)
And now it is working perfectly for my app.
Awesome video!! I am new to Powerapps and learned a lot. Much better than Microsoft tutorials.
Thanks
you explained concepts nice and clean. on top of it you have creative sense of humor.. Can't stop laughing at some video instances.. LOL
Glad you liked it! 😁 I try to make it not boring.
Great video Shane. Thank you very much!
For the formula at 5:00, I preferred to use:
If(And(!IsBlank(EmailAddress); !IsMatch(EmailAddress.Text;Email));true;false)
It got the same results! Just sharing!
Awesome. Love it. Thank you.
Nice video. Very usefull.
I used the 'show controls' option to hide the controls on the signature box. Looks way better and you won't use colors for signatures anyway.
Thanks. And I agree Tom, hiding the controls is the way to go.
For the expression at 5:00, I was able to do the same using something like this:
If(And(!IsBlank(InputEmail), !IsMatch(InputEmail_2.Text, Email)), true, false)
Not sure if it is more or less confusing than your approach. Just sharing :)
Thanks for this pair of videos, lots of useful tips.
Thank you @Kyle Drumm, your expression worked great for me.
It worked very well
Thank you for the great Video!
I used “ If(!IsBlank(Email.Text) && !IsMatch(Email.text,Email) , true , false )” on visible property of the Error message . Error will only show if there is an entry that doesn’t match Email pattern.
Nice job! Glad you got it.
great videos chief. keep up the work. I am a data engineer and they threw me on this mini app building project where I have ZILCH experience. Allowed me to make a sexy interactive form.
Awesome !
I always watch your videos with pleasure and learn many things. Thanks Shane. But I think this solution is not work with PenInput in Forms. Right? I applied all you did in video but it doesnt work in my app.
Thanks Shane for this intuitive video. As far as logic goes, I'm just missing out one functionality. And that is to disable the email-copy if a valid email is not being entered. =) Keep the great videos coming. Greetings from Sweden.
Thank you.
Your videos are very helpful, Thank you Shane, you are the BEST!!!
Glad to help. 😀
You can also work with "OnChange" on the PenInput field. Just set a status variable and set it to "" by reset.
I have been through about 10 ways to do this. The darn pen input control kept changing underneath me. So this is what I came up with to get through it on this video. Sadly UA-cam doesn’t let me edit videos after the fact.
Very informative and useful tutorials. Thank you so much Shane.
Happy to help.
Hi Shane, the way you explain is awesome. Thanks
Hi Shane! Great video! I wrote below condition for the "Please check your email" text's Visible attribute, which I think is a bit easier to read/write. Let me know what you think?
If(IsBlank(EmailInput), false, If(IsMatch(EmailInput.Text, Email), false, true))
Hey Shane, great video, I'm your Chinese fan, sorry for my break English, I spend 1 day to fix a powerapps problem in this video, about "If(And(blankimage= sign.Image,Age.Value >=18,IsMatch(EmailAddress.Text, Match.Email)), DisplayMode.Edit, DisplayMode.Disabled)" doesn't worked(variables last 2 digits was always 2 less), the correct steps should be 1.Click signature box, 2.select "Onselect" and enter "Set(blankimage, sign.Image)" then the above conditional statement can be used, In this video, it is wrong to enter Updatetext(blankimage:signature) in Screen1-Visable.😀
Self explanatory video. Thank you for this.
Awesome stuff Shane, thank you
Glad it helped.
Awesome vid - LOTS of useful stuff.
Thanks 🙏
Very Helpful and easy to understand
Cool. Glad it helped
Thanks Shane!
Happy to help!
Thanks
you are the best, no question :)
Thanks
You're welcome!
Thank you Shane for this wonderful Video, just one question. Instead of hiding the buttons for certain users who don't have the access, how can i grey out a button ? so a user cant click a button (its greyed out) if they don't have access to it instead of hiding it?
For Email Validation is used this formula,
If(IsBlank(EmailAddress), false, If(!IsMatch(EmailAddress.Text, Email), true, false))
Thanks for sharing
Appreciate the video. Our form is fairly complex, different fields depending on selection from two different dropdowns, but some fields are present on all iterations, So I just used those fields for the DisplayMode Property of our Submit button.
While I have you, I have a quick question. We have a SP form we are customizing in PowerApps. In the OnCancel Property of SP Integration, is there a way to redirect them to another SP page or maybe even another screen in PowerApps? Currently it just takes them back to the all items view of the sp list. I've tried using the Launch function, but it didn't work. Next I was going to try the Navigate function.
Any advice you can provide would be greatly appreciated!
Hey Jeremy. I haven't tried anythign clever here but I don't think I have any good guesses. Sorry
Hi Shane, Thank you for sharing the videos.
Have a question regarding the context variable "BlankImage" set here to use Signature.Image value. In my case, both BlankImage and Signature.Image are having different values always, especially when loading the form for the first time. After adding values to other fields (Name, Email and Age), the consent button gets enabled even when PenInput field is not touched. Is that the expected behavior? My understanding is when the form loads for the first time, both BlankImage and Signature.Image should have same values.
I have the same issue.
Old question, but thought I'd take a crack at this for anyone new to learning Power Apps like me and going through Shane's old videos. I was running into your exact situation and was banging my head trying to figure it out. Whenever my form loads and even when I reset the form, the values for both BlankImage and Signature.Image were always different. Here was my way around this:
I set the OnSelect property of Signature to:
UpdateContext({BlankImage: Signature.Image})
By doing this, I was at least able to get both BlankImage and Signature.Image values to match.
Then I made the Consent button become available if both values matched instead. I changed the DisplayMode property of Button_Consent to:
If(And(BlankImage = Signature.Image, Age.Value>= 18, !IsBlank(Name), !IsBlank(EmailAdress.Text)),DisplayMode.Edit,DisplayMode.Disabled)
If you reset the form, BlankImage and Signature.Image values will be different. Then once you draw in the peninput area, their values will match.
Thanks Shane for this great video.Can you please make a video on filtering the datasourse on the button click.Lets say I have two buttons with text "Inprogress" and "Completed". It should filter the gallery items based upon toggling the above buttons.
I will add it to the list. Thanks!
Shane, thank you for your tutorial(s) !!! Really helps me understand how to get forward with Powerapps. at the end of this video you ask your viewers for any ideas. Is it possible to use data in a form to fill variables in a powershell script and to run a powershell script? A little context I'm working on an app for our HR department for enrolling new empoyees. Again, Keep it UP! your video's are clear, and easy to follow!
Someone asked something similar the other day. I think you would have PowerApps write the data to a SharePoint list. Then have Flow collect the info and send it to PowerShell. I haven’t done it but in my head it is possible. This will be a video sooner than later. 😀
Cool :) Thanks a lot Shane. Your videos rock
Shane, love your videos. I have a SharePoint list that has client info. I want to count the number of days from signing until moving to the next phase. I have that down how to count the number of days from signing until today. When the status changes I want to end that and count the days in the next phase until that ends. Maybe a short video on how to do that.
David you need to add logic at each step that counts and saves days before you change the status. I would use patch function
Thanks for your video Shane, Learning a lot. Thanks a ton. I have a question, where does the data from this form get stored? how to retrieve that data?
Power Apps has 300+ data sources so you can store it almost anywhere you want. Maybe this video will help ua-cam.com/video/MclJ_O9HvJQ/v-deo.html
I need to create a form for user with few fields to select . they must check if the selection (of all those 4 fields ) are according to some conditions. can you advise how to start?
You need to write an if statement that checks they all match the values you want.
Awesome video Shane. I am trying to create a popup based on a radio button selection that gets its choices from a SharePoint list. Is this possible?
Yes. Use the OnChange of the Radio control to trigger the variable to show the pop up.
Hey Shane. For the refresh on the pop-up couldn't you just call something like button_Refresh.OnSelect that way you only have to define refresh once and call it several times.
Yes sir. You are exactly right. I figured it out a couple days too late. 😀
Hi Shane, finding your videos very helpful but i'm having an issue and i think it could be due to a Microsoft update to PowerApps, i followed your steps for the consent button display mode and all works well except the consent button becomes active as soon as name, email and age are filled in before the signature is even touched. If(And(BlankImage Signature.Image, Age>= 18,!IsBlank(Input_Name),!IsBlank(Input_Email)),DisplayMode.Edit,DisplayMode.Disabled).
They may have changed the sig piece. I haven’t tried it in a long time. If you take it out does it work?
Great stuff, Shane, the whole playlist is a gem!
Quick question: am I right in thinking that the Consent button will become visible even if the email address is not correctly typed in? As in the app does not check if the address is in the right form, just checks if the field is populated. If yes, how do we add that in the nested If Or/And formula, please? If no, please disregard the message except the first paragraph, the videos are awesome!
I will have to go back and look. If I didn’t show you how then for the consent button you just need to add the IfMatch function like we did for the red text. Thank you for the kind words. Shane
@Shane , great video thanks .Have been struggling with a way to close the app once the a user has submitted the form .We want to exit the PowerApp completely and close the browser tab / windows . Any ideas ?
There is an exit function but that will only close out o powerapps. Or close the browser
Hey Shane! thanks for another cool video!... I have a question... In the pop up box, instead of a fixed message, can I show information from the objected selected?? For example, if I select purchase order xyz, when i click it, it shows me the information from the Comments column listed in Sharepoint?
Yes you can! Do a LookUp to get the record you want to show.
@@ShanesCows 😍 thank you so much!!
Very, very nice! Thank you!
Glad to help. 😀
You don't need to copy the whole formula at 23:28 you can use Select to select the reset button to reduce redundancy in code.
Yeah. The Select function made it into later videos but not this one. Whoops.
Your tutorials help a lot though this one still cannot implement yet to test. Can I know is this still validate correctly when user click 'cross' button on pen input control after scratching something on it and make it blank again?
I think so but it is has been a long time since i tried.
Hi Shane, thanks for your video first of all, it is really helping to understand Power Apps more and more by using your guides!
I have a question about the Consent button being available when input is given into required fields. I am trying to set something up in one of my own apps, but I struggle with 1 thing.
Is it correct that you cannot use a into the IF function to check wheter this gallery is blank or has input?
I have created a gallery, like you showed in one of your video's, which will be storing different scanned items.
In my app it seems that it always has input, however I will only see the input when I play the app and scan multiple items after eachother.
Keep up the good video's !
Sorry for the delay. This video shows how you can use IsEmpty to check a gallery. ua-cam.com/video/vbRdFfq5tB8/v-deo.html
how to create popup in poweshell which will not minimize and we will not able to click outside popup. in simple work, similar to close button popup but using powershell
That I don’t know. Sorry
Hello.. I was wandering if we can have a Popup visible if we click or Hover over a label which is in display mode 'Disabled'. The idea is that when a user would like to pres a item which is 'disabled' , than a a popup would explain to him why he can't go turther or what he shoud do in order to continue normally the process.
Thank you for your help.
Yes, you control has a property called ToolTip. Set the text to be blank if Edit mode and your message if disabled.
@@ShanesCows Thank you.
If I have 2 popups in the same screen on a click of button one shoudn't appear while the other is selected.Can you please help me with this
You will need different variables to track each pop up. And the create if logic to not let one trigger if the other triggers
Thank you for another great video! I made the form with this video, however, the delay is not working for me. I followed all the steps, but as soon as I get to the point to @ in my email the alert will show up.
Does anyone else has this issue?
Thank you again for all you do.
It is a goofy little setting. It works but the delay isn't long enough. You have to type pretty quick for it not to work. I would also test it not in preview and see if it works better for you.Thanks for watching!
Hi Shane thanks for the tutorial and can you make video for for color changes as per the expiry date
Color = if(date > expiredate, red, green)
Thanks for this! I have a 6 screen app, each team populates and saves their own page. do you have a suggestion on a popup or save confirmation to use? the streaming dots along the top do not seem to cut it? Thanks!
Katie I show a loading spinner in the video. ua-cam.com/video/UWy5I_MuIgU/v-deo.html
Hi Shane, what still bug me is when or why the Signature in "And(BlankImage Signature.image)" need to put ".image" whereby others just need to addressed their control name such as "EmailAddress"
Understood you have video about variables, but still I can't sort this out.
However it is cool video.
Thanks.
You never reference a whole control always .property
@@ShanesCows Yes, but how to differentiate or recognized, this command need to put the reference with their property and other command is just the control name, provided there is quick help on its selection as we typed. Thanks for prompt response, so cool. :)
Great video brother thank you
Happy to help
Hi Sean great video . I used the pop up message example when a form is submitted. Minor setback I have a unique field (checks for duplicate entries) that doesn’t work now any idea? It appears the pop up is initiating before the form data is being checked for errors. Thanks
Put the pop up formula in the OnSuccess property of the form not the button
Shane Young Thanks Shane
hi thanks you so much for your work great job if its possible would you mind make a serie about a sharepoint list to select a customer populate all the field when you select a customer then add the form in another sharepoint list it's an idea
what do you think about this?
Yikes that is a lot. I did do a video on SharePoint lookups that might help get you going.
Hello. How we create a pop-up screen with fields and a button to save those fields in a SharePoint list? Thank you
Use this video to make a pop up then you can put whatever you want on the pop up like your forms.
Hey Shane,
While formatting our consent button it shouldnt light up when the email address entered is not valid, so here is a quick update
If(And(Blank Image Signature.Image, Age >= 18, !IsBlank(Name), IsMatch(EmailAddress.Text, Match.Email)), DisplayMode.Edit, DisplayMode.Disabled)
Keep up the good work
Select multiple items using shift in Mac works; using control key it was not working.
thanks
Good to know!
Great video! Save button working great, but in my app there is required fields so need to add an error handler if one or more fields not filled in as found out that with this pop up the data won't save at all if one or more of these fields is empty, but won't inform the user. It appears as though it saved as expected. Any advice on this? Thanks
Maybe disable the button till all the fields are filled in?
@@ShanesCowsthanks Shane, will try that. Would that likely mean making an if error handler to cover each of the fields, which would make a very long piece of code or is there an easier way?
Great training video. Thank you.
Thanks for the awesome video! How can you get a popup when you are trying to delete an item in the gallery? I am unable to use "ThisItem" in the popup's button since its outside of the gallery's item
Use Gallery.Selected for the logic in the popup button :)
Shane, First off, thank you for sharing so many great tutorials. I've watched quite a few of them while hacking away at some apps for my company. One thing which would be awesome for you to cover is how to perform a join function on SQL tables within PowerApps. This would be great. Also, are you coming to the Microsoft Business App summit in July? Thanks.
Hi Don - What are you trying to accomplish with the join? I wonder if this video would help you. Ignore that I talk about SharePoint in the video. I think the concept would be exactly the same with SQL. SharePoint was just the data source I chose. ua-cam.com/video/43ekj5MlNJU/v-deo.html Does it help?
I'll check it out and let you know. I found an example on how to do it but your way will probably explain it more clearly. Again, appreciate the videos, keep them coming.
Your videos are amazing!!! Thanks for all the help!
Happy to help
Hi Shane, great video, I know you made this video a long time ago, but I wanted to highlight that the OnVisible creation of a new variable to capture the Peninput image signature value is not working anymore for the validation field since the Peninput.Image text itself is returning a new url every time we return to the screen even though no changes happened to it. Maybe you could suggest a workaround. Thank you and happy weekend ahead.
I noticed that too. This video may help: ua-cam.com/video/EACk5jlQ_jU/v-deo.html
But it is also not perfect.
@@conaxlearn8566 thanks mate
Shane,
I have a new request screen with three popups where I collect info ( when you click on popup button he open popup, user populate fields and on that page save button just hide popup ) and on same page I have one button where I patch all info from popups. I patch all forms collected though popups and I reset forms after that and navigate on requests. Problem is when I have multiple users logged and when they try to submit new request, I got info mixed from their requests and most likely overwrite data from one to other request.
Hi Shane. Your videos are awesome. How do I display a drop-down selection in Browse Gallery Section? Thanks in advance!
Do you want a drop down outside the gallery to be displayed in the gallery or have is so the gallery has drop downs.
Hey Shane, it's having a issue these days, it adds blank value in BlankImage on first load to screen and if we go to and fro it updates old value of penInput where as pen input has already been updated to a new value so it's not working anymore
Hey Shane, this is another excellent video but I'm having a problem. Rather than a consent button I have a submit button. Everything works great with the popup except once I hit the Close button the app gets stuck on "Getting your data" rather than returning to a blank form. Any ideas?
Are you with BoldZebras or PowerApps911? Im confused.
PowerApps911 evolved from Bold Zebras. So both. 🐶
Hi, Shane! Thank you for the video - always helpful!
I don't know if this question contextually belongs here or if this is an idea for a future video. What I am trying to do is have a notification for when someone is trying to remove a record from the parent table (in SQL back end) and it has child records attached to it. When the back end child table FK has Delete Rule set to "No Action", it won't delete the parent record, but Power Apps doesn't really treat this event as an error, therefore my IfError(RemoveIf(Source, Notification(...))) does not work. Any ideas on how to best handle this?
Yikes! I don't. :( Sorry
What if I wanted to pull a report? Can we add the collection feature?
How do you get Signature in reference to the Pen Input?
Try this video ua-cam.com/video/RFZfvTuDmP0/v-deo.html
Hey Shane, I love your videos and have learned a lot. I'm definitely a novice to all of this. Anyway, dumb question. I'm trying to create an app that won't let a person in unless they've been approved. I followed your approval vid and everything works great. Now in the app I'm trying to create a condition that says they can enter IF they have been approved on the sharepoint list. How do I create a statement that refers to the sharepoint list? It seems like it should be simple but right now I want to punch my screen. Thanks, guy and keep up the generous work! You help us lost souls!
Try this video ua-cam.com/video/0MB-z9cyFCQ/v-deo.html
@@ShanesCows Thanks dude!
Hey @@ShanesCows I ended up finding the solution in another video of yours :) ua-cam.com/video/Ap3_Ea9H8b0/v-deo.html. Thanks again!
Hello Shane, Thanks for such a detailed PowerApps tutorial. i have doubt if i would like to pass parameters in web URL (not in app url) and grab that in POwerapps. Is it possible? its requirement in my project. Any help would be great.
powerapps.microsoft.com/en-us/blog/powerapps-deep-linking/
Hi Shane. I'm trying to create a Popup based in time.
I used in Visible field: If(Value(Text(Now(); "hhmm")) > Value(1449); true; false)
but it's not working when I run the App.
Any idea? Thansk in advance from Brazil.
I am not sure. Is the issue maybe the time isn’t updating while the app is open?
@@ShanesCows Your assumption is correct. I solve the problem alreadi. Thansk a lot for the help!!!
Hi Shane
I'm having real trouble with what I think is a basic command.
I have a basic budget app which is working nicely. I want to add a popup warning box when the budget is nearing its limit.
My labels total and sum data from a main Excel table. These work.
I cannot get PowerApps to do a basic IF statement to then popup a warning box e.g. IF(Label with the spend => label with the total amount, "Overbudget", ""). Doesnt work with > or
Try Value(label.Text) and where do you have the if formula? Needs to be OnVisible or on a button
@@ShanesCows thanks Shane. For some reason, although I have used Value(label.text), I can do subtraction but I cannot use any > or < in an IF statement as it keeps telling me the label isnt a value.
But it does allow = in an IF statement, with no issues
I have also just tried a very simple formula by inserting two labels, updating the text to "100" in each. And then in a seperate label, doing a few sums. For some reason it is telling me the one label isnt a value (error type control) even though both are inserted as new labels and input identically. This is why my IF isnt working - for whatever reason the labels arent all converting to values (despite also doing the Value() formula).
hey hey, i just did for the invisible red email textbox: If(txt_email.Color=Red;true;false) works fine for me :D
Nice job
Any chance you know why a popup would work when previewing the app, but once it's saved and published to the sharepoint form the popups do not launch in actual use? If I go to edit the powerapp and preview it works every time in the preview mode.. it's driving me batty
I haven’t seen that. Maybe the default value isn’t getting set?
Hi Shane, has something changed recently with the peninput control? After resetting the input control and updating the context (to store the empty image value as JSON), for some reason the peninput image value changes (slightly), making it hard to keep track. Can you re-visit the app you demoed to see if it still works?
I will try Roy. I don’t have a lot of customer apps with pen so don’t get much practice
Great tutorial brother. On the topic of dialogs, I've been trying to come up with a way to create a popup in a gallery, to no avail, I have a column in SharePoint for "LineNotes" that I'm using in a repeating table gallery for receiving products. The text input is too small for a multiline mode and I don't want the end users to have to squint to see the text. so I thought a popup would do nicely. Any pointers would be awesome. Thanks again.
Hmmm. You could show the gallery.selected.field in a label outside the gallery. I am not sure. Never thought about this one. 🤔
@@ShanesCows Yeah, it's a real head scratcher for me too. I'm trying another approach, I'm gonna have the visible on the Gallery set from a varible to show hide based on a dropdown from a form on the same screen as you explained in "PowerApps Hide Button Based on User and other fun" around "23:00".
@@ShanesCows My solution was to make the gallery row size kinda dynamic, I put an icon in the row with "UpdateContext" onSelect and set the text input visible to varShowNotes.
Shane Is there a way to have different height/width settings when using multiple screens in PowerApps?
Give this a look docs.microsoft.com/en-us/powerapps/maker/canvas-apps/create-responsive-layout
Hi Shane, I think your way in the video doesn't work anymore. You can check the Power Apps Community, under your question: "How do you determine if Pen Input is blank?". @seadude and @grahampasmurf contributed to an updated solution following your initial idea, and it still works well now. And @newbie101 has got another way to solve the problem, also works really well and is quite simple, only problem is not able to adjust stuff like color, but it doesn't really matter. Anyway, this is a problem worth digging in and I am happy that we got solutions here.
Thanks for sharing. Not surprised it all changed. It felt like a hack when I did it.:)
Would you be able to demonstrate error handling?
I need to cover that one day. 😑
Hi Shane, I love your videos, keep up the good work!
About the formula for the "Check your email" label, isn't the following good enough?
Visible = And(!IsBlank(EmailAddress), !IsMatch(EmailAddress.Text, Email))
as we only want to show the label when the user entered something that does not match the format of an email address.
Thanks again for all your videos!
Looks like that would work. :)
You rock! Thanks
Thanks 😎
Hi Shane, what a great video!! I have one little question: how could I show a banner pop up (like what's app message and others apps, who drops from the screen) in my power apps? Just for explain, I want to every time I'm near from a store, my power apps show me a pop up "You're near from Store X, do you want to visit?", even if i'm not using the app on the moment. Can i do that? Thanks for your support!
No, sorry.
I tried using this for a checkbox and an image. Tried visible, onselect, uncheck, check in both the checkbox and the popup. So if the box is checked then popup(image), if the box is uncheck then no popup(image). So far I check and it pops up so halfway there. When I uncheck popup stays. Still working on that. BTW I love the videos!
Thanks let me know if you get it figured out or need a nudge in the right direction.
Hi Shane,
Love your videos.
I have question i am working on an app where i am using the formula below based on visible vs not visible and want to show a label based on wether the has information based on one section i want the box to dissapear but if there is no field with specific data then i wan the box to be visable. Is this function possible?
If(Or(IsBlank(TCampus.Text),If(And(!IsBlank(TCampus.Text),!IsMatch(TCampus.Text,"SC North")),true,false)),true,false)
Great video Shane. Very helpful.
Need a help with clearing a data card value conditionally.
I have two fields. One is a drop down field. If the value in the drop down field changes to "RED", then the other field data should be reset/cleared. I wrote this formula to the "Reset" property of the second field value but it works only on the new form and not on the edit form: If(DataCardValue11.Selected.Value="RED",true, false) Can you please help on how to make this work even for the edit form?
Look to use the Reset function instead.
Thanks for the reply Shane. Can you please help me how to achieve it using the reset function?
Hi, the email red text check conditional can be simplified to If(And(!IsBlank(TextInput1), !IsMatch(TextInput1.Text, Email)),true, false).
Thanks for sharing 🤩
@@ShanesCows Hi, thanks for the videos, they've helped me do my project for school. I have a problem though, I have one application that I have shared with my instructor. If I try to launch it from the Home page, it loads the old version of the app I have saved, but if I press the Edit button right next to it it loads the app in the studio to the version that I have built up until now. I'm worried that if I am asked to present my project, and I press Play (instead of Edit) it will load the first version of the application. Have you encountered this problem before? Do you know how to fix it? I can mention that I don't have duplicate apps, in fact I have only one app saved, I saved the application and logged off and logged back. I'm not sure that to do. Thanks in advance if you can help.
Hi, nevermind, I figured it out, I had to go through the additional step of publishing it.. now I wonder if my instructor is going to see v1 or v2, humph, humph. Thanks once again for the videos.