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 :-)
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! ❤
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!
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.
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!).
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.
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 👏👍
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)
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 CZcams Channel.
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 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 🤞 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.
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?
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
Hey this is super awesome and has a lot of uses. I am currently trying to validate if a user enters a date verses using the data picker, that they receive an alert if it is not in the correct format (MM/DD/YYYY). I have validated if MM/DD/YY is input by typing and the form is submitted, there won't be data in the SharePoint list in the date field. I thought a validation might help but all the formulas I have tried don't consistently work. Here is one if you can immediately see something I am off base on - Coalesce(Parent.Error, If(!IsBlank(DataCardValue3.SelectedDate) && !IsMatch(PlainText(DataCardValue3), Digit & Digit & "/" & Digit & Digit & "/" & Digit & Digit & Digit & Digit), "*Be sure to input in MM/DD/YYYY format", "")). I also notice in a lot of your formulas that you don't complete if statements. That has got me in trouble in the past. Do you do to speed up the video or do you truly not complete the formula?
Better option would be to superimpose a label control (empty text) on top of dat picker (text input part) - That way user has to pick date from the picker. Can you show me at what time in video where I have not completed if statement?
Thanks for the quick response! That is a genius idea. Thank you. That was making me crazy. Didn't even think to remove the free text option. At 14:17 the true criteria is your error text for true, wouldn't you need a "" to put the blank for the false of the If statement or am I totally off base?
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?
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 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 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.)
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.
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 :)
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.
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
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?
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
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 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?
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.)
1) is not validation related :) It is to show hide data cards. Check my video on form control czcams.com/video/aVEaRpAlaTA/video.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 czcams.com/video/hJQjGE-oUpM/video.html
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.
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 ) ?
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
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?
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.
@@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.
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
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.
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.
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.
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?
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
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...]
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.
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.
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
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
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.
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?
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 😊
A person column (assuming your data source is SharePoint) - if you need to just copy the data over to another field you can just set the default property of the data card. No validations required there. Person column is special type and expects a particular format as follows: rezadorrani.com/index.php/2020/05/04/power-apps-patch-function-with-sharepoint/
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.
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.
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!
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.
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.
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
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
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!
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
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.
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 ?
HI Reza, This is good stuff. The only thing is that I cannot seem to create the correct syntax for matching a Project Title that is in a card with a text control. I tried several of the IsMatch options, but my custom error message shows all the time when I edit an item.
Correction: Coalesce( Parent.Error, If( !IsBlank(DataCardValue1.Text) && !IsMatch( DataCardValue1.Text, MatchOptions.Complete ), "This title already exists" ) ) only 1 exclamation point, still showing an error
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 ?
I added this Coalesce( Parent.Error, If( Len(DataCardValue3.Text) 50, "Must have a minimum of 50 characters" ) ) This is working but the issue is I can still submit the SharePoint list form even it is less 50 characters. The "Save" button does not show when editing a SharePoint list/form in Power Apps.
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.
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 :)
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 - czcams.com/video/5dSk5iOgT68/video.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
@@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 :)
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?
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?
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
Hi Reza, at 11:32 you showed us how to validate the Serial Number text input only accepts number using Match.MultipleDigits. How can I modify the formula if I want the text input to accept digits and hyphen (such as \d\d\d\-\d\d or \d\d\d\-\d\d\-\d\d and any other format as long as they are digits and/or hyphens)? Really appreciate if you can shed me some lights and thanks in advance.
You can enter regex there. I would have to try it out to let you know the formula. I will recommend posting your query on the forums at powerusers.microsoft.com/
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 :-)
You are most welcome and completely agree with your comments.
The same here.
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! ❤
Wow, thanks so much
Whole internet is playing with the icon's for this, but you just nailed it brother .
So happy to hear that! Thanks so much for watching
Hands down the best Power Apps channel on CZcams
Wow! Thank you 🙏
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!
Great to hear!
Exactly what I was searching for! Thanks a lot and very good explained as well!
Most welcome
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.
Happy to hear that! I will keep trying my best.
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!).
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.
@@RezaDorrani thanks, this is an easy tutorial. I'm doing this first before applying the formatting for my phone number.
Reza, I've spent more time with you than my family. You are a great help to my work.
😊 thanks for watching and liking my videos.
Please spend more time with family :)
Amazing video; in my opinion you are providing the best content in this field. Thank you very much!
Thank You Jerome
Thank you Reza. Your videos are very helpful for beginners as well as experienced candidates.
You are very welcome
I am a power app developer your videos help me a lot. Tnq again
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 👏👍
Thank you Soyeb
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)
Thank you!
That is true. It will only work with required only conditions.
@@RezaDorrani:)
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 CZcams Channel.
Thank You so much
Dear Reza You are doing a Noble Job I have No words to Thank your Help to beginners like me.
Thank you Prem
Thanks Reza for this great video. So many useful scenarios indeed. Much more than I was looking for!
Thanks for watching Amr
Another great video Reza - thank you. I’m slowly making it through your content. IMO you’re the #1 PowerApps tutor on CZcams. Please keep it up.
Wow! Thanks so much Simon.
You are a genius and a great teacher
Thank You so much
Many thanks for a very helpful video. God bless you real good.
Glad it was helpful!
You are the best!!, thanks for all this videos about power apps and automate.
Thank You for your kind words
Thanks Reza, you solved my problem @ 5:10
Most welcome
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.
Glad you like them! Thanks so much for the awesome feedback.
Awesome. I was searching for the error message text right beside the respective control. thx :)
You're welcome!
Thank you. This video has helped my solved some validation issues.
Great to hear!
Your video tutorials always save my day. Thank you very much.
Glad to hear that!
thank you Reza, May God bless u
🙏
Thanks for creating these tutorials. Very helpful.
You're very welcome!
Hi, Reza! Won my LIKE and SUBSCRIPTION. Thank you for sharing this nice content video !!!
Greetings from Brazil !!!
Awesome, thank you!
Thank you so much... your videos are so helpful!
Your most welcome and thanks for watching the videos
This is a great video.
I need some guidance on how to make a field conditionally required if the user uploads an attachment.
You would need to check count of number of items in attachments control.
@@RezaDorrani you're the man! I didn't even think to do that SMH 🤦♂ Thank you!
Another great video, already thinking of the solutions I can provide now. Thanks
Excellent! Thanks for watching Ian.
Wow Reza -Ji - Thank you so much!
Most welcome ji
Thank you a lot! This video really showed what I needed!
Most welcome! Thanks for watching
Great video!!!!
Loved the weekday validation saved me hours scoring the internet!!!!
Awesome! Thanks for watching.
great video and very helpful. always able to learn new things from each video
So happy to hear that. That’s the goal of this channel. Thank you for watching.
Thanks for a great video about different techniques for validation.
Thank you for watching
Loved this video! Watching it I had some nice new ideas in mind for my next app. Glad to learn from such pro
Thank you Davide. Best of luck for your new App.
@@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
@@davidemercadante2406 Not at all. Go for it. Best of luck 🤞
@@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.
@@davidemercadante2406 That is correct. I use the same technique.
Hey! This is a great video, I've learned a lot on this 20 min. Thank you so much!!!!
Glad to hear that! Thank You for watching.
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?
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
Alex. you can disable the Submit button as Reza has suggested. This will prevent the form from being submitted with the validation errors.
You saved me, thank you as always Reza 👏❤
You're welcome 😊
Great Video!
Can you make video on Validate function
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.
Thank You Reza for detailed explanation😊
Most welcome
This was exactly what I needed. Thank you so much for posting! Subbed to check out what else you have.
Thanks for the sub!
Hi Reza,
Thanks for this video
Helps a lot... To work in this sort of scenario
Thank you
thanks as always Reza! your videos are very easy to understand and very useful!
Glad to hear that!
Love u from Chile, thanks!!
Thank You!
Great video! Thanks for sharing your knowledge!
My pleasure!
Hey this is super awesome and has a lot of uses. I am currently trying to validate if a user enters a date verses using the data picker, that they receive an alert if it is not in the correct format (MM/DD/YYYY). I have validated if MM/DD/YY is input by typing and the form is submitted, there won't be data in the SharePoint list in the date field. I thought a validation might help but all the formulas I have tried don't consistently work. Here is one if you can immediately see something I am off base on - Coalesce(Parent.Error, If(!IsBlank(DataCardValue3.SelectedDate) && !IsMatch(PlainText(DataCardValue3), Digit & Digit & "/" & Digit & Digit & "/" & Digit & Digit & Digit & Digit), "*Be sure to input in MM/DD/YYYY format", "")). I also notice in a lot of your formulas that you don't complete if statements. That has got me in trouble in the past. Do you do to speed up the video or do you truly not complete the formula?
Better option would be to superimpose a label control (empty text) on top of dat picker (text input part) - That way user has to pick date from the picker.
Can you show me at what time in video where I have not completed if statement?
Thanks for the quick response! That is a genius idea. Thank you. That was making me crazy. Didn't even think to remove the free text option.
At 14:17 the true criteria is your error text for true, wouldn't you need a "" to put the blank for the false of the If statement or am I totally off base?
@@juliereutbier6622 I made this video a year ago so do not remember each step, but the formula is fine.
I always show complete formulas :)
Thanks for confirming and the help!
I totally misspoke and the DefaultResult is optional. Thanks again for the support and ideas.
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?
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.
And a very HAPPY HAPPY HAPPY NEW YEAR TO you too my friend
@@RezaDorrani awesome 👌 brother
Another terrific tutorial - thanks, Reza
Thank you Jim
@@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.
@@jimfitch Every table comes with a default Name column which is required. You can add some data in Name column.
@@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.)
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.
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 :)
@@RezaDorrani good idea. I'll try that!
Thank you for this amazing video.
Your most welcome
Very useful video
Thanks
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.
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
Outstanding. Thanks for the great video
Thank you
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?
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
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!
Header title?
Good looking forms and galleries - czcams.com/video/aVEaRpAlaTA/video.html & czcams.com/video/bnC8u3gdWss/video.html
@@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?
@@samolppp9976 Check the video link I shared. I show how to rearrange and more.
Thank you Reza for the wonderful tutorial. Just a question. What visible property do you set for errormessage text control?
I must have shown that in video. Please check again.
Thanks Reza for the great tutorials have a great New Year
Thank you & Happy new year!
Great Video! Thank you for taking the time to create this!
You are most welcome
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?
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.
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.)
1) is not validation related :) It is to show hide data cards. Check my video on form control czcams.com/video/aVEaRpAlaTA/video.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 czcams.com/video/hJQjGE-oUpM/video.html
Also, the Border color red keep displaying, when enters into that screen,
it should display when during submission (when button click)
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.
HUGE Thank-you, Sir!
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 ) ?
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
Very useful tricks..
Is there any other videos by you for handling validation?
If yes, pls share if possible.
Currently this is the only one focused on validations.
Many other Apps and flow related videos do have some form of validations in them.
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?
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.
@@RezaDorrani looking forward to this especially customizing data cards. I've been struggling with data cards!
@@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.
@@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!
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
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.
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.
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.
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?
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
@@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.
@@jaytavare1618 👍
Great video Reza 🙂
Thanks Sonali
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...]
I’m not sure about that. May be there is a way.
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.
Check my video on form control - czcams.com/video/aVEaRpAlaTA/video.html
Bravo!
Thank You.
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.
I have an upcoming video on this - czcams.com/video/bnC8u3gdWss/video.html
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
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
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.
I did try it and it did not work. Guess, we will have to query the data source.
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?
Have not tried it so not sure. Give it a try and see if it works.
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 😊
A person column (assuming your data source is SharePoint) - if you need to just copy the data over to another field you can just set the default property of the data card. No validations required there.
Person column is special type and expects a particular format as follows:
rezadorrani.com/index.php/2020/05/04/power-apps-patch-function-with-sharepoint/
@@RezaDorrani Hi Reza,
Thanks for quick response 🙂
Will look into it
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.
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.
Nice video. Just want to know is there a validation for only Letter and/or Number ? Special characters are not allowed
IsMatch(
YourText,
"^[a-zA-Z0-9]*$"
)
@@RezaDorrani Thanks Reza
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!
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.
@@RezaDorrani Great thanks, let me try this
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.
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
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
For that I would keep error label and only remove star label
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!
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
Hello, just one query. How to add the unique constraint validation in Power Apps ?
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.
thanks Reza -very useful :)
Most welcome
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 ?
Probably possible but not something I have tried.
Many thanks! I am looking for match time (hh:mm AM/PM) in text input column. Please help
I do not have any video references for this scenario. I recommend posting your query on forums at powerusers.microsoft.com
HI Reza, This is good stuff. The only thing is that I cannot seem to create the correct syntax for matching a Project Title that is in a card with a text control. I tried several of the IsMatch options, but my custom error message shows all the time when I edit an item.
Text control has pattern or value?
Im assuming you would want to compare values.
@@RezaDorrani a string, for example, MondayTest 12-5-22
Coalesce(
Parent.Error,
If(
!IsBlank(DataCardValue1.Text) && !!IsMatch(
DataCardValue1.Text,
MatchOptions.Complete
),
"This title already exists"
)
)
Correction: Coalesce(
Parent.Error,
If(
!IsBlank(DataCardValue1.Text) && !IsMatch(
DataCardValue1.Text,
MatchOptions.Complete
),
"This title already exists"
)
)
only 1 exclamation point, still showing an error
@@marieraymond6512 IsMatch is to match pattern NOT value.
You could directly compare values like
DataCardValue1.Text = txtBoxControl.Text
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 ?
You cannot validate against a list of items.
You would need to add your own validation logic by showing an error message.
Hi Reza, thanx for the video. Is there a way to check the entire forma for error instead to check every error field?
True
Can u prepare an video on update context
In which refresh is to be used for updating the context
You mean the local variable function updatecontext?
I added this
Coalesce(
Parent.Error,
If(
Len(DataCardValue3.Text) 50,
"Must have a minimum of 50 characters"
)
)
This is working but the issue is I can still submit the SharePoint list form even it is less 50 characters. The "Save" button does not show when editing a SharePoint list/form in Power Apps.
Disable the save button until this is met.
@@RezaDorrani If(!IsBlank(ErrorMessage3.Text),Disabled,SubmitForm(SharePointForm1)) brilliant. Thanks!
Hi Reza
Please make a video on how to restrict users from entering decimal values more than 2 decimal points to an input field.
Il need a lot more folks requesting this to add it to my backlog
@@RezaDorrani Atleast can u share any idea on how to do?
@@rechaly6336 I would have to try it to give the idea. Check on forums powerusers.microsoft.com
@@RezaDorrani Figured it out using Len function... Calculated the length of data card n throw an error based on requirement.
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.
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 :)
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 - czcams.com/video/5dSk5iOgT68/video.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
@@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 :)
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?
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
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?
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
Hi Reza, at 11:32 you showed us how to validate the Serial Number text input only accepts number using Match.MultipleDigits. How can I modify the formula if I want the text input to accept digits and hyphen (such as \d\d\d\-\d\d or \d\d\d\-\d\d\-\d\d and any other format as long as they are digits and/or hyphens)? Really appreciate if you can shed me some lights and thanks in advance.
You can enter regex there. I would have to try it out to let you know the formula.
I will recommend posting your query on the forums at powerusers.microsoft.com/
Great video! Can powerapps do validation to make 2 columns unique? I need to lookup a person field and a dropdown to see if it already exists.
Yes, you will have to query your data source to check if other records with the same combination exist.
@@RezaDorrani thank you I did figure it out. Just had to get the syntax right.
@@tonicassis619 Great