Hello Power Apps Community... and hopefully @RandyHayes if possible.
Hello Randy,
I hope you're well. I used your Forms video on YouTube, which as I said before is the best, but I'm facing a different challenge at the moment which I hope you could help with please.
I'm using Dataverse for Teams.
I have a form with many datacards.
Three data cards I've added custom errors, but the rest I want to use the validation errors from the database.
I have a icon that let's me edit or save the form.
I've put some validation on the save icon DisplayMode which is the below:
If(
(frmMetrics.Mode = FormMode.View || (frmMetrics.Valid && frmMetrics.Unsaved)) And !crdErrorIncidentTime.Visible And !crdErrorResponseTime.Visible And !crdErrorRequest.Visible,
Edit,
Disabled
)
This works great, but what I'm seeing is, if one of my datacards, which doesn't have a custom error on it, does not have the correct data input, example, a column's maximum value is 5, so I can only put from 0 to 5, it never throws an error.
This is because, I believe, the error only fires when I try and save the form to the database. As I'm disabling the save icon, as per formula above, the user can never click the icon and try and save it to the database to receive the error.
So my question is, any ideas how to get the database errors to show immediately rather than having to enable the save icon to allow them to save the record? I really don't want to have to add a custom error message on each data card if possible.
Thanks very much,
Garry
