PowerApps Conditional Formatting and Popups

[@davidcaulton9758]

Great video, lots of useful bits of info.

[@ShanesCows]

Thanks. What else can I cover to help you?

[@davidcaulton9758]

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.

[@ShanesCows]

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

[@azitamousavi3728]

Is it possible to create training video about an app for tracking activities by week for a period of four weeks?

[@beancoffee6907]

hey Shane can u do a video to add address details dynamically & with maps to visualise the address too. #awesomeshane @boldzebras 😉

[@carinchapman5181]

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!

[@ShanesCows]

Awesome and good luck

[@michaelshelnutt3534]

Dido here

[@IvanaMilovanovic994]

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!

[@ShanesCows]

Thanks for sharing. Lots of different ways to do the same stuff. 😊

[@nihar4713]

amazing

[@taylorlevine2082]

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.

[@ShanesCows]

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! :)

[@yasarena]

I have enjoyed your entire series on the Consent form

[@ShanesCows]

Awesome!

[@cirnobaka7313]

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!

[@ShanesCows]

Glad to help. :)

[@keerthikakiki7936]

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.

[@ShanesCows]

Yup. :) Thanks for sharing!

[@HariMuddada]

really helpful this one Shane. Thank you. Looking for more videos,

[@ShanesCows]

Awesome, thank you!

[@TheDistractionStudio]

Accidentally found your channel yesterday and I’m addicted. Excellent content. Thank you very much!!

[@ShanesCows]

Awesome! 😻 Glad it is helping and thanks for the feedback. If you have ideas for future videos let me know. -Shane

[@terrisepulveda627]

OMG! Powerapps Teacher and Rock Star all in 1..............Thanks Shane!

[@ShanesCows]

Glad to help. (You made me blush)

[@vishalnagda7]

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.

[@KiranKumarTalikoti]

Shane you are the Power Star ! Great videos and thank you so much

[@ShanesCows]

Glad to help. 😀

[@NicatBehbudov]

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))

[@Emmanuel-er7zn]

Love these Videos! In the latest version of power apps theres no delayed output feature for labels, is there any work around to this thank you .

[@ShanesCows]

Nope. Those modern controls are still just missing some key features. :(

[@kyledrumm5173]

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.

[@freedomfighter8074]

Thank you @Kyle Drumm, your expression worked great for me.

[@princeranthaka6096]

It worked very well

[@freedomfighter8074]

Awesome video!! I am new to Powerapps and learned a lot. Much better than Microsoft tutorials.

[@ShanesCows]

Thanks

[@ziadhamandi3595]

Great Videos Shane. Simple, useful and to the point.

[@ShanesCows]

Thanks! I use these concepts in just about every app.

[@yemataamede9752]

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.

[@ShanesCows]

Nice job! Glad you got it.

[@mumind23]

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.

[@sarathchandrank.s4036]

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.

[@Majalis2024]

I have the same issue.

[@dahzryn]

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.

[@waynedalton3212]

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!

[@ShanesCows]

Good call Wayne. I do it and teach this more correct way these days

[@augustomacedo512]

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!

[@ShanesCows]

Awesome. Love it. Thank you.

[@jeremycrookston3347]

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!

[@ShanesCows]

Hey Jeremy. I haven't tried anythign clever here but I don't think I have any good guesses. Sorry

[@Fernando_Calero]

Late to the party but excellent training, thanks Shane! and also to the contributors below!

[@ShanesCows]

Never too late. 😎

[@tomlaurijssens7014]

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.

[@ShanesCows]

Thanks. And I agree Tom, hiding the controls is the way to go.

[@PradipPardeshi]

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?

[@ShanesCows]

Power Apps has 300+ data sources so you can store it almost anywhere you want. Maybe this video will help kzbin.info/www/bejne/g5TPe5KFbq2pgLM

[@cedriclabuschagne5978]

@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 ?

[@ShanesCows]

There is an exit function but that will only close out o powerapps. Or close the browser

[@robbe4711]

You can also work with "OnChange" on the PenInput field. Just set a status variable and set it to "" by reset.

[@ShanesCows]

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 KZbin doesn’t let me edit videos after the fact.

[@Fernanda-uh7iz]

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?

[@ShanesCows]

Yes you can! Do a LookUp to get the record you want to show.

[@Fernanda-uh7iz]

@@ShanesCows 😍 thank you so much!!

[@АбикошБалапан]

Your videos are very helpful, Thank you Shane, you are the BEST!!!

[@ShanesCows]

Glad to help. 😀

[@Productivity365]

Hi Shane, the way you explain is awesome. Thanks

[@deepak3405]

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.

[@ShanesCows]

I will add it to the list. Thanks!

[@katielux357]

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!

[@ShanesCows]

Katie I show a loading spinner in the video. kzbin.info/www/bejne/i4jcZnyVgtp8nbc

[@IvySoe]

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?

[@ShanesCows]

I think so but it is has been a long time since i tried.

[@dynamics365powerplatformle4]

Very informative and useful tutorials. Thank you so much Shane.

[@ShanesCows]

Happy to help.

[@mblherry]

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.

[@ShanesCows]

Yes sir. You are exactly right. I figured it out a couple days too late. 😀

[@cedricbouve]

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?

[@ShanesCows]

Yikes that is a lot. I did do a video on SharePoint lookups that might help get you going.

[@macdalinemathye958]

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?

[@martindasdas5834]

Hi Shane thanks for the tutorial and can you make video for for color changes as per the expiry date

[@ShanesCows]

Color = if(date > expiredate, red, green)

[@smarie8560]

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

[@ShanesCows]

Put the pop up formula in the OnSuccess property of the form not the button

[@smarie8560]

Shane Young Thanks Shane

[@djamillakhdar-hamina3824]

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.

[@ShanesCows]

Awesome !

[@FrameFreaks88]

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.

[@ShanesCows]

Thank you.

[@thompsonnickc]

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?

[@ShanesCows]

Yes. Use the OnChange of the Radio control to trigger the variable to show the pop up.

[@lilili6229]

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.😀

[@mikse7]

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).

