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
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.
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. 🙃
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.
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.
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.
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.
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. :)
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
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!
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
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.
@@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.
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
@@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
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.
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.
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
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.
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 :)
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
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.
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.
@@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.
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. :( th-cam.com/video/mwXnJUkTug0/w-d-xo.html
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
Thanks Douglas and good luck!
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.
Thanks Chris! 😎
Thank you Shane. This really refreshed my memory on data validation
Cool
Thank you! Very useful video!
You are welcome!
IsMatch video - YES. And thx for another great video Shane :)
You are welcome Franks. Thanks for the feedback.
I would love an IsMatch video (and especially if it includes a very quick tutorial on regex expression syntax?) Appreciate all your work!
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. 🙃
@tracyOsimowicz - I am going to turn this comment into a video for Monday. You will be famous. 🤩
@@ShanesCows Haha, oh my goodness! What an honor XD Happy Friday to me!
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.
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.
Thanks 🤩
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.
Change the controls mode from Parent.Mode (or whatever it is) to Dropdown.Selected.Value = "Yes" should do the trick.
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 || 🙂
Always so many little things to learn. 😎 I
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.
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. :)
hey Shane Thanks for sharing those Tips... very Usefull to make better UX
Happy to help. Have a great day. 🐶
Hello from Indonesia... Really helpful video for me :) just learning the powerapp.
Question, is it possible to record the data to Excel or Sharepoint?
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
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!
Roy I am sorry, I don't follow what you are looking for.
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
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.
@@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.
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
@@ShanesCows oh okay. Thank you for the help. I'd try this out
@@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
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.
Try this video th-cam.com/video/WlWT0lWTGU8/w-d-xo.html
Thank you Shane (one more time!!). I owe you the beer!!
Thanks Diego. One day we will meet, one day. 😎
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.
Can you do this in forms to validate submitform(form1)?
Use this to disable the Submit button unless all of your criteria is met. 😎
Yes! IsMatch with custom regex... maybe some help from AI friends
Like so? th-cam.com/users/shorts3q-x9n16wD8 😎 Thanks for the reminder.
Hi
How can I validate that the new data be equal or greater than the data already stored in a data card ?
an ismatch video would be great (unless you've already done it, in which case thank you!)
Great suggestion! I will put it on my list. Thanks
hello, does this work for a from as well? I cant get mine working.
It should. What are your struggling to get working? Share your formula.
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
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.
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 :)
@@ShanesCows Thank you!!!
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
how you create a popup when exist a error on datafield?
what if I want to add a comment that you need to add text to clciked submit?
Whole video please.
Sorry, what do you mean whole video?
@ShanesCows Sorry, I meant the whole video on if match topic.
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.
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.
@@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.
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. :( th-cam.com/video/mwXnJUkTug0/w-d-xo.html