Тёмный

Power Apps form data validation tutorial 

Reza Dorrani
Подписаться 130 тыс.
Просмотров 142 тыс.
50% 1

#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 - docs.microsoft.com/en-us/powe...
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

Опубликовано:

 

20 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 385   
@ishanaggarwal7092
@ishanaggarwal7092 3 года назад
Dude many many thanks! Was looking for exactly this since last many days. I dont know why no one is stressing on functionality instead just focussing on how to mess things around. Thanks a ton :-)
@RezaDorrani
@RezaDorrani 3 года назад
You are most welcome and completely agree with your comments.
@HiroshimaMS
@HiroshimaMS 7 месяцев назад
The same here.
@TejaswinG
@TejaswinG 3 года назад
Hey Reza. Just want to let you know that your Power Apps forms videos have been immensely helpful. You have covered most scenarios in these video series. Thank you!
@RezaDorrani
@RezaDorrani 3 года назад
Great to hear!
@sibidi894
@sibidi894 7 месяцев назад
For every PowerApps project I work on, I watch between 5 to ten videos made by Reza. Your contribution to my success in my career cannot be over emphasised. Keep up the good work work mate! ❤
@RezaDorrani
@RezaDorrani 7 месяцев назад
Wow, thanks so much
@matth4745
@matth4745 2 года назад
Reza, I've spent more time with you than my family. You are a great help to my work.
@RezaDorrani
@RezaDorrani 2 года назад
😊 thanks for watching and liking my videos. Please spend more time with family :)
@simonball5602
@simonball5602 Год назад
Another great video Reza - thank you. I’m slowly making it through your content. IMO you’re the #1 PowerApps tutor on RU-vid. Please keep it up.
@RezaDorrani
@RezaDorrani Год назад
Wow! Thanks so much Simon.
@soyebmalek1536
@soyebmalek1536 3 года назад
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 👏👍
@RezaDorrani
@RezaDorrani 3 года назад
Thank you Soyeb
@kevinmahlangu4219
@kevinmahlangu4219 3 года назад
Hands down the best Power Apps channel on RU-vid
@RezaDorrani
@RezaDorrani 3 года назад
Wow! Thank you 🙏
@jcmagcalas4387
@jcmagcalas4387 2 года назад
Thank you Reza for helping me in my Power Apps journey. I have learned a lot from your tutorials. Continue providing comprehensive tutorials. Stay safe always.
@RezaDorrani
@RezaDorrani 2 года назад
Happy to hear that! I will keep trying my best.
@jeromedutzi5586
@jeromedutzi5586 2 года назад
Amazing video; in my opinion you are providing the best content in this field. Thank you very much!
@RezaDorrani
@RezaDorrani 2 года назад
Thank You Jerome
@Amr-Ibrahim-AI
@Amr-Ibrahim-AI 3 года назад
Thanks Reza for this great video. So many useful scenarios indeed. Much more than I was looking for!
@RezaDorrani
@RezaDorrani 3 года назад
Thanks for watching Amr
@anantharamakrishnan19
@anantharamakrishnan19 Год назад
You are awesome. The way you explain, the pace is just perfect and easy to grasp and the contents are so useful. Also, appreciate the efforts to keep the video just relevant for viewers need, making the essential cuts etc.
@RezaDorrani
@RezaDorrani Год назад
Glad you like them! Thanks so much for the awesome feedback.
@kreszentzia8345
@kreszentzia8345 15 дней назад
Exactly what I was searching for! Thanks a lot and very good explained as well!
@RezaDorrani
@RezaDorrani 15 дней назад
Most welcome
@Front_endgut-tm9cf
@Front_endgut-tm9cf 9 месяцев назад
Whole internet is playing with the icon's for this, but you just nailed it brother .
@RezaDorrani
@RezaDorrani 9 месяцев назад
So happy to hear that! Thanks so much for watching
@user-xm5yk5pj4d
@user-xm5yk5pj4d Год назад
Great Explanation Clear and Straight Forward to words the Content I am Wondering for the Power Apps Trainer , You are my Power Apps Trainer. No one is giving Clear Explanation regarding any topic in Power Apps and they don't know that how to make use of Power Apps. Thanks for Providing the Great Lectures 🎉🎉🎉🎉 Looking forward for Great Lectures and Soon i want to become a Member in Your RU-vid Channel.
@RezaDorrani
@RezaDorrani Год назад
Thank You so much
@AdiCristea
@AdiCristea 3 года назад
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!).
@RezaDorrani
@RezaDorrani 3 года назад
Hi Adi, thanks for the feedback. I had included the format property to Number but wanted to keep the video focussed on adding validations. I had spoken about it but got edited in the final version.
@donnalutheran6335
@donnalutheran6335 2 года назад
@@RezaDorrani thanks, this is an easy tutorial. I'm doing this first before applying the formatting for my phone number.
@keinthf
@keinthf 2 года назад
You are the best!!, thanks for all this videos about power apps and automate.
@RezaDorrani
@RezaDorrani 2 года назад
Thank You for your kind words
@tjlee5086
@tjlee5086 2 месяца назад
HUGE Thank-you, Sir!
@adrianquintanilla850
@adrianquintanilla850 2 года назад
Great video!!!! Loved the weekday validation saved me hours scoring the internet!!!!
@RezaDorrani
@RezaDorrani 2 года назад
Awesome! Thanks for watching.
@PowerAppsTraining
@PowerAppsTraining 4 месяца назад
Thank you Reza. Your videos are very helpful for beginners as well as experienced candidates.
@RezaDorrani
@RezaDorrani 4 месяца назад
You are very welcome
@PowerAppsTraining
@PowerAppsTraining 4 месяца назад
I am a power app developer your videos help me a lot. Tnq again
@marcovilla2112
@marcovilla2112 5 месяцев назад
thanks as always Reza! your videos are very easy to understand and very useful!
@RezaDorrani
@RezaDorrani 5 месяцев назад
Glad to hear that!
@samitbhattacharya2201
@samitbhattacharya2201 3 года назад
Your video tutorials always save my day. Thank you very much.
@RezaDorrani
@RezaDorrani 3 года назад
Glad to hear that!
@andrewadams8601
@andrewadams8601 11 месяцев назад
This was exactly what I needed. Thank you so much for posting! Subbed to check out what else you have.
@RezaDorrani
@RezaDorrani 11 месяцев назад
Thanks for the sub!
@oricchannel2811
@oricchannel2811 2 года назад
Hi, Reza! Won my LIKE and SUBSCRIPTION. Thank you for sharing this nice content video !!! Greetings from Brazil !!!
@RezaDorrani
@RezaDorrani 2 года назад
Awesome, thank you!
@santodomingo1915
@santodomingo1915 2 года назад
Hey! This is a great video, I've learned a lot on this 20 min. Thank you so much!!!!
@RezaDorrani
@RezaDorrani 2 года назад
Glad to hear that! Thank You for watching.
@garethlp
@garethlp Год назад
Thank you so much... your videos are so helpful!
@RezaDorrani
@RezaDorrani Год назад
Your most welcome and thanks for watching the videos
@premsai9908
@premsai9908 3 года назад
Dear Reza You are doing a Noble Job I have No words to Thank your Help to beginners like me.
@RezaDorrani
@RezaDorrani 3 года назад
Thank you Prem
@AkishaAnthony
@AkishaAnthony 2 года назад
Thank you. This video has helped my solved some validation issues.
@RezaDorrani
@RezaDorrani 2 года назад
Great to hear!
@sayyedadeebhussain5345
@sayyedadeebhussain5345 3 года назад
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)
@RezaDorrani
@RezaDorrani 3 года назад
Thank you! That is true. It will only work with required only conditions.
@sayyedadeebhussain5345
@sayyedadeebhussain5345 3 года назад
@@RezaDorrani:)
@clauvallejos
@clauvallejos 2 года назад
Love u from Chile, thanks!!
@RezaDorrani
@RezaDorrani 2 года назад
Thank You!
@abhijityenpure969
@abhijityenpure969 Год назад
Thanks for creating these tutorials. Very helpful.
@RezaDorrani
@RezaDorrani Год назад
You're very welcome!
@ExploreMore313
@ExploreMore313 Год назад
Thank You Reza for detailed explanation😊
@RezaDorrani
@RezaDorrani Год назад
Most welcome
@PattyJames3478
@PattyJames3478 3 года назад
Great Video! Thank you for taking the time to create this!
@RezaDorrani
@RezaDorrani 3 года назад
You are most welcome
@chintandd
@chintandd 3 года назад
Awesome. I was searching for the error message text right beside the respective control. thx :)
@RezaDorrani
@RezaDorrani 3 года назад
You're welcome!
@bobkiggundu9010
@bobkiggundu9010 2 года назад
This has been extremely helpful, thank you!
@RezaDorrani
@RezaDorrani 2 года назад
Glad it was helpful!
@user-lb1bk6md7n
@user-lb1bk6md7n 11 месяцев назад
Thank you a lot! This video really showed what I needed!
@RezaDorrani
@RezaDorrani 11 месяцев назад
Most welcome! Thanks for watching
@christerrussberg3059
@christerrussberg3059 3 года назад
Thanks for a great video about different techniques for validation.
@RezaDorrani
@RezaDorrani 3 года назад
Thank you for watching
@Christian-tf6ol
@Christian-tf6ol Год назад
You saved me, thank you as always Reza 👏❤
@RezaDorrani
@RezaDorrani Год назад
You're welcome 😊
@tcoalson
@tcoalson Год назад
Great video! Thanks for sharing your knowledge!
@RezaDorrani
@RezaDorrani Год назад
My pleasure!
@hectorgeronimo97
@hectorgeronimo97 5 месяцев назад
You are a genius and a great teacher
@RezaDorrani
@RezaDorrani 5 месяцев назад
Thank You so much
@davidemercadante2406
@davidemercadante2406 3 года назад
Loved this video! Watching it I had some nice new ideas in mind for my next app. Glad to learn from such pro
@RezaDorrani
@RezaDorrani 3 года назад
Thank you Davide. Best of luck for your new App.
@davidemercadante2406
@davidemercadante2406 3 года назад
@@RezaDorrani Thanks. Looking forward to integrating new responsive containers , galleries, html reporting and more advanced gallery layout ( Tiles view) for project management. I hope it won’t be too ambitious
@RezaDorrani
@RezaDorrani 3 года назад
@@davidemercadante2406 Not at all. Go for it. Best of luck 🤞
@davidemercadante2406
@davidemercadante2406 3 года назад
@@RezaDorrani 🤞 I have a question for you if you want to answer. It is related to rotation of new containers. . I am thinking to set up a variable on the OnVisible property for the screen layout depending if Screen.Width is greater than Screen.Height or not and this variable would help defining container layouts, font size and control visibility. What I mean is, that variable might be equal to 1 if width>height, or otherwise 2. This value might be used in other variables n conjunctions with breakpoints values for font size and what to show and what not and also to determine if containers should be vertical or horizontal. What do you think? Might it work? I didn’t test it yet.
@RezaDorrani
@RezaDorrani 3 года назад
@@davidemercadante2406 That is correct. I use the same technique.
@sundrapillay6668
@sundrapillay6668 3 года назад
Thanks Reza for the great tutorials have a great New Year
@RezaDorrani
@RezaDorrani 3 года назад
Thank you & Happy new year!
@designmycity
@designmycity Год назад
Thank you for this amazing video.
@RezaDorrani
@RezaDorrani Год назад
Your most welcome
@PKCKMK
@PKCKMK 6 месяцев назад
Thanks Reza, you solved my problem @ 5:10
@RezaDorrani
@RezaDorrani 6 месяцев назад
Most welcome
@ally1708
@ally1708 Год назад
thank you Reza, May God bless u
@RezaDorrani
@RezaDorrani Год назад
🙏
@jimfitch
@jimfitch 3 года назад
Another terrific tutorial - thanks, Reza
@RezaDorrani
@RezaDorrani 3 года назад
Thank you Jim
@jimfitch
@jimfitch 3 года назад
@@RezaDorrani This reply is completely off-topic, and I apologize for that, but I am pulling my hair out trying to create a Dataverse table for use in a Power App in MS Teams. (I have extensive Access/Excel VBA experience, a lot of Teams experience, limited experience with Power Apps in my Default non-Teams Environment, & no experience with Dataverse.) I created a Dataverse table with 2 columns: ID (primary column) as Autonumber; DateTimeIn as Date-and-Time. The problem is that both columns are read only, so I am unable to add records to the table. I want to add a few dummy records to the table before I begin developing the Power App (screens, controls, logic, etc.). I raised the issue on Power Apps Community, but none of the suggestions made to date have worked. Do you have any ideas for this? Thx.
@RezaDorrani
@RezaDorrani 3 года назад
@@jimfitch Every table comes with a default Name column which is required. You can add some data in Name column.
@jimfitch
@jimfitch 3 года назад
@@RezaDorrani True, but unfortunately, the date-time column is read-only. Also, it does not make sense to me why it is possible to assign the Autonumber data type to the Primary Column, but then impossible to add rows to the table b/c that field lacks values when creating a new record. I’m not too worried about this right now b/c I figure I’ll work around it in the Power App with a hidden control that creates the entry. Big untested assumption, but more concerned right now about adding a date-time column that will accept data.)
@prajwalskateel
@prajwalskateel 3 года назад
great video and very helpful. always able to learn new things from each video
@RezaDorrani
@RezaDorrani 3 года назад
So happy to hear that. That’s the goal of this channel. Thank you for watching.
@iancrosby7265
@iancrosby7265 3 года назад
Another great video, already thinking of the solutions I can provide now. Thanks
@RezaDorrani
@RezaDorrani 3 года назад
Excellent! Thanks for watching Ian.
@pennyp5822
@pennyp5822 3 года назад
Outstanding. Thanks for the great video
@RezaDorrani
@RezaDorrani 3 года назад
Thank you
@breadandcheese1880
@breadandcheese1880 6 месяцев назад
Wow Reza -Ji - Thank you so much!
@RezaDorrani
@RezaDorrani 6 месяцев назад
Most welcome ji
@leenashreeindrani532
@leenashreeindrani532 3 года назад
Hi Reza, Thanks for this video Helps a lot... To work in this sort of scenario
@RezaDorrani
@RezaDorrani 3 года назад
Thank you
@sonali2k11
@sonali2k11 3 года назад
Great video Reza 🙂
@RezaDorrani
@RezaDorrani 3 года назад
Thanks Sonali
@bootsbax
@bootsbax 3 года назад
thanks Reza -very useful :)
@RezaDorrani
@RezaDorrani 3 года назад
Most welcome
@TechChaitu
@TechChaitu 3 года назад
Great Video! Can you make video on Validate function
@RezaDorrani
@RezaDorrani 3 года назад
Will add it to my backlog but this is the first request on this topic. I will need a lot more requests on this topic to give this a higher priority.
@thatmattwade
@thatmattwade 2 года назад
This was fantastic Reza! One question about improving the UX a bit so it's not so immediate with the HEY YOU DIDN'T DO THIS RIGHT when I may not even be done entering my input. Is it possible to show the red outline and the red warning text after I've completed entering the info? This seems to default to reporting errors live while entering data. I find it super frustrating when I'm still working and a field is yelling at me, but I'm not even done entering my information yet. I'd prefer if it assesses my information after I click out of the field or tab to the next field.
@RezaDorrani
@RezaDorrani 2 года назад
Thanks Matt! Been a long time for this video but I think you could set a variable on click of submit button. The validation code should also include logic to check if that variable is set (show error message if condition is met and variable is set). That ways the error only shows when user submits the form. Prior to that it will not give that “HEY YOU DIDNT DO THIS RIGHT” message :)
@thatmattwade
@thatmattwade 2 года назад
@@RezaDorrani good idea. I'll try that!
@ArohShukla
@ArohShukla 3 года назад
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?
@RezaDorrani
@RezaDorrani 3 года назад
Thank you Aroh. Use of Coalesce is the key to error handling using the existing error message label. 1 - Media files embedded in App has a 2GB limit. 500 controls is best practice from MSFT irrespective of data source. You can go beyond but it would start impacting performance. 2 - Since forms are made up of data cards. You would have to apply ur logic for show hide to each data card. I do plan a video on form control in future. I will think about this and include a technique to simplify show/hide for sections within the form.
@RezaDorrani
@RezaDorrani 3 года назад
And a very HAPPY HAPPY HAPPY NEW YEAR TO you too my friend
@ArohShukla
@ArohShukla 3 года назад
@@RezaDorrani awesome 👌 brother
@alexpena9419
@alexpena9419 3 года назад
Fantastic video! You have a gift my friend! One thing though, the validations I added to my form work as far as displaying the error messages is concerned, but it doesn't PREVENT the form from being submitted with errors. In other words, the VALID value of the form does not change to FALSE when there are validation errors. If the errors are backend errors then it prevents the form from being submitted with errors. What am I missing?
@RezaDorrani
@RezaDorrani 3 года назад
Interesting. Valid should check for required field errors on form as well and not allow submission. I will have to look at your App in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
@aamirghanchi9487
@aamirghanchi9487 2 года назад
Alex. you can disable the Submit button as Reza has suggested. This will prevent the form from being submitted with the validation errors.
@abhijityenpure969
@abhijityenpure969 Год назад
Thanks Reza for wonderful vdo tutorial. I am new to PowerApps and your training has been of immense help. One quick question, I added validations on some of my fields using methods shown here. However onsubmit method on submit button didn't respect these error and went ahead and submitted my request with wrong data to sharepoint list. Do I have to explicitly check if there are any active error messages before making submitform call?
@RezaDorrani
@RezaDorrani Год назад
Thanks for watching and liking the videos. I will have to look at your App in action to provide guidance. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@teguhwibowo3086
@teguhwibowo3086 8 месяцев назад
Hi Reza, thanks for the video. It's usefull for me when I start my job now. But, Is the some feature not available for modern view?
@RezaDorrani
@RezaDorrani 8 месяцев назад
What is modern view? Are you mentioning about modern controls? Most of my recent videos are related to it. I have also shown modern validations.
@nAhmd1
@nAhmd1 3 года назад
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.
@RezaDorrani
@RezaDorrani 3 года назад
You would have to add your own label controls to show the mandatory message in that case. It would be more work. Better to keep button disabled until all mandatory fields are filled in.
@ChrisSimmsJr
@ChrisSimmsJr 2 года назад
This is a great video. I need some guidance on how to make a field conditionally required if the user uploads an attachment.
@RezaDorrani
@RezaDorrani 2 года назад
You would need to check count of number of items in attachments control.
@ChrisSimmsJr
@ChrisSimmsJr 2 года назад
@@RezaDorrani you're the man! I didn't even think to do that SMH 🤦‍♂ Thank you!
@vr1085
@vr1085 3 года назад
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.
@RezaDorrani
@RezaDorrani 3 года назад
I did try it and it did not work. Guess, we will have to query the data source.
@reshmakamat4432
@reshmakamat4432 7 месяцев назад
Very useful video
@RezaDorrani
@RezaDorrani 7 месяцев назад
Thanks
@kmuralikrishna1582
@kmuralikrishna1582 3 года назад
Also, the Border color red keep displaying, when enters into that screen, it should display when during submission (when button click)
@RezaDorrani
@RezaDorrani 3 года назад
For required field validations just set the required property of data card to true. No need to add Coalesce in that case. If you need validations to only run on button click, then do the following. Screen OnVisible property set a variable eg. Set(varBtnClick, false) Button OnSelect property set variable Set(varBtnClick, true) On Coalese functions you will need to also check if this variable is true.
@OpusMagnoCards
@OpusMagnoCards Год назад
Bravo!
@RezaDorrani
@RezaDorrani Год назад
Thank You.
@chethanc5229
@chethanc5229 Год назад
Thanks Reza. As suggested in this Video, I made a field (say Comments) mandatory when choice field is with certain values,. But, for some reason i dont see error message being displayed, instead i only see (*) next to the Comments card. Also, Submit button doesn't stop me from submitting. I am using PATCH function to update all the forms to the Sharepoint List
@RezaDorrani
@RezaDorrani Год назад
I will have to look at your app in action to provide guidance. I will recommend posting your issue with screenshots on the forums powerusers.microsoft.com
@annettemassie1962
@annettemassie1962 2 месяца назад
Love this video. I do have a question. In the section where you use the DisplayMode to disable the submit button based on the condition if your error.text fields are not blank, could you updatecontext or set a variable at the same time when creating the error message. Then use only one "if" condition on the DisplayMode of the submit button based on if the variable was true or the updatecontext was true. Would that work? Would you have code to support that?
@RezaDorrani
@RezaDorrani 2 месяца назад
Have not tried it so not sure. Give it a try and see if it works.
@macm7730
@macm7730 3 года назад
Hi Reza, Thank you so much for this amazing video(Always like about the small pointers you provide in your all videos). I've a question, currently, I’m trying to apply input validations to the PowerApps which has dropdown(data coming from a List) and submit button. And in second page combobox (field coming from SQL SP). I haven’t use any forms, instead I directly place a control on screen so I don’t have Data cards. So do you think the ideal way for PowerApp UI… is to always use a form and data card etc… so that it makes easier to apply the validation. I’m having hard time in applying required field validation “If combobox/dropdown doesn’t have any value then submit button gives message accordingly… instead of taking to the next page by OnSelect event. Also, I’m not sure how to set a default blank value for the combobox(data coming from SQL)… for the DropDown (coming from a List) I added a first row blank in the actual List for setting up the blank value to the DropDown. Thank you so much for always helping us.
@macm7730
@macm7730 3 года назад
Reza, also, if you don't have time to write down your thoughts, you can just share a link of your videos/articles... I'll refer and follow that... as I've asked so many questions in one comment...Lol. Thank you again :)
@RezaDorrani
@RezaDorrani 3 года назад
Wow that's a lot of questions. Form control or build your own form using controls is a choice you can make. Both approaches work. I more or less always work with the form control. To check for empty values, each column type is different so each formulas is different. I do not have videos specific to your use case. Checking empty in combobox is kind of showcased in this video - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5dSk5iOgT68.html I would also recommend you to post your issues on the forums at powerusers.microsoft.com/ Many a times folks already have solution to common problems on the forums
@macm7730
@macm7730 3 года назад
@@RezaDorrani Sure, I'll check both the links and other post/article. Thanks for providing your input... Sorry for lot's of question :) I'm working on improving what/how to google for the closest answers/articles for the issues I come across...Thanks Reza :)
@rebeccamayer3602
@rebeccamayer3602 Месяц назад
Thanks for the video, struggling with my data validations still. I have a multi tab form and want to make some fields mandatory. I tried setting ‘required’ field to “true” within properties.. this gives me an asterix next to the Card but does not enforce the field as mandatory? Any ideas would be greatly appreciated!
@RezaDorrani
@RezaDorrani Месяц назад
I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
@HowToExcelBlog
@HowToExcelBlog 3 года назад
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?
@RezaDorrani
@RezaDorrani 3 года назад
I feel forms are powerful and can be customized as needed. I would like to know what sought of customizations you added for which you needed to abandon forms. I have a plan next month around a video on forms and how to customize data cards.
@kittydoes7600
@kittydoes7600 3 года назад
@@RezaDorrani looking forward to this especially customizing data cards. I've been struggling with data cards!
@HowToExcelBlog
@HowToExcelBlog 3 года назад
@@RezaDorrani I don't like the ridgid grid so you can't free form place cards. Sometimes I want two fields to take up same space as one, or have one field twice the height as others. Also, if you want to change the font, or color, or border for a form with 20 fields it's a mega pain. Sometimes I've ordered fields and had to reorder them as for some reason they got reset. Lots of little things. They can be a great option, but most times I've used them in an app, then presented it to the user, they say great but can we have it do x, y and z? Then I go back and try to implement it in the form and it can't be done so I scrap it and build my own.
@RezaDorrani
@RezaDorrani 3 года назад
@@HowToExcelBlog These are all valid points. And I will consider all of these points when working on my video on the Form Control. Thank you!
@shakadezulu8615
@shakadezulu8615 3 года назад
Great video. Any thoughts on how based on a data card value, I can prevent users from editing the list item in sharepoint? For example, if status of request is closed, the edit button is disabled to users but can be available to admins
@RezaDorrani
@RezaDorrani 3 года назад
I have 2 videos which will cover your use case. Watch both of them. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-aVEaRpAlaTA.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-J-hMMXrKMVE.html
@gouravladha
@gouravladha 3 года назад
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!
@RezaDorrani
@RezaDorrani 3 года назад
First, Check form mode. If New then apply the validation else do not. Next, if edit mode and value has changed then apply validation. How to check if value changed - compare the the value of the item (ThisItem.Date) with the value updated in the date control on form (DatePicker.SelectedDate). You can also leverage Form.Updates to get some info.
@gouravladha
@gouravladha 3 года назад
@@RezaDorrani Great thanks, let me try this
@miguelsierra7379
@miguelsierra7379 3 года назад
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
@RezaDorrani
@RezaDorrani 3 года назад
Hi Miguel, honestly I did not understand your query.
@miguelsierra7379
@miguelsierra7379 3 года назад
I'm soorry for that :( I just change the visible property of the ErrorMessage in the DataCard and apparently that's how it worked for me, I don't know if this is the best way. Thanks for your time.
@xingxifahad5355
@xingxifahad5355 2 года назад
Hey Reza, This video is of great help. I wonder, if there is any way to invoke/trigger form validation procedure without pressing/invoking SubmitForm() [without using formulas in the onchange/onselect/etc...]
@RezaDorrani
@RezaDorrani 2 года назад
I’m not sure about that. May be there is a way.
@alainpitau1870
@alainpitau1870 Год назад
Hi Reza you did as usual a great video i really nice. This is a question for you. How could you delete "Error data card" and handle this part on the field label. The goal is to decrease count control. I already replace "is require *" by your technique. Thank you
@RezaDorrani
@RezaDorrani Год назад
For that I would keep error label and only remove star label
@marienaalvarez8235
@marienaalvarez8235 3 года назад
Great Video as always!!! You are my teacher. Can you advise how I can add default value in a text based on a dropdown selection. But I would like that the default value can be edited by the user. For example: if I select Asset type: Smartphone I would like to predefine a default text in Business Justification for the user to complete, but power app is not saving my changes.
@RezaDorrani
@RezaDorrani 3 года назад
Check my video on form control - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-aVEaRpAlaTA.html
@terencealmeida4594
@terencealmeida4594 3 года назад
Hello Reza, Thank you for your video, could you please share your views on the function that can be used if we need to provide an error on the date field if the user selects 5 days earlier than today's date & if the user selects any date after today date i.e. restrict the user to update the form within only 5 days including today's date.
@RezaDorrani
@RezaDorrani 3 года назад
You would need to use the date functions and compare the dates. DateAdd and DateDiff. I have seen a few posts around this on the forums at powerusers.microsoft.com
@pankajupadhyay5356
@pankajupadhyay5356 Год назад
Very Nice Vedio Reza. I need to check with you is any way that that i can compare the value of Text Box with the list LOV ( may in in the Excel or sharepoint ) ?
@RezaDorrani
@RezaDorrani Год назад
For that you would need to query your data source to get the value to compare. You could use lookup function to get the record and then the column value to compare. Example: lookup(data source, condition).column
@RedCloudServices
@RedCloudServices Год назад
Reza are there instructions on how to setup nested dynamic picklists? my use case is simple we have 6 categories and each category has a unique picklist of items to appear in the subcategory field. Also can we use dataverse records as an API for other systems to consume?
@RezaDorrani
@RezaDorrani Год назад
I do not have a video reference on this scenario. I recommend checking on forums in case someone has done something similar powerusers.microsoft.com
@mariodamore5210
@mariodamore5210 2 года назад
Hi Reza, thanx for the video. Is there a way to check the entire forma for error instead to check every error field?
@RezaDorrani
@RezaDorrani 2 года назад
True
@akshay._.solanki
@akshay._.solanki 2 года назад
Hi Reza, Great video as always. I have a couple of questions regrading validation which I believe you can help me with. and my data source for the Form is SharePoint list 1.) How to add validation for a Yes/No choice field. (Example1: If the answer is yes, then only display certain fields after that but If answer is No then skip them) 2.) How can I add two different attachment questions for a single item in SharePoint using this Form? (It will be fine if they all get saved together in Attachment for a single item in SharePoint but I require it in two different upload question in the Form.)
@RezaDorrani
@RezaDorrani 2 года назад
1) is not validation related :) It is to show hide data cards. Check my video on form control ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-aVEaRpAlaTA.html Yes/no columns should be avoided as much as possible. Check rezadorrani.com/index.php/2019/04/14/powerapps-filter-sharepoint-yes-no-column-bug/ 2) There can only be 1 attachment control per form. However, there are some hacks that you can apply. Check ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-hJQjGE-oUpM.html
@saravanapriya2171
@saravanapriya2171 11 месяцев назад
Hi Reza..Thanks for your videos. I have a query in data validation..How to validate two different lists and throw a error message if the auto populate column doesn't have the value of another list. Here the auto populate column gets the data from third list
@RezaDorrani
@RezaDorrani 11 месяцев назад
Most welcome! I do not have a video reference on the scenario you mentioned and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@prasenjitmukherjee5010
@prasenjitmukherjee5010 3 года назад
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.
@RezaDorrani
@RezaDorrani 3 года назад
I have an upcoming video on this - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bnC8u3gdWss.html
@shahvinitshah8892
@shahvinitshah8892 2 года назад
Hello Reza firstly thank you so much for uploading the videos which are very helpful. In reference to the validation I have a question. The Power App which I am developing. There are two Data Cards in a form connected to the sharepoint list in the backend. First Data card has a choice input and the second data card (justification Card) is a multiple lines of input in the same form. The thing I need to validate is the Justification card so when the choice is Yes justification should be mandatory (Required) if the choice is No there is no need of justification required. As I also tried " Datacardname.Selected.value = "YES") in the required feild of justification datacard for some reason it is giving me error message "Name isn't valid selected not recognized" The video here in shows the expense amount where user enters more than 250 the justification is required how can I deal with the same login when the input is in choice. Thanks.
@RezaDorrani
@RezaDorrani 2 года назад
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@rthoughts7232
@rthoughts7232 3 года назад
Very useful tricks.. Is there any other videos by you for handling validation? If yes, pls share if possible.
@RezaDorrani
@RezaDorrani 3 года назад
Currently this is the only one focused on validations. Many other Apps and flow related videos do have some form of validations in them.
@jaytavare1618
@jaytavare1618 2 года назад
Hi Reza, Thank you so much for creating the wonderful videos, it helps a lot for a beginner to work on PowerApps. But I have a question on this, if form is already submitted the user should not be able to submit the same form on same date?
@RezaDorrani
@RezaDorrani 2 года назад
I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@jaytavare1618
@jaytavare1618 2 года назад
@@RezaDorrani Thank you sir, but I found a way to overcome this, if we lookup for current user and datepicker.selecteddate we can do it.
@RezaDorrani
@RezaDorrani 2 года назад
@@jaytavare1618 👍
@gouravgarg8855
@gouravgarg8855 Год назад
Many thanks! I am looking for match time (hh:mm AM/PM) in text input column. Please help
@RezaDorrani
@RezaDorrani Год назад
I do not have any video references for this scenario. I recommend posting your query on forums at powerusers.microsoft.com
@faisalomari7111
@faisalomari7111 Год назад
Dear Raza, i really love your videos and they are very useful. Would you kindly share with me any videos related to a dropdown field where the user should be able to edit and add data manually in case the choice is not available? ...i am trying to add a dropdown field in my canvas and to allow users to edit and add data also in case that choice is not found..?...in my case, my data source is an excel sheet.
@RezaDorrani
@RezaDorrani Год назад
Thank You! I do not have any video reference on the dropdown scenario mentioned. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@haravindhv616
@haravindhv616 2 года назад
Can u prepare an video on update context In which refresh is to be used for updating the context
@RezaDorrani
@RezaDorrani 2 года назад
You mean the local variable function updatecontext?
@jaleelahmed2575
@jaleelahmed2575 2 года назад
Thanks for the video. I have a small clarification. How to set the formula for the duplicate value, say for e,g If my invoice number is 123 for the particular ID; in case the same invoice number already exist then it should prompt an error that invoice value already exist. Pls help out with the solution.
@RezaDorrani
@RezaDorrani 2 года назад
For that, you would need to query your datasource to check if duplicate exists. There is a better option though. If your data source is SharePoint you can set column to be unique in the list settings.
@multiRocko3
@multiRocko3 3 года назад
I have looked online for a while now but can’t find the help I need. Do you know of a way to validate a specific character? I want to restrict input to only allow numbers and one comma. So basically MultipleDigits & “OptionalComma” & OptionalDigits. The comma isn’t always needed therefor I want it to be optional.
@RezaDorrani
@RezaDorrani 3 года назад
I don't think there is an optional comma option. I will recommend you check on the forums at powerusers.microsoft.com/
@aishwaryagorthi5288
@aishwaryagorthi5288 2 года назад
Conditionally required field is something Where i was facing difficulty ! Phew thanks for the viedo 😀 also one quick question and can we use the validate function for validation a text input value to match with list of items ? Does that work ?
@RezaDorrani
@RezaDorrani 2 года назад
You cannot validate against a list of items. You would need to add your own validation logic by showing an error message.
@mohammadanwar1304
@mohammadanwar1304 3 года назад
Nice video. Just want to know is there a validation for only Letter and/or Number ? Special characters are not allowed
@RezaDorrani
@RezaDorrani 3 года назад
IsMatch( YourText, "^[a-zA-Z0-9]*$" )
@mohammadanwar1304
@mohammadanwar1304 3 года назад
@@RezaDorrani Thanks Reza
@MrDashingAshish
@MrDashingAshish 2 года назад
Hi Reza, I am in one scenario where there is one gallery in data card which has add button and on click of add new row gets created. And row has few inputs, checkboxes, dropdowns like controls. I need to validate all those on final submit, I am facing limitation of using variables assigned to controls as things are dynamic. Is there any best way of doing it? As a final check I am comparing gallery rows at the end before submitting with valid rows. That solves one part of puzzle. Other part is to highlight the control within every invalid row at least with border highlight. Kindly guide me here don't need exact code but need to know best practice of doing it. Thanks in advance.
@RezaDorrani
@RezaDorrani 2 года назад
I will have to recreate your scenario to provide guidance. One option would be to use a collection instead of multiple variables. I will also recommend you check on the forums at powerusers.microsoft.com in case someone has done something similar.
@tarunaneja7802
@tarunaneja7802 2 года назад
Hi @reza thanks for this video. could you please tell me how I can set up a rule, if I have 3 form fields and total of all three fields should not exceed the 100%. e.g. A+B+C=100% (where A,B, and C are input form field or column names in Dataverse)
@RezaDorrani
@RezaDorrani 2 года назад
I would have to try it out to provide guidance. I would recommend posting your query on the forums at powerusers.microsoft.com
@josecarlosbenitezmeyer645
@josecarlosbenitezmeyer645 9 месяцев назад
Great Tutorial really helpful, is it possible to add a validation in the same data card for example I have an card where is stored the % of advance of a contract , I need that to be equal or greater it cannot be less, is it possible ?
@RezaDorrani
@RezaDorrani 9 месяцев назад
Probably possible but not something I have tried.
@SirajAhmad-uo1gr
@SirajAhmad-uo1gr 2 года назад
dear reza, you are doing great job. i have scenario, can you help me on this, i want to create form dynamically in powerapps. fields name should be taken from sp list. is that possible?
@RezaDorrani
@RezaDorrani 2 года назад
I do not have a video on this scenario. I have a backlog item on this topic. I would recommend you check on the forums at powerusers.microsoft.com in case someone has done something similar
@balaji830
@balaji830 3 года назад
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)?
@RezaDorrani
@RezaDorrani 3 года назад
There is a Form.IsValid property but goal here it to show the error messages on the fly as user makes the updates. Moreover, we are adding additonal validation logic to the data cards of the form control which are not part of the backend data source.
@balaji830
@balaji830 3 года назад
@@RezaDorrani I get that, I was only wondering from the perspective of Submit button enabling and disabling.
@ashokpershad
@ashokpershad 3 года назад
Great video...very useful
@RezaDorrani
@RezaDorrani 3 года назад
@@ashokpershad Thank you
@danielcotterill6931
@danielcotterill6931 6 месяцев назад
Hello, For the data based pattern matching, how would I do it for 2 selected value fields? So for example I have Network status "Cancelled" then another tav of reason for request "push to cancel". So how can I make sure that the network status meets the same as reason for request?
@RezaDorrani
@RezaDorrani 6 месяцев назад
By comparing the 2 values I guess. Sorry but I do not have a specific video on this scenario and hence only guessing.
@samolppp9976
@samolppp9976 2 года назад
hi Reza, Thanks for your time and explaining the data validations video. Can you please help , by explaining how to create that DATA VALIDATIONS header title and this good looking form. help is appreciated!
@RezaDorrani
@RezaDorrani 2 года назад
Header title? Good looking forms and galleries - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-aVEaRpAlaTA.html & ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bnC8u3gdWss.html
@samolppp9976
@samolppp9976 2 года назад
@@RezaDorrani when i created a simple form, i am not able to re-arrange the controls , say Title , firstname, lastname etc. Do you mean, if i first connect with SPLIst, should i delete all those fields and create new textinput controls from the "Insert" menu/command ? and arrange it?
@RezaDorrani
@RezaDorrani 2 года назад
@@samolppp9976 Check the video link I shared. I show how to rearrange and more.
@arkabanerjee1587
@arkabanerjee1587 Год назад
Hello, just one query. How to add the unique constraint validation in Power Apps ?
@RezaDorrani
@RezaDorrani Год назад
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Далее
🚀Custom form Data Validation in Canvas App PowerApps
37:59
Кто быстрее? (GTARP)
19:19
Просмотров 389 тыс.
Editable Grid in Power Apps | SharePoint List
42:49
Просмотров 359 тыс.
How to validate power apps edit form before submit
25:48
PowerApps Blank Field Error Checking
15:48
Просмотров 22 тыс.
Power Apps Tutorial
2:42:26
Просмотров 324 тыс.