[@ShanesCows]

They may have changed the sig piece. I haven’t tried it in a long time. If you take it out does it work?

[@TalkinPoliticsNetwork]

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]

Hmmm. You could show the gallery.selected.field in a label outside the gallery. I am not sure. Never thought about this one. 🤔

[@TalkinPoliticsNetwork]

@@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".

[@TalkinPoliticsNetwork]

@@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.

[@HareKrsn213]

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.

[@ShanesCows]

powerapps.microsoft.com/en-us/blog/powerapps-deep-linking/

[@JordivanKaam]

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 !

[@ShanesCows]

Sorry for the delay. This video shows how you can use IsEmpty to check a gallery. kzbin.info/www/bejne/rJO1lXmcppqneJo

[@vinayayinapurapu]

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

[@ShanesCows]

Glad you liked it! 😁 I try to make it not boring.

[@gouthamreddyb5630]

Hi Shane. Your videos are awesome. How do I display a drop-down selection in Browse Gallery Section? Thanks in advance!

[@ShanesCows]

Do you want a drop down outside the gallery to be displayed in the gallery or have is so the gallery has drop downs.

[@joshuaerwin8523]

Shane Is there a way to have different height/width settings when using multiple screens in PowerApps?

[@ShanesCows]

Give this a look docs.microsoft.com/en-us/powerapps/maker/canvas-apps/create-responsive-layout

[@lymitutit3046]

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.

[@ShanesCows]

Yes, you control has a property called ToolTip. Set the text to be blank if Edit mode and your message if disabled.

[@lymitutit3046]

@@ShanesCows Thank you.

[@christianofienbor4024]

Self explanatory video. Thank you for this.

[@kirillperian]

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?

[@ShanesCows]

Yikes! I don't. :( Sorry

[@michaeldacampora5467]

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

[@ShanesCows]

Use Gallery.Selected for the logic in the popup button :)

[@davidflockton4296]

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

[@ShanesCows]

Maybe disable the button till all the fields are filled in?

[@davidflockton4296]

@@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?

[@tatatiti5125]

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]

You never reference a whole control always .property

[@tatatiti5125]

@@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. :)

[@kindumelese4335]

Hi Shane, Thanks for sharing your video, when I used powerapps form convert to pdf the form has a dynamic change logo based on the department and on HTML format how to set this variable image(logo) based on the department, means if departmen=A, image=img1, else if department =B, imgage=img2, else if deparment=C, image=img3....if you have an Idea if the condition on powerapp html develop share with me. Thanks a lot!

[@ShanesCows]

When you create the HTML in POwerApps you are just making text. So you could have an if statement in the middle of your HTML to send different values.

[@coolname-pf2xh]

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.

[@conaxlearn8566]

I noticed that too. This video may help: kzbin.info/www/bejne/e3KmnGigobaSoLc But it is also not perfect.

[@coolname-pf2xh]

@@conaxlearn8566 thanks mate

[@ArkWorksCNC]

Another great video Shane. I came here looking for something else and learned 2 or 3 other things. What I was looking for is how to identify when a Patch function errors out. In my case, when users enter duplicate values in a field where I'm requiring Unique Values via a SharePoint List setting. Have you done anything on that yet? Any thoughts or suggestions? Again the scenario is, Users Click Submit (activating patch) and the patch doesn't go through because of a duplicate record. Since I'm not using SubmitForm, there's not feedback whatsoever to let them know it failed. I want a popup to tell them what the Patch error-text was and have them go fix it before re-submission

