This is my very first video from you and if you have other videos about powerapps properties like the ones you have here for valid, required, and other properties for different controls and how to manipulate all their properties, those videos would greatly help since there are still not a lot of informative videos on powerapps as compared to VBA where I'm more use to. Aside from that, I really enjoyed how easy it is to follow this lesson! Thank you!
just started the tutorial, you mention at the begin (and I think you mentioned it in the first video) using PATCH to commit data? Would be good to explain what PATCH is at the start of the video 👍 (....on with the video)
Great video Dave. Just to point that here the Asterisk validation wouldn't be an issue once we have the Submit button disabled until all fields completed :)
you are a savior! I have wasting my time guessing what code to be use for blank fields in button, thanks for your video. now I have 1 thing to do, how can I include required on Signature(Pentool)? gonna find my own way but i hope you will give me an idea. LOL
Thank you very much for the feedback, much appreciated. You can use the OnsSelect event on the PenInput to set a variable to pick up if someone clicked on it. Please let me know if you don't come right.
This's very well explained tutorial and Thank you Dave. I am trying to figure out why in my case, the 'lblErrorMessage" is not auto height and how to fix this. The Y (of Editform1)= lblErrorMessage.Y+lblErrorMessage.height.
Hello, thanks for the nice tuto. How could I for example implement more validation logic as for example if I need to reach one outside web service for some calculation and catch the answer and then decide the validation status according to those remote calculations? Kind regards.
OMG! you just simply cant realize how this video has help me!!! i would like to put more LIKE in your video (if TH-cam would let me).. Thank you soooooooooooo much! And a question if I can: I need to make an IF in a error label (like the one you make) but the field contains options (a menu) and i cant make it work (for example): If(DataCardValue1.Selected = "Home" , "Error")... I Dont Know how to fix this.
Thank you very much for the feedback Nicolas, much appreciated man and I am glad you found this helpful. If the control that you referring to is a drop down with a text array in it, then you should be able to do DataCardValue1.Selected.Value = "Home". If it contains a list of objects, then you would need to specify Selected.PropertyName that should be checked for the value of Home. Eg, Selected.Location="Home"
@@DavesTechTips I made a label that show error notifications (like the one you do in the video) with 4 formulas. But the resoluion gave me a "False" they appears in the order that i Wrote them. I need that they appears on top when they are "false" (the formula number 4 appears in the line number 4). Is there a way to do it? If(DataCardValue2.SelectedDate < Today(),"Line 1") & Char(13) & Char(10) & If(DataCardValue2.SelectedDate = Today(),"Line 2") & Char(13) & Char(10) & If((DataCardValue5.Text) = "Homeoffice", "Line 3") & Char(13) & Char(10) & If(DataCardValue1.Selected.Value = "Nico" , "Line 4")
@@nicolascarrio8484 As as test I put the following in a formula: If( Today() < Today(), "Line 1" ) & Char(13) & Char(10) & If( Today() = Today(), "Line 2" ) & Char(13) & Char(10) & If( "Homeoffice" = "Homeoffice", "Line 3" ) & Char(13) & Char(10) & If( "Nico" = "Nico", "Line 4" ). The result is Line 2 Line 3 Line 4 ...which seems to be correct.
looks like MS have change the default error message from "An entry......etc,etc,etc......and try again" to " is required" i.e. ExpenseAmount is required.
Hi Dawid, do you have a tutorial in adding a camera and preview photo to an existing power app please? The output is Sharepoint lists and I want to store the photo alongside the data collected in the app. The app data part is already done and the sharpoint list is already built/working. Thanks, Mike
Hi Mike, that is a good idea. I think that might be a great idea for the popup component as well, to be able to just quickly grab a picture and store it somewhere. I will add this to the popup wish list. aka.ms/powerapps-popup
I know I'm a year late on this one, but I'm new to PowerApps and loving your guides! Is it possible to check and show an error if the selected date and time is greater than the current date and time? (to stop a user submitting a future date and time) I'm trying a few things here, based on your lesson here, but i cant quite crack it :(
@@DavesTechTips I added it as a condition to my patch statement. So now it prevents saving without required fields. Overall I handle validation a bit different. I have customs rules I need to test for so I store each rule as an object in a collection with a property called "Pass". Then I filter on that property on Save. If there's anything that's Pass=False left in the collection, I prevent the save.
This is a great way to have more organized data validation - something I was pulling my hair out about! Thanks so much!
There's something to learn on PowerApps everyday! Understood many little nuances today. Thanks for sharing! Keep up the great work!!
This is my very first video from you and if you have other videos about powerapps properties like the ones you have here for valid, required, and other properties for different controls and how to manipulate all their properties, those videos would greatly help since there are still not a lot of informative videos on powerapps as compared to VBA where I'm more use to. Aside from that, I really enjoyed how easy it is to follow this lesson! Thank you!
just started the tutorial, you mention at the begin (and I think you mentioned it in the first video) using PATCH to commit data?
Would be good to explain what PATCH is at the start of the video 👍
(....on with the video)
i have wondered how to get started on PowerApps, glad i came across your channel! very informative and simplified, thanks Dave!
Thanks Dave, just started with power apps and power automate and your videos rock!
Thank you so much for the feedback Filip, I am glad you find them useful!
Thanks Dave - forms validation is such a real world issue as it helps us to add business logic to our apps. I was doing this only today!
Hey Rory thanks for the message and for pretending that you learnt something new (",)
Great video Dave. Just to point that here the Asterisk validation wouldn't be an issue once we have the Submit button disabled until all fields completed :)
A very clear and succinct explanation of PowerApps validation. Thank you Dave :-)
Thank you for the feedback Russell, much appreciated and I am glad you found this useful 😀👍
Excellent video! Thank you!
Thanks so much, it was very helpful 🥰
Thank you Dave... for Excellent tutorial PowerApps
Glad it was helpful! Thanks for the message.
Excellent Tutorials. Went through a few others before I found your set. Thanks...
Thank you for the feedback Donald, glad you like them!
very clear explanation. Thank you Dave!. I will use this knowledge to build my first power apps.
Excellent, have great fun doing it! Thank you for the feedback, much appreciated.
Thank you David. May I know how can we only display the date instead of date+time in the field? Thank you very much.
Thank you so much, Dave. You saved me. 👍
Thank you so much for the feedback, very happy to hear that you found it useful 😊👍🏻
Very useful video. Thank you, Dave!
Thank you for the feedback, Glad you found is useful Gabor.
you are a savior! I have wasting my time guessing what code to be use for blank fields in button, thanks for your video. now I have 1 thing to do, how can I include required on Signature(Pentool)? gonna find my own way but i hope you will give me an idea. LOL
Thank you very much for the feedback, much appreciated. You can use the OnsSelect event on the PenInput to set a variable to pick up if someone clicked on it. Please let me know if you don't come right.
very clear and succinct. Thanks!
Thank you so much for the feedback, much appreciated.
This's very well explained tutorial and Thank you Dave.
I am trying to figure out why in my case, the 'lblErrorMessage" is not auto height and how to fix this. The Y (of Editform1)= lblErrorMessage.Y+lblErrorMessage.height.
AMAZING !!! Thank you so much ! Very appreciated....
You're very welcome, glad you found this useful. This has really helped us to fully use forms.
Really appreciate..
What is char(13) and char(10)
Hello, thanks for the nice tuto. How could I for example implement more validation logic as for example if I need to reach one outside web service for some calculation and catch the answer and then decide the validation status according to those remote calculations?
Kind regards.
Thank you! This was a very helpful video!!
Thank you Joanna, glad you found this helpful
Thank you! This was a helpful video :)
Thanks for the feedback, glad this could help you.
Good Job! Helpful.
Thank you so much for the message Edgar!
Great video. One question. How do you do validation against a list?
Hi Torban, thanks for the feedback. Not sure I understand that you mean by validating against a list, could you give me more information?
OMG! you just simply cant realize how this video has help me!!! i would like to put more LIKE in your video (if TH-cam would let me).. Thank you soooooooooooo much! And a question if I can: I need to make an IF in a error label (like the one you make) but the field contains options (a menu) and i cant make it work (for example): If(DataCardValue1.Selected = "Home" , "Error")... I Dont Know how to fix this.
Thank you very much for the feedback Nicolas, much appreciated man and I am glad you found this helpful. If the control that you referring to is a drop down with a text array in it, then you should be able to do DataCardValue1.Selected.Value = "Home". If it contains a list of objects, then you would need to specify Selected.PropertyName that should be checked for the value of Home. Eg, Selected.Location="Home"
@@DavesTechTips I made a label that show error notifications (like the one you do in the video) with 4 formulas. But the resoluion gave me a "False" they appears in the order that i Wrote them. I need that they appears on top when they are "false" (the formula number 4 appears in the line number 4). Is there a way to do it?
If(DataCardValue2.SelectedDate < Today(),"Line 1") & Char(13) & Char(10) &
If(DataCardValue2.SelectedDate = Today(),"Line 2") & Char(13) & Char(10) &
If((DataCardValue5.Text) = "Homeoffice", "Line 3") & Char(13) & Char(10) &
If(DataCardValue1.Selected.Value = "Nico" , "Line 4")
@@nicolascarrio8484 As as test I put the following in a formula: If(
Today() < Today(),
"Line 1"
) & Char(13) & Char(10) & If(
Today() = Today(),
"Line 2"
) & Char(13) & Char(10) & If(
"Homeoffice" = "Homeoffice",
"Line 3"
) & Char(13) & Char(10) & If(
"Nico" = "Nico",
"Line 4"
). The result is
Line 2
Line 3
Line 4
...which seems to be correct.
@@DavesTechTips thank you again! I will test it!
looks like MS have change the default error message from
"An entry......etc,etc,etc......and try again"
to
" is required"
i.e.
ExpenseAmount is required.
thx bro saved the day
Wonderful!
Thank you very much Afonso, much appreciated man. 👍
Hi Dawid, do you have a tutorial in adding a camera and preview photo to an existing power app please? The output is Sharepoint lists and I want to store the photo alongside the data collected in the app. The app data part is already done and the sharpoint list is already built/working. Thanks, Mike
Hi Mike, that is a good idea. I think that might be a great idea for the popup component as well, to be able to just quickly grab a picture and store it somewhere. I will add this to the popup wish list.
aka.ms/powerapps-popup
Good one
Thank you so much for the feedback Guruprasad.
Great video...helpful!!
Thank you Richard, glad you found this helpful.
I know I'm a year late on this one, but I'm new to PowerApps and loving your guides!
Is it possible to check and show an error if the selected date and time is greater than the current date and time?
(to stop a user submitting a future date and time)
I'm trying a few things here, based on your lesson here, but i cant quite crack it :(
Try this: If(DateValue1.SelectedDate > Today(), "Cannot be future date")
@@PeterPanQuails thanks for that. Good thinking, that looks like it should work.
I'll give it a try.
time is taking as default..how can i make time madatory?
Is it mandatory to use a form before we can try and implement validation on powerapps?
Very useful, thanks.
Kessy Similien , thank you. Would like to see how you use it in your applications
@@DavesTechTips I added it as a condition to my patch statement. So now it prevents saving without required fields. Overall I handle validation a bit different. I have customs rules I need to test for so I store each rule as an object in a collection with a property called "Pass". Then I filter on that property on Save. If there's anything that's Pass=False left in the collection, I prevent the save.
Hi sir how to validate mobile number with otp let me know sir
Nice Walter White