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.
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 👏👍
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 UA-cam 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.
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)
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 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.)
@@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.
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.
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 :)
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.
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/
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
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..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.
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.
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.
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.
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
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
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Hi I have a date picker for searching the data but the picker is not working for previous year. only picking the current year can you please guide me how to resolve this
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
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
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.
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.
Depends on when you are storing data into that variable and how it is being used in the form. Tough to provide any guidance here on chat without looking at your App. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
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
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
I have never tried this hence not sure if this is possible. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
I have 2 columns of dropdown value, pulling from the same list. I need to ensure the selected values of 2 column are not the same. Say if "xxx" is selected in column 1, then selecting "xxx" again in column will violate the rule. How to write the validation rule? Thanks
Something like Dropdown1.Selected.Value Dropdown2.Selected.Value I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
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?
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
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?
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.
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?
for serial number vlidation when i am writing this formulae, Coalesce(Parent.Error, If( !IsBlank(DataCardValue5.Text)&& !IsMatch( DataCardValue5.Text, Match.MultipleDigits ), "numbers only" ) ) I am getting the error of "this rule creates a circular reference between properties, which is not allowed. A property cannot reference itself or other properties affected by its value."
Hmmn. 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 Reza, I have a scenario where it has 5 Choice pills columns in a form(source from SP List) with values as 10%, 20% and 30% respectively. The total of all 5 columns should be 100%, if form doesn't meet the total expected values of 100%, then form should thrown an error and user should correct the values to 100% in total using the 5 columns. Is it possible to achieve this in PowerApps. Your help would be highly appreciated. Thank you!!
Possible but 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, 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
I have created a simple form for my stakeholders to provide project information so that will be stored in a share point list. But for some reason, the validation does not work on the submit button, even after I make those columns as a required field. The user can enter one piece of data and click submit or just fill in one field and click on submit. The form success screen is coming either way. Please suggest. This is the formula that i have used. SubmitForm(Form1);Navigate(Screen2)
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
How to validate that the user who is creating the item is different that a value enter on person or group column and do not allow submit the form until they are not same??
@@RezaDorrani I tried OnSelect this but shows in red submitform If(user().email=datacardvalue3.selected.email, notify(“sorry….”;notificationtype.error),submitform(sharepointform1)) Any thoughts?
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
Thanks a lot Reza, this is very useful! However, I am facing one issue. Whenever I use edit mode in displaymode of save button, there is a new version of the item created in the SP list. The first version has all the correct entries. But in the new version of the item, one of the required fields starts displaying empty value and this stops the workflow from running in the back end. Can you please help me out?
I would have to look at your app in action to know the reason for your issue. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
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?
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
My guess would be the formula that shows the message. I will recommend posting your issue with screenshots (formula/column type) on forums at powerusers.microsoft.com
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 - ua-cam.com/video/5dSk5iOgT68/v-deo.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 :)
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 UA-cam
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!
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.
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 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
Exactly what I was searching for! Thanks a lot and very good explained as well!
Most welcome
Another great video Reza - thank you. I’m slowly making it through your content. IMO you’re the #1 PowerApps tutor on UA-cam. Please keep it up.
Wow! Thanks so much Simon.
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 UA-cam Channel.
Thank You so much
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
Hi, Reza! Won my LIKE and SUBSCRIPTION. Thank you for sharing this nice content video !!!
Greetings from Brazil !!!
Awesome, thank you!
You are the best!!, thanks for all this videos about power apps and automate.
Thank You for your kind words
Thanks Reza for this great video. So many useful scenarios indeed. Much more than I was looking for!
Thanks for watching Amr
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.
Thanks for creating these tutorials. Very helpful.
You're very welcome!
Your video tutorials always save my day. Thank you very much.
Glad to hear that!
Awesome. I was searching for the error message text right beside the respective control. thx :)
You're welcome!
Dear Reza You are doing a Noble Job I have No words to Thank your Help to beginners like me.
Thank you Prem
Great video!!!!
Loved the weekday validation saved me hours scoring the internet!!!!
Awesome! Thanks for watching.
Thank you. This video has helped my solved some validation issues.
Great to hear!
You are a genius and a great teacher
Thank You so much
This was exactly what I needed. Thank you so much for posting! Subbed to check out what else you have.
Thanks for the sub!
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.
Thanks Reza, you solved my problem @ 5:10
Most welcome
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:)
This has been extremely helpful, thank you!
Glad it was helpful!
Thanks for a great video about different techniques for validation.
Thank you for watching
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.
thanks as always Reza! your videos are very easy to understand and very useful!
Glad to hear that!
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.)
You saved me, thank you as always Reza 👏❤
You're welcome 😊
Great video! Thanks for sharing your knowledge!
My pleasure!
Many thanks for a very helpful video. God bless you real good.
Glad it was helpful!
Another great video, already thinking of the solutions I can provide now. Thanks
Excellent! Thanks for watching Ian.
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.
Thank You Reza for detailed explanation😊
Most welcome
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.
Thank you so much... your videos are so helpful!
Your most welcome and thanks for watching the videos
Love u from Chile, thanks!!
Thank You!
Outstanding. Thanks for the great video
Thank you
Great Video! Thank you for taking the time to create this!
You are most welcome
Thanks Reza for the great tutorials have a great New Year
Thank you & Happy new year!
Hi Reza,
Thanks for this video
Helps a lot... To work in this sort of scenario
Thank you
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!
thank you Reza, May God bless u
🙏
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
Wow Reza -Ji - Thank you so much!
Most welcome ji
Great video Reza 🙂
Thanks Sonali
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.
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
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.
HUGE Thank-you, Sir!
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/
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.
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..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.
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.
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.
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, 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.
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.
Very useful video
Thanks
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
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
I have a required field set in sharepoint and also a required field on the edit form but when I click submits without validation
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
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?
Hi I have a date picker for searching the data but the picker is not working for previous year. only picking the current year can you please guide me how to resolve this
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
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
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.
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
thanks Reza -very useful :)
Most welcome
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,
How to store global variable in a text field? after submitting the form my global variable field becoming empty
Depends on when you are storing data into that variable and how it is being used in the form. Tough to provide any guidance here on chat without looking at your App. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com
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
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
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
Hi Reza, Can we show the Power Automate flows list in the Power Apps gallery.
I have never tried this hence not sure if this is possible. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
I have 2 columns of dropdown value, pulling from the same list. I need to ensure the selected values of 2 column are not the same. Say if "xxx" is selected in column 1, then selecting "xxx" again in column will violate the rule. How to write the validation rule? Thanks
Something like Dropdown1.Selected.Value Dropdown2.Selected.Value
I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani Thank you.
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?
By comparing the 2 values I guess. Sorry but I do not have a specific video on this scenario and hence only guessing.
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
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
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 - ua-cam.com/video/aVEaRpAlaTA/v-deo.html & ua-cam.com/video/bnC8u3gdWss/v-deo.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.
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.
I don't think there is an optional comma option. I will recommend you check on the forums at powerusers.microsoft.com/
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
for serial number vlidation when i am writing this formulae,
Coalesce(Parent.Error,
If(
!IsBlank(DataCardValue5.Text)&&
!IsMatch(
DataCardValue5.Text,
Match.MultipleDigits
),
"numbers only"
)
)
I am getting the error of "this rule creates a circular reference between properties, which is not allowed. A property cannot reference itself or other properties affected by its value."
Hmmn. 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 Reza, I have a scenario where it has 5 Choice pills columns in a form(source from SP List) with values as 10%, 20% and 30% respectively. The total of all 5 columns should be 100%, if form doesn't meet the total expected values of 100%, then form should thrown an error and user should correct the values to 100% in total using the 5 columns. Is it possible to achieve this in PowerApps. Your help would be highly appreciated. Thank you!!
Possible but 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, 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 👍
I have created a simple form for my stakeholders to provide project information so that will be stored in a share point list. But for some reason, the validation does not work on the submit button, even after I make those columns as a required field. The user can enter one piece of data and click submit or just fill in one field and click on submit. The form success screen is coming either way. Please suggest. This is the formula that i have used.
SubmitForm(Form1);Navigate(Screen2)
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
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
How to validate that the user who is creating the item is different that a value enter on person or group column and do not allow submit the form until they are not same??
You can check User().Email which gives current logged in user email with the person column control (combo box) - combobox.Selected.Mail
@@RezaDorrani
I tried OnSelect this but shows in red submitform
If(user().email=datacardvalue3.selected.email, notify(“sorry….”;notificationtype.error),submitform(sharepointform1))
Any thoughts?
@@dtodounpocomx_nl Formula looks fine! I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com/
@@RezaDorrani the problem was the borderthickness , so I added a condition to increase or reduce borderthickness and that it
Thank you!
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
Thanks a lot Reza, this is very useful! However, I am facing one issue. Whenever I use edit mode in displaymode of save button, there is a new version of the item created in the SP list. The first version has all the correct entries. But in the new version of the item, one of the required fields starts displaying empty value and this stops the workflow from running in the back end. Can you please help me out?
I would have to look at your app in action to know the reason for your issue. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@@RezaDorrani Sure, thank you, will do so. Did not expect to get a reply this early on UA-cam 😄
@@bharatishukla1358 😊
@@RezaDorrani done!
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 what if we are using Patch function to submit and check all error validations before submit?
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza, thanx for the video. Is there a way to check the entire forma for error instead to check every error field?
True
After I changed the datacard required=true, the error is always showing up. Regardless I have input value or not. What would be the mistake?
My guess would be the formula that shows the message. I will recommend posting your issue with screenshots (formula/column type) on forums at powerusers.microsoft.com
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 - ua-cam.com/video/5dSk5iOgT68/v-deo.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 :)