Validate Inputs, Warn Users, and Disable Buttons in Power Apps

[@dougydoe]

The timing is just impeccable. Right in the middle of a project and this has given me more ideas for validating input fields. Yes, the IsMatch video is needed, Shane... Thank you

[@ShanesCows]

Thanks Douglas and good luck!

[@chrisundery6132]

Great as ever Shane. Literally had an accidental entry the other day as the user missed a field that should be set to mandatory. Can now easily fix. Keep them coming.

[@ShanesCows]

Thanks Chris! 😎

[@jonathangagnon7652]

The timing on this is great! I'm trying to control data being put into a PowerApp and visualizing it in PowerBI...well timed. And your answers are more useful than ChatGPT (Yup, I used it as an aide) And yes, please, an in-depth isMatch video would be appreciated.

[@TracyOsimowicz]

I would love an IsMatch video (and especially if it includes a very quick tutorial on regex expression syntax?) Appreciate all your work!

[@ShanesCows]

Noted. In the meantime Tracy I would ask ChatGPT to help write your Regex expressions. It is pretty good at those types of things that us mortals have no clue how to do. 🙃

[@ShanesCows]

@tracyOsimowicz - I am going to turn this comment into a video for Monday. You will be famous. 🤩

[@TracyOsimowicz]

@@ShanesCows Haha, oh my goodness! What an honor XD Happy Friday to me!

[@oluwatobipaul6171]

Thank you Shane. This really refreshed my memory on data validation

[@ShanesCows]

Cool

[@franknielsen3219]

IsMatch video - YES. And thx for another great video Shane :)

[@ShanesCows]

You are welcome Franks. Thanks for the feedback.

[@manojroy8862]

Really, helpful video to understand the basics of controls and work to it, this would also help the freshers to understand the properties of the controls and how to implement it.

[@ShanesCows]

Thanks 🤩

[@GreyDob]

Another great video Shane, I just noticed you used AND and OR functions, didn't know that was working, I was still using the && and || 🙂

[@ShanesCows]

Always so many little things to learn. 😎 I

[@frenamakenson9844]

hey Shane Thanks for sharing those Tips... very Usefull to make better UX

[@ShanesCows]

Happy to help. Have a great day. 🐶

[@jdwillingham4140]

Hey Shane. Thanks for all of the fantastic instructional videos. I am trying to use a dropdown field to enable another field to become editable in a form. I was trying to use this video to assist me. Essentially, I want the dropdown to be used to ask a question “Change to Title or Description?” With the options being “Yes or No” and based off that answer it will allow those fields “Title” and “Description” to become editable fields on the form instead of being greyed out and viewable if the answer is “yes”. Any assistance you could provide will be greatly appreciated.

[@ShanesCows]

Change the controls mode from Parent.Mode (or whatever it is) to Dropdown.Selected.Value = "Yes" should do the trick.

[@ophemtech]

I must confess that this is really an angel coming to my aid cuz i just hitted this validation problem. though if i had continued with using my head and tweaking things, i couldve gotten it but maybe not as better as you taught it here. but i really do have a problem, i seem to not be able to create a dataverse or sharepoint, and i still dont know why i can't create that, is it that i dont have access to do so or what do you think could be the problem. but anyways, thank you for these tutorials, its life saving

[@ShanesCows]

James do you need to add a connection to SHarePoint or do you need to go to SharePoint and create a site. Sorry, I don't follow what you mean by cannot create a SharePoint.

[@ophemtech]

@@ShanesCows uhm the issue is, I haven't been able to connect to a SharePoint. And from your videos it seems you create a SharePoint site which I don't know how to do. So I'm clueless on how to do that as well as connect to dataverse created by me.

[@ShanesCows]

James from Office.com click on SharePoint and should be able to create a new site. This would be your own SharePont site. Then you could create a SHarePoint list there. Finally you would add that as a connection to your Power Apps app. I wonder if my free 101 class would help you with the basics? training.powerapps911.com/courses/power-apps-and-power-automate-getting-started

[@ophemtech]

@@ShanesCows oh okay. Thank you for the help. I'd try this out

[@ophemtech]

@@ShanesCows I don't know if I can reach out to you personally maybe by mail or Skype or something. Just in case I wanna deliberate or need a senior advice on how tos and best practices

[@RoyAliKhairan]

Nice video as always--i always smile every time you correct your own words. Anyway, it seems i need your assistance here! I want to build an app to take care of the exit clearance process in my office. I do watch a lot of videos on how to build an app using this PowerApps but I still couldn't figure out how to make this exit clearance into the app. Any advice from you would be very much appreciated. Cheers!

[@ShanesCows]

Roy I am sorry, I don't follow what you are looking for.

[@dvk003]