[@ShanesCows]

Use the Errors function. If it is empty all went well if not the error will be in the table. Bonus I also talk about duplicates here kzbin.info/www/bejne/d6GWkHiXbq1rmJI

[@ArkWorksCNC]

@@ShanesCows Thank you sir

[@darkspl]

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?

[@ShanesCows]

You need to write an if statement that checks they all match the values you want.

[@azitamousavi3728]

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.

[@ShanesCows]

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!

[@mhg1608]

Hello. How we create a pop-up screen with fields and a button to save those fields in a SharePoint list? Thank you

[@ShanesCows]

Use this video to make a pop up then you can put whatever you want on the pop up like your forms.

[@victoralonso1189]

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!

[@ShanesCows]

No, sorry.

[@roygilboa]

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?

[@ShanesCows]

I will try Roy. I don’t have a lot of customer apps with pen so don’t get much practice

[@PauloStecklow]

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.

[@ShanesCows]

I am not sure. Is the issue maybe the time isn’t updating while the app is open?

[@PauloStecklow]

@@ShanesCows Your assumption is correct. I solve the problem alreadi. Thansk a lot for the help!!!

[@AdiCristea]

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!

[@ShanesCows]

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

[@SA-kt3wt]

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]

Try Value(label.Text) and where do you have the if formula? Needs to be OnVisible or on a button

[@SA-kt3wt]

@@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).

[@SandipPatil009]

For Email Validation is used this formula, If(IsBlank(EmailAddress), false, If(!IsMatch(EmailAddress.Text, Email), true, false))

[@ShanesCows]

Thanks for sharing

[@spruce1509]

Hi Shane, your videos have been incredibly useful! I have an app that has signature boxes your method for hiding the submit box seemed to work although I had to have the variable set by an invisible timer after 1 millisecond as the onvisible didn't seem to work. Now, it doesn't work at all. When the variable is set, the blank peninput image link also changes by one or two digits so that the variable and the blank image are never the same. Any ideas what I can do?!

[@ShanesCows]

Sorry haven’t ran into that Sam

[@spruce1509]

@@ShanesCows no worries, I think it's a fault so I should probably try and speak to Microsoft. Thanks though, my entire app is based off your videos, you've been a live saver!

[@famdevreugd6770]

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!

[@ShanesCows]

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. 😀

[@davidmay8240]

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.

[@ShanesCows]

David you need to add logic at each step that counts and saves days before you change the status. I would use patch function

[@jzpato]

Hey Shane! awesome work mate, thank you since you've saved me from frustration many times! One quick question, my BlankImage variable equals the Signature.Image address but changes the last digit by one. Any idea why is this happening and a workaround?? Thank you again!

[@ShanesCows]

Signature is weird for sure. Every time I play with it I shake my head. Check and see if the Signatures Control doesn’t have any new properties for checking if it changed.

[@oushammour]

I am facing the same issue ! this is so weird, did you find a solution for it ?

[@paulgreen2372]

I had the same issue when I added this to my already built screen, I added a new screen and just had the pen input and a couple of labels and it worked fine. I went back and added labels to show both the variable value and the pen input, the first time I navigated to the page the variable was blank but the pen input gave the image value. I navigated away and back i could see both labels showing values but variables last 2 digits was always 2 less. I added a button to run the UpdateContext manually and both values matched. Seemed like the pen input didn’t provide an image value quick enough for the variable to be updated on the first navigation, I had many other things going on the page so could be why, to fix I added a timer control to run the UpdateContext command after a few milliseconds and the values match every time I navigate to the screen and when the pen input was updated they didn’t match, which was the desired result.

[@isaiaguillon9878]

Shane, great videos!!! I have a question, how could I show a warning pop up in power apps? I have the following scenario: i have the following drop down field: - Policy (PO) - Procedures (PR) - Work Instruction (WI) Then I have another text field where the users enter the ID of the document which consist of XX-XX-###, the first two characters is the type of document from the drop down, so basically I want to make sure the user is entering the right information. Ex: if the user selects Policy (PO) from the drop down and then types PR-XX-001 it will show the warning because the user should write "PO" instead of "PR" I have tried IsMatch but it does not allow me to compare a field to another field using contain in the formula.

[@ShanesCows]

What is your code? You should be able to compare the two fields?

[@kustac2657]

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.

[@shondataliaferro285]

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?

[@phanipatil3286]

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]

Look to use the Reset function instead.

