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 RUclips 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.
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
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 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.
@@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.)
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?
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
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
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 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?
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.
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 ruclips.net/video/aVEaRpAlaTA/видео.html Yes/no columns should be avoided as much as possible. Check rezadorrani.com/index.php/2019/04/14/powerapps-filter-sharepoint-yes-no-column-bug/ 2) There can only be 1 attachment control per form. However, there are some hacks that you can apply. Check ruclips.net/video/hJQjGE-oUpM/видео.html
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
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.
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.
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...]
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.
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/
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
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.
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 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.
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
Happy New Year Reza! Thanks for another fantastic video. I knew some basic data validation techniques, but this really takes it to the next level when it comes to complex scenarios. Rather than an If statement on the Submit button, would it be possible to use the form.valid internal property in this scenario to dictate the display mode of the button?
The form.valid checks only if the required fields are not empty and don’t validate the database requirements in the background. Because I wanted to use the Form.valid function, I modified the requirement Settings of one field. So it is only required, if all my ismatch()-function for all my form fields are matched. With this, the Form.valid runs perfectly. But of course, it’s just another work around. I’ve created a Poweruser Community Idea, maybe we will get sometimes a better solution for that case: powerusers.microsoft.com/t5/Power-Apps-Ideas/Forms-field-only-valid-when-isMatch-is-true/idi-p/495028
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 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
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 - ruclips.net/video/5dSk5iOgT68/видео.html I would also recommend you to post your issues on the forums at powerusers.microsoft.com/ Many a times folks already have solution to common problems on the forums
@@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 :)
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.
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 ?
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
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 ?
Reza, Thanks again for the great tutorials. I was wondering if there is something similar to Page.IsValid (in asp.net) rather than checking each and every control in the if statement? (especially for a form with lots of controls). Or also like in erstwhile VB, can we have all the error label named the same thing (this can be a workaround to the problem)?
There is a Form.IsValid property but goal here it to show the error messages on the fly as user makes the updates. Moreover, we are adding additonal validation logic to the data cards of the form control which are not part of the backend data source.
Hi! It's good to see you after all this time. Now, my data source is dataverse for teams, so I have two DataCards (we called X1 and X2 in this example) in which I want to insert numbers. When I go to edit the ErrorMessage of the respective DataCard one appears with DataCardValueX1.Value and the other with DataCardValueX2.Text, while DataCard of X2 works because only allows me to write numbers, the other DataCard X1 don't. Thanks for the help
I'm soorry for that :( I just change the visible property of the ErrorMessage in the DataCard and apparently that's how it worked for me, I don't know if this is the best way. Thanks for your time.
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
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
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!
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
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.
Hands down the best Power Apps channel on RUclips
Wow! Thank you 🙏
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
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.
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
Amazing video; in my opinion you are providing the best content in this field. Thank you very much!
Thank You Jerome
Many thanks for a very helpful video. God bless you real good.
Glad it was helpful!
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:)
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, you solved my problem @ 5:10
Most welcome
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 RUclips Channel.
Thank You so much
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 :)
You are a genius and a great teacher
Thank You so much
You are the best!!, thanks for all this videos about power apps and automate.
Thank You for your kind words
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!
Thank you so much... your videos are so helpful!
Your most welcome and thanks for watching the videos
thank you Reza, May God bless u
🙏
Wow Reza -Ji - Thank you so much!
Most welcome ji
Another great video Reza - thank you. I’m slowly making it through your content. IMO you’re the #1 PowerApps tutor on RUclips. Please keep it up.
Wow! Thanks so much Simon.
Thanks Reza for this great video. So many useful scenarios indeed. Much more than I was looking for!
Thanks for watching Amr
Your video tutorials always save my day. Thank you very much.
Glad to hear that!
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!
Hi, Reza! Won my LIKE and SUBSCRIPTION. Thank you for sharing this nice content video !!!
Greetings from Brazil !!!
Awesome, thank you!
Love u from Chile, thanks!!
Thank You!
Another great video, already thinking of the solutions I can provide now. Thanks
Excellent! Thanks for watching Ian.
Thanks for a great video about different techniques for validation.
Thank you for watching
Thank You Reza for detailed explanation😊
Most welcome
Very useful video
Thanks
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 a lot! This video really showed what I needed!
Most welcome! Thanks for watching
You saved me, thank you as always Reza 👏❤
You're welcome 😊
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.
This was exactly what I needed. Thank you so much for posting! Subbed to check out what else you have.
Thanks for the sub!
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.
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.
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!
Great video! Thanks for sharing your knowledge!
My pleasure!
Hi Reza,
Thanks for this video
Helps a lot... To work in this sort of scenario
Thank you
Great video!!!!
Loved the weekday validation saved me hours scoring the internet!!!!
Awesome! Thanks for watching.
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
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.
thanks as always Reza! your videos are very easy to understand and very useful!
Glad to hear that!
Outstanding. Thanks for the great video
Thank you
HUGE Thank-you, Sir!
Thank you for this amazing video.
Your most welcome
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.)
Thanks Reza for the great tutorials have a great New Year
Thank you & Happy new year!
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.
Bravo!
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
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!
Great video Reza 🙂
Thanks Sonali
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 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.
Great Video! Thank you for taking the time to create this!
You are most welcome
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
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 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 - ruclips.net/video/aVEaRpAlaTA/видео.html & ruclips.net/video/bnC8u3gdWss/видео.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.
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 - ruclips.net/video/aVEaRpAlaTA/видео.html
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.
thanks Reza -very useful :)
Most welcome
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 ruclips.net/video/aVEaRpAlaTA/видео.html
Yes/no columns should be avoided as much as possible. Check rezadorrani.com/index.php/2019/04/14/powerapps-filter-sharepoint-yes-no-column-bug/
2) There can only be 1 attachment control per form. However, there are some hacks that you can apply. Check ruclips.net/video/hJQjGE-oUpM/видео.html
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 👍
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 - ruclips.net/video/bnC8u3gdWss/видео.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.
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.
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.
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
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
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
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.
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 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.
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
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
Happy New Year Reza! Thanks for another fantastic video. I knew some basic data validation techniques, but this really takes it to the next level when it comes to complex scenarios. Rather than an If statement on the Submit button, would it be possible to use the form.valid internal property in this scenario to dictate the display mode of the button?
Yes, you can. I did test that technique. It did not respect my custom validations that I added to the data cards.
Happy New Year to you too!
@@RezaDorrani okay, good to know. Thanks for providing a work around when .valid won’t work.
The form.valid checks only if the required fields are not empty and don’t validate the database requirements in the background.
Because I wanted to use the Form.valid function, I modified the requirement Settings of one field. So it is only required, if all my ismatch()-function for all my form fields are matched. With this, the Form.valid runs perfectly. But of course, it’s just another work around.
I’ve created a Poweruser Community Idea, maybe we will get sometimes a better solution for that case:
powerusers.microsoft.com/t5/Power-Apps-Ideas/Forms-field-only-valid-when-isMatch-is-true/idi-p/495028
@@Mx81 Your idea just got an upvote.
Gracias!!!
Gracias por mirar
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 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
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 - ruclips.net/video/5dSk5iOgT68/видео.html
I would also recommend you to post your issues on the forums at powerusers.microsoft.com/
Many a times folks already have solution to common problems on the forums
@@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 :)
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.
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.
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
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
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.
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?
👍👍👍 👏👏👏
👍
Reza, Thanks again for the great tutorials. I was wondering if there is something similar to Page.IsValid (in asp.net) rather than checking each and every control in the if statement? (especially for a form with lots of controls). Or also like in erstwhile VB, can we have all the error label named the same thing (this can be a workaround to the problem)?
There is a Form.IsValid property but goal here it to show the error messages on the fly as user makes the updates. Moreover, we are adding additonal validation logic to the data cards of the form control which are not part of the backend data source.
@@RezaDorrani I get that, I was only wondering from the perspective of Submit button enabling and disabling.
Great video...very useful
@@ashokpershad Thank you
Hi! It's good to see you after all this time.
Now, my data source is dataverse for teams, so I have two DataCards (we called X1 and X2 in this example) in which I want to insert numbers.
When I go to edit the ErrorMessage of the respective DataCard one appears with DataCardValueX1.Value and the other with DataCardValueX2.Text, while DataCard of X2 works because only allows me to write numbers, the other DataCard X1 don't.
Thanks for the help
Hi Miguel, honestly I did not understand your query.
I'm soorry for that :(
I just change the visible property of the ErrorMessage in the DataCard and apparently that's how it worked for me, I don't know if this is the best way.
Thanks for your time.
Hi Reza, thanx for the video. Is there a way to check the entire forma for error instead to check every error field?
True
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