Power Apps Form Validation 👍 (Tutorial)

Power Apps Form Validation and data validation can be quite daunting and it is important to decide where the logic and business rules should be triggered. In this video tutorial we show an easy way to manage validations on an entire Microsoft PowerApps Form before it causes a great big red error on the top of the screen at the time of executing SubmitForm()
This method works on all data sources and allow for the native data source errors to still be active is well.
The Problem:
If some cards on an EditForm are marked as required they show an asterisk to inform the user that they are required. If one or more of these fields are blank at the time of submitting the form, the infamous "An entry is required or has an invalid value. Please correct and try again." is displayed, with quite aggressive failure messages on each card.
Solution:
Use the Valid property on the card and form to show the user which fields still have to be completed, as well as to prevent the form from being submitted.

[@aravindhr3638]

There's something to learn on PowerApps everyday! Understood many little nuances today. Thanks for sharing! Keep up the great work!!

[@UnkindledTarnishedMeg]

This is a great way to have more organized data validation - something I was pulling my hair out about! Thanks so much!

[@evebee4]

i have wondered how to get started on PowerApps, glad i came across your channel! very informative and simplified, thanks Dave!

[@DataSpinners]

Thanks Dave - forms validation is such a real world issue as it helps us to add business logic to our apps. I was doing this only today!

[@DavesTechTips]

Hey Rory thanks for the message and for pretending that you learnt something new (",)

[@filipfinrasek7641]

Thanks Dave, just started with power apps and power automate and your videos rock!

[@DavesTechTips]

Thank you so much for the feedback Filip, I am glad you find them useful!

[@russellnorlund1969]

A very clear and succinct explanation of PowerApps validation. Thank you Dave :-)

[@DavesTechTips]

Thank you for the feedback Russell, much appreciated and I am glad you found this useful 😀👍

[@honeytrippers]

just started the tutorial, you mention at the begin (and I think you mentioned it in the first video) using PATCH to commit data? Would be good to explain what PATCH is at the start of the video 👍 (....on with the video)

[@RicksterLuna]

This is my very first video from you and if you have other videos about powerapps properties like the ones you have here for valid, required, and other properties for different controls and how to manipulate all their properties, those videos would greatly help since there are still not a lot of informative videos on powerapps as compared to VBA where I'm more use to. Aside from that, I really enjoyed how easy it is to follow this lesson! Thank you!

[@PATRICKCHUAD]

very clear explanation. Thank you Dave!. I will use this knowledge to build my first power apps.

[@DavesTechTips]

Excellent, have great fun doing it! Thank you for the feedback, much appreciated.

[@gabrielaramirez8814]

Thanks so much, it was very helpful 🥰

[@jt9228]

Excellent video! Thank you!

[@Don_Modern_Ancestor]

Excellent Tutorials. Went through a few others before I found your set. Thanks...

[@DavesTechTips]

Thank you for the feedback Donald, glad you like them!

[@NickMoradkhani]

Great video Dave. Just to point that here the Asterisk validation wouldn't be an issue once we have the Submit button disabled until all fields completed :)

[@wahyudiwahyudi2353]

Thank you Dave... for Excellent tutorial PowerApps

[@DavesTechTips]

Glad it was helpful! Thanks for the message.

[@bossplayer1093]

Thank you so much, Dave. You saved me. 👍

[@DavesTechTips]

Thank you so much for the feedback, very happy to hear that you found it useful 😊👍🏻

[@GuruVideoAC]

Good one

[@DavesTechTips]

Thank you so much for the feedback Guruprasad.

[@gaborjenei5439]

Very useful video. Thank you, Dave!

[@DavesTechTips]

Thank you for the feedback, Glad you found is useful Gabor.

[@youngheart123]

very clear and succinct. Thanks!

[@DavesTechTips]

Thank you so much for the feedback, much appreciated.

[@mohamaddeera749]

AMAZING !!! Thank you so much ! Very appreciated....

[@DavesTechTips]

You're very welcome, glad you found this useful. This has really helped us to fully use forms.

[@kywg33]

Thank you David. May I know how can we only display the date instead of date+time in the field? Thank you very much.

[@edgarabud2721]

Good Job! Helpful.

[@DavesTechTips]

Thank you so much for the message Edgar!

[@biliatto]

Wonderful!

[@DavesTechTips]

Thank you very much Afonso, much appreciated man. 👍

[@richardpiazza1244]

Great video...helpful!!

[@DavesTechTips]

Thank you Richard, glad you found this helpful.

[@ryanmata10]

Thank you! This was a helpful video :)

[@DavesTechTips]

Thanks for the feedback, glad this could help you.

[@CalvinWongHKG]

thx bro saved the day

[@akdmkz9926]

you are a savior! I have wasting my time guessing what code to be use for blank fields in button, thanks for your video. now I have 1 thing to do, how can I include required on Signature(Pentool)? gonna find my own way but i hope you will give me an idea. LOL

[@DavesTechTips]

Thank you very much for the feedback, much appreciated. You can use the OnsSelect event on the PenInput to set a variable to pick up if someone clicked on it. Please let me know if you don't come right.

[@joannaanderson8669]

Thank you! This was a very helpful video!!

[@DavesTechTips]

Thank you Joanna, glad you found this helpful

[@csi4516]

Hello, thanks for the nice tuto. How could I for example implement more validation logic as for example if I need to reach one outside web service for some calculation and catch the answer and then decide the validation status according to those remote calculations? Kind regards.

[@honeytrippers]

looks like MS have change the default error message from "An entry......etc,etc,etc......and try again" to " is required" i.e. ExpenseAmount is required.

[@torbenandersen9352]

Great video. One question. How do you do validation against a list?

[@DavesTechTips]

Hi Torban, thanks for the feedback. Not sure I understand that you mean by validating against a list, could you give me more information?

[@xmwang829]

This's very well explained tutorial and Thank you Dave. I am trying to figure out why in my case, the 'lblErrorMessage" is not auto height and how to fix this. The Y (of Editform1)= lblErrorMessage.Y+lblErrorMessage.height.

[@Mrs_Boda]

time is taking as default..how can i make time madatory?

[@MikeSunTzu]

Hi Dawid, do you have a tutorial in adding a camera and preview photo to an existing power app please? The output is Sharepoint lists and I want to store the photo alongside the data collected in the app. The app data part is already done and the sharpoint list is already built/working. Thanks, Mike

[@DavesTechTips]

Hi Mike, that is a good idea. I think that might be a great idea for the popup component as well, to be able to just quickly grab a picture and store it somewhere. I will add this to the popup wish list. aka.ms/powerapps-popup

[@nicolascarrio8484]

OMG! you just simply cant realize how this video has help me!!! i would like to put more LIKE in your video (if KZbin would let me).. Thank you soooooooooooo much! And a question if I can: I need to make an IF in a error label (like the one you make) but the field contains options (a menu) and i cant make it work (for example): If(DataCardValue1.Selected = "Home" , "Error")... I Dont Know how to fix this.

[@DavesTechTips]

Thank you very much for the feedback Nicolas, much appreciated man and I am glad you found this helpful. If the control that you referring to is a drop down with a text array in it, then you should be able to do DataCardValue1.Selected.Value = "Home". If it contains a list of objects, then you would need to specify Selected.PropertyName that should be checked for the value of Home. Eg, Selected.Location="Home"

[@nicolascarrio8484]

​@@DavesTechTips I made a label that show error notifications (like the one you do in the video) with 4 formulas. But the resoluion gave me a "False" they appears in the order that i Wrote them. I need that they appears on top when they are "false" (the formula number 4 appears in the line number 4). Is there a way to do it? If(DataCardValue2.SelectedDate < Today(),"Line 1") & Char(13) & Char(10) & If(DataCardValue2.SelectedDate = Today(),"Line 2") & Char(13) & Char(10) & If((DataCardValue5.Text) = "Homeoffice", "Line 3") & Char(13) & Char(10) & If(DataCardValue1.Selected.Value = "Nico" , "Line 4")

[@DavesTechTips]

@@nicolascarrio8484 As as test I put the following in a formula: If( Today() < Today(), "Line 1" ) & Char(13) & Char(10) & If( Today() = Today(), "Line 2" ) & Char(13) & Char(10) & If( "Homeoffice" = "Homeoffice", "Line 3" ) & Char(13) & Char(10) & If( "Nico" = "Nico", "Line 4" ). The result is Line 2 Line 3 Line 4 ...which seems to be correct.

[@nicolascarrio8484]

@@DavesTechTips thank you again! I will test it!

[@Gbd279]

Very useful, thanks.

[@DavesTechTips]

Kessy Similien , thank you. Would like to see how you use it in your applications

[@Gbd279]

@@DavesTechTips I added it as a condition to my patch statement. So now it prevents saving without required fields. Overall I handle validation a bit different. I have customs rules I need to test for so I store each rule as an object in a collection with a property called "Pass". Then I filter on that property on Save. If there's anything that's Pass=False left in the collection, I prevent the save.

[@Steggman]

I know I'm a year late on this one, but I'm new to PowerApps and loving your guides! Is it possible to check and show an error if the selected date and time is greater than the current date and time? (to stop a user submitting a future date and time) I'm trying a few things here, based on your lesson here, but i cant quite crack it :(

[@PeterPanQuails]

Try this: If(DateValue1.SelectedDate > Today(), "Cannot be future date")

[@Steggman]

@@PeterPanQuails thanks for that. Good thinking, that looks like it should work. I'll give it a try.

[@siyandakhanyile210]

Is it mandatory to use a form before we can try and implement validation on powerapps?

[@kmuralikrishna1582]

Really appreciate.. What is char(13) and char(10)

[@bavajidoriginti2016]

Hi sir how to validate mobile number with otp let me know sir

[@LukaDontSwitch]

Nice Walter White