[@phanipatil3286]

Thanks for the reply Shane. Can you please help me how to achieve it using the reset function?

[@thulsadon]

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.

[@ShanesCows]

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. kzbin.info/www/bejne/amTInJ1rgtGBgLc Does it help?

[@thulsadon]

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.

[@aryansharmaindia]

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

[@aliciadegouveia3229]

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)

[@louismartini6983]

Awesome vid - LOTS of useful stuff.

[@ShanesCows]

Thanks 🙏

[@louiscutmore]

Awesome stuff Shane, thank you

[@ShanesCows]

Glad it helped.

[@wilsonrojesh]

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

[@ShanesCows]

You will need different variables to track each pop up. And the create if logic to not let one trigger if the other triggers

[@jekisca]

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

[@ShanesCows]

I haven’t seen that. Maybe the default value isn’t getting set?

[@anseldsouza4186]

Very Helpful and easy to understand

[@ShanesCows]

Cool. Glad it helped

[@michaelshelnutt3534]

Are you with BoldZebras or PowerApps911? Im confused.

[@ShanesCows]

PowerApps911 evolved from Bold Zebras. So both. 🐶

[@priyavartsingh8564]

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

[@ShanesCows]

That I don’t know. Sorry

[@FumbDucker]

Would you be able to demonstrate error handling?

[@ShanesCows]

I need to cover that one day. 😑

[@nbincompliance6436]

Shane Great Video... I'm going through them 1 by 1 one... my ultimate goal is to create a form that employees can enter data - that data then goes to a sharepoint list, the addition of the data to that list triggers an approval flow, and then when approved, all the info gets populated in another 'completed' list... ;-) think i'm on the right track?

[@ShanesCows]

Sounds perfect! I also think I have all of those pieces or close in video.

[@elphasluyuku4167]

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

[@fletchergrimlock6885]

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!

[@ShanesCows]

Try this video kzbin.info/www/bejne/Zn6lXq1vmN55ebM

[@fletchergrimlock6885]

@@ShanesCows Thanks dude!

[@fletchergrimlock6885]

Hey @@ShanesCows I ended up finding the solution in another video of yours :) kzbin.info/www/bejne/d6GWkHiXbq1rmJI. Thanks again!

[@onalem-6810]

Hi Shane, is it possible to change the table colour color font using conditional formatting

[@ShanesCows]

Yes. Just use an If formula in the color property

[@onalem-6810]

Thanks man, can you do a tutorial for chart on powerapp form? Looking forward on it in the future!!! All the best!!!

[@jeromelouvel732]

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!

[@ShanesCows]

Looks like that would work. :)

[@claudiavidican]

Hi, the email red text check conditional can be simplified to If(And(!IsBlank(TextInput1), !IsMatch(TextInput1.Text, Email)),true, false).

[@ShanesCows]

Thanks for sharing 🤩

[@claudiavidican]

@@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.

[@claudiavidican]

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.

[@rachelschreiber8146]

What if I wanted to pull a report? Can we add the collection feature?

[@maanalshraky1]

Thanks you are the best, no question :) Thanks

[@ShanesCows]

You're welcome!

[@殷晓峰-b5s]

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.

[@ShanesCows]

Thanks for sharing. Not surprised it all changed. It felt like a hack when I did it.:)

[@hitasajil3869]

Hi shane, one quick quest: If I put non standard email format and click form default save button then i guess form get saved, though there is error warning "invalid email format". How do i fix this?

[@ShanesCows]

Set the button to be disabled if the email is not valid.

[@hitasajil3869]

can we disable default save button in share-point, how? plz see the image: ibb.co/g6NOD9 ( I dont want form to get saved if validation failed)

[@hitasajil3869]

I figured out: for others who facing problem like me: click the data card, go to advance option and put IF condition in required validation field.

[@AlbertodaSilva1972]

How do you get Signature in reference to the Pen Input?

[@ShanesCows]

Try this video kzbin.info/www/bejne/iHe9l6mKqqmghpI

[@srednatube]

Hi, Great video and tutorial. :-) The Pen check is not working for me. I have tried the BlankImage variable and other solutions, but not working. The BlankImage variable set in Screen OnVisible is allways empty. No Image Url in it. Are there any new solutions to check the pen control?

[@srednatube]

Hmm, looks like the pen image is refreshed after the app has loaded and then the blank variable will differ from the image from the start. Maybe this is a browser problem. The app loads and the it is resized to fit the screen.

[@ShanesCows]

Interesting. I have done pen in a while. If I get a chance I will check. What if you use a timer to delay the load of the variable?

[@srednatube]

Shane Young Hmm, that was a smart tip. I will test with a timer😊👍