Thank you Shane (one more time!!). I owe you the beer!!

[@ShanesCows]

Thanks Diego. One day we will meet, one day. 😎

[@juliennunes814]

Great video! Though since the lblWarnEmail only shows up when the email is invalid and not blank, if the email is blank the user could actually click on the button Thats a demonstration so no one cares but it might surprises some people that copied pasted haha

[@semajnitram]

an ismatch video would be great (unless you've already done it, in which case thank you!)

[@ShanesCows]

Great suggestion! I will put it on my list. Thanks

[@lwhite3225]

Great stuff! I use form.valid to set display mode for buttons. Does form.valid pick up IsMatch errors? Or do I need to add that to the button's display mode property? Not sure this makes sense to anyone but me.

[@ShanesCows]

I haven't tried but I am going to guess that Form.Valid does not identify IsMatch errors as they are logic outside of the Forms own logic. My guess. :)

[@angelmingkem7275]

Hello from Indonesia... Really helpful video for me :) just learning the powerapp. Question, is it possible to record the data to Excel or Sharepoint?

[@ShanesCows]

Yes. If you are brand new I recommend starting with the free 101 class here training.powerapps911.com/courses/power-apps-and-power-automate-getting-started

[@anthonyapodaca1332]

Yes! IsMatch with custom regex... maybe some help from AI friends

[@ShanesCows]

Like so? kzbin.info3q-x9n16wD8 😎 Thanks for the reminder.

[@espiemar1661]

How do I find a required field that is not allowing the submission of my forms? I have combed each field, I have sorted my fields with tabs and they are only required when they are visible

[@josecarlosbenitezmeyer645]

Hi How can I validate that the new data be equal or greater than the data already stored in a data card ?

[@MsNoeynono]

Can you do this in forms to validate submitform(form1)?

[@ShanesCows]

Use this to disable the Submit button unless all of your criteria is met. 😎

[@zekeskinner3346]

Hey Shane, How would I disable a button with a form field instead of a table field. I am using powerapps to automate an application into a sharepoint list and I need to make it to where the data field that is required will not allow me to continue in my application without filling out that portion. I have tried the IsBlank and IsEmpty but neither are working.

[@ShanesCows]

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

[@sagaisaac]

how you create a popup when exist a error on datafield?

[@sameerulhaq4066]

what if I want to add a comment that you need to add text to clciked submit?

[@Mary-gw8ur]

hello, does this work for a from as well? I cant get mine working.

[@ShanesCows]

It should. What are your struggling to get working? Share your formula.

[@PaulHowley-y7e]

Having great difficulty getting IsMatch to work correctly with a time in HH:MM format, I am using a gallery to both view and edit data in a SP List - any help would be appreciated.

[@jaspreetsingharora7070]

Whole video please.

[@ShanesCows]

Sorry, what do you mean whole video?

[@jaspreetsingharora7070]

@ShanesCows Sorry, I meant the whole video on if match topic.

[@rebeccathorn-pena9108]

I'm needing to validate a date field by radio button choice. If the radio button choice = "No", date must be after today, if the radio button choice = "yes", date must be before today. Any help is greatly appreciated.

[@ShanesCows]

If((Radio.Selected.Value = "No" And datepicker.selectedDate > Today()) Or (Radio.Selected.Value = "Yes" And datepicker.selectedDate < Today()), "Good", "Bad") Something like that should get you started :)

[@rebeccathorn-pena9108]

@@ShanesCows Thank you!!!

[@TessAlmond]

Can anyone out there give me some insight into this issue? On Submit, it says that 'field_3" is required. all of the fields on the form have been completed, and none are named field_3. By default the MI field has Displayname: DataSourceInfo([@AccessRequests],DataSourceInfo.DisplayName,"field_3") Other fields likewise have display names of field_1, field_2 etc. But again, all fields have been populated, so this issue is baffling me.

[@ShanesCows]

Tess it sounds like your Data Source has a field named Field_3 and the data source is required. I would start by checking that. I assume it is SharePoint? That is a quick thing to check. If you find it then you can decide do you want to change the field in SharePoint not to be required or add the field to your form in Power Apps.

[@TessAlmond]

@@ShanesCows None of my fields are named 'Field_number" . The datasource (SP list) fields are appropriately named, as are the fields on the form. In PowerApps on this field and a few other fields, the DisplayName property of the datacard: DataSourceInfo([@AccessRequests],DataSourceInfo.DisplayName,"field_9") That is the only place I see reference to field 9.

[@ShanesCows]

Tess watch this video real quick. It will show you how to see your columns real names, you most likely imported from Excel and the system names are field_3 even though you think it is Department. :( kzbin.info/www/bejne/o6i7n32LoLmonZI