Hi - I am attempting to use the errors function in PA.
I have a sharepoint list using the following command to PAtch updates t othe list.
Patch('Secure Print Assessments',First(Filter('Secure Print Assessments', ID=CustomerGallery.Selected.ID)),GAForm.Updates))
This seems to work fine as I can update the record. I do have some required fields in the SP List. I have made them required in the SP List and also in set as True in the Data Card on the form.
I have created a label and added in the folowing as its Text
First(Errors('Secure Print Assessments',First(Filter('Secure Print Assessments', ID=CustomerGallery.Selected.ID)))).Message
My problem is that nothing shows in this label after doing the Patch - I have made sure there is nothing in the required field. I have set the borderColor to If(IsBlank(dcvOppID.Text),Red,RGBA(0, 150,214, 1)). When it is empty it has a red border and a blue when it has an entry.
A couple of questions - does the Form.Updates option only look for changes? e,g, if it was already empty but I changed nothing would it see no changes and therefore not do the Patch? I have tried adding an entry and saving it and then removing it but still no luck.
How does the errors table get populated? Can I access it anywhere to check it? I am assuming that the ErrorKind.MissingRequired should be triggered when I use Patch but there is no value - is this a correct assumption?
Any assistance is appreciated as I have followed the Errors documentation here https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-errors but cannot get it working.
I have also tried using the EditRecord as a Context field but I get errors if I do not use ID=CustomerGallery.Selected.ID
I have made a test and the issue is confirmed on my side. Even though, I set the Required property for some fields in my SharePoint list, when I enter empty value within the required column in my PowerApps app, the Patch() function that you provided works successfully without error. No error message is shown up within the Label control.
I think the formula that you provided is correct, I have posted this issue to my product team, if this issue is solved, I would reply here.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.