#PowerApps #DataValidation

This video on Power Apps form data validation tutorial is a step-by-step tutorial on applying data validation to Power Apps forms. We will cover various data validation scenarios for Power Apps form control which includes required field validations, conditional data card validations, pattern matching validations, date validations and much more. I will cover the usage of the IsMatch() function in Power Apps to validate several different data validation scenarios.

Video covers the following:
✅ Required field validation
✅ Date range and weekday validation
✅ Pattern matching validation
✅ Conditional data based card validation
✅ Number only / no decimals validation
✅ Length based validation

Links:
IsMatch, Match, and MatchAll functions in Power Apps – https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-ismatch

Table of Contents:
00:00 – Intro
00:37 – SharePoint list walkthrough
01:32 – Required field validation
03:52 – Conditionally add required field validation
05:44 – Number only validation
12:25 – Fixed length validation
13:42 – Data based pattern matching validation
17:30 – Date range validation
18:32 – Weekday validation
19:14 – No decimal validation for Number column
20:04 – Disable submit button if validation errors
22:12 – Unique data validation in data source
23:26 – Subscribe

31 Comments
  1. How To Excel 4 months ago

    Looking forward to seeing this, but to be honest I think I've mostly abandoned using forms and prefer to spend a little more time upfront building my own for the added customization.

    What are your thoughts on forms?

  2. B K 4 months ago

    Reza, Thanks again for the great tutorials. I was wondering if there is something similar to Page.IsValid (in asp.net) rather than checking each and every control in the if statement? (especially for a form with lots of controls). Or also like in erstwhile VB, can we have all the error label named the same thing (this can be a workaround to the problem)?

  3. Sundra Pillay 4 months ago

    Thanks Reza for the great tutorials have a great New Year

  4. Teresa Agustin 4 months ago

    Happy New Year Reza! Thanks for another fantastic video. I knew some basic data validation techniques, but this really takes it to the next level when it comes to complex scenarios. Rather than an If statement on the Submit button, would it be possible to use the form.valid internal property in this scenario to dictate the display mode of the button?

  5. Davide Mercadante 4 months ago

    Loved this video! Watching it I had some nice new ideas in mind for my next app. Glad to learn from such pro

  6. Maximilian Hofmann 4 months ago

    Thanks again for a great video! It’s more or less the same way I handle it in my forms.

    I have also created a Power User Community Idea to customize the isvalid property of a form – I think it would be great to have the possibility to modify this by an easy way:
    https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Forms-field-only-valid-when-isMatch-is-true/idi-p/495028

  7. Jim Fitch 4 months ago

    Another terrific tutorial — thanks, Reza

  8. Christer Russberg 4 months ago

    Thanks for a great video about different techniques for validation.

  9. P Bax 4 months ago

    thanks Reza -very useful 🙂

  10. Ger Fer 3 months ago

    May I call this application for entry visa👮🏽‍♀️👮🏽‍♀️😆😆😆

  11. Aroh Shukla 3 months ago

    Reza, first of all, a VERY HAPPY NEW YEAR TO YOU I hope will make more awesome videos in 2021. you have beautifully explained and its core concepts for the validation controls on Power Apps. Typecasting text field at 5:05, the recommendation of 500 controls is so valuable at 7:19, use of Coalesce at 7:55 (which I never knew this function exists), usage of regular expressions at 9:48 (need to use for one of the apps 😊 that I am developing), regular expressions with multiple conditions at 13:00, usage of switch function at 14:16 (wow, this is the really cool tip), Data validation at 17:49, Weekday function at 18:46, disabling submit function if the user has filled the required fields at 21:42

    Some quick questions:

    1. Do the 500 controls limit irrespective of specific data sources or its general guidance from Microsoft? What about large media files? Does it include this 500 control cap?

    2. Anyway show/hide part of the form and not just form controls?

  12. Soyeb Malek 3 months ago

    Thank you for detailed explanation.
    I loved the way you put your logic in PowerApps in most optimized way in all the videos..
    Glad to watch these videos 👏👍

  13. Ian Crosby 3 months ago

    Another great video, already thinking of the solutions I can provide now. Thanks

  14. Fahad Imran 3 months ago

    Please make a video on Pen Input

  15. Adi Cristea 3 months ago

    Thanks, Reza! You already know this, but for your subscribers, we could have just restricted the Text control to only allow Numbers by changing the Format property from Text to Number. Also there is a MaxLength that limits the number of characters allowed in that Text Input control, however it would only check the upper limit, so the use of Len is welcomed (and also the Match.Digit & Match.Letters is an awesome tip!).

  16. PAVANI n 3 months ago

    Hi Reza,
    Thanks for this video
    Helps a lot… To work in this sort of scenario

  17. PAVANI n 3 months ago

    Hi Reza,

    This video helped me to achieve my project requirements.
    There is one requirement as below
    When user enters his/her mail id in a person datatype(Account Email) field that need to get populated in another person datatype column(Account Email Contact Name) field in powerapps..
    Could you please share me that with an example.

    Hi Reza, given a datacardvalue as per your assistance in the default card it worked 😊

  18. kmurali krishna 3 months ago

    Really great, But its displaying keep, i just want to display only button press during submit
    here is the formula which i used for the title Field
    Coalesce(Parent.Error,If(IsBlank(DataCardValue5.Text),"Title is Required"))

  19. kmurali krishna 3 months ago

    Also, the Border color red keep displaying, when enters into that screen,
    it should display when during submission (when button click)

  20. Sayyed Adeeb Hussain 3 months ago

    Thanks Reza, you are just making powerapps more wonderful for us.
    Just want to add from my side also:
    Set DisplayMode of Submit button with this code, it will easily disable button if form validation not completed. (But I think that will work with list required conditions only.)
    If(EditForm1.Valid,Edit,Disabled)

  21. PAVANI n 3 months ago

    Hi Reza,
    I have a requirement to cascade between two dropdowns
    I have achieved that on New form
    Now when a request is created with the set of values from those cascaded dropdowns that should automatically populate when a request is edit and also user should be able to change those cascaded dropdowns.
    Your suggestions are appreciated to proceed on this

  22. Prasenjit Mukherjee 3 months ago

    Loved the video as well as your style of teaching also.As I am a new one how can I create a dashboard where I can get an update of all entries at a glance?just like your dashboard(Data Validation).Please guide me Sir.

  23. RamRod 3 months ago

    Outstanding. Thanks for the great video

  24. Gourav Ladha 3 months ago

    Hi, Reza, thanks for this wonderful video. I have a scenario where the date condition gets mixed up. I have a single form with add & edit mode. Date condition of today and 90 days is working fine when I create a new record, but in case of editing an old record i.e. of last year, validation kicks in. I am using one variable to set "Add" or "Edit" and want to change the condition to ensure it can work in both cases. Help is appreciated!

  25. V R 2 months ago

    Reza, This is awesome! Thank you! Is there a way to display error message on unique value check before the user fills in all info and clicks the submit button. I was wondering if there is a way to do this without querying back to the data source and instead using sharepoint’s unique validation.

  26. Amr Ibrahim 2 months ago

    Thanks Reza for this great video. So many useful scenarios indeed. Much more than I was looking for!

  27. Prajwal K 2 months ago

    great video and very helpful. always able to learn new things from each video

  28. Naiha Ahmed 2 months ago

    Hi Rena, thanks for such a helpful video. How can you highlight mandatory fields that are not filled in if you have a multi screen form and you want to highlight these to the user before navigating to the next screen? So your’e not submitting the form, only navigating. Currently I have the navigation button disabled until users fill in all mandatory fields but it would be helpful to highlight these fields as well.

  29. Chintan Desai 2 months ago

    Awesome. I was searching for the error message text right beside the respective control. thx 🙂

  30. Samit Bhattacharya 1 month ago

    Your video tutorials always save my day. Thank you very much.

  31. Miguel Sierra 1 month ago

    Hi! It's good to see you after all this time.
    Now, my data source is dataverse for teams, so I have two DataCards (we called X1 and X2 in this example) in which I want to insert numbers.
    When I go to edit the ErrorMessage of the respective DataCard one appears with DataCardValueX1.Value and the other with DataCardValueX2.Text, while DataCard of X2 works because only allows me to write numbers, the other DataCard X1 don't.

    Thanks for the help

Leave a reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

©2021 TDG - We Are Back Baby!

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending
or

Log in with your credentials

or    

Forgot your details?

or

Create Account