Hi, I hope I am not re-treading water here, but have been searching forums and either found fixes that do not work for me or finding other scenarios are not quite the same as I experience.
In Short – when a PowerApp Form is submitted without one or more mandatory fields being filled in, then the fields are saved and we get the error: An entry is required or has an invalid value. Please correct and try again.
I would now like to go into detail:
This problem might be addressed by the fix referenced by Sketz on 21 April here: https://powerusers.microsoft.com/t5/General-Discussion/PowerApps-Version-3-18042-An-entry-is-required-or-has-an-invalid/td-p/107851
But there is no confirmation that the fix was applied. If this will fix it then does anyone know when the fix is being applied.
My story is this:
I was tasked this year in building a workflow using Powerapps Writing to a Sharepoint List. I had a deadline to have something working by the end of March.
I just about managed this. However one of the very last things I did was apply all the required fields for mandatory information. This was all applied in the PowerApp, leaving the SharePoint List all non-mandatory.
The problem was that if a user did not fill in a mandatory field, instead of the form not submitting, and a message under the relevant field that needs filling in (which is highlighted in red), the PowerApp displayed the error message:
An entry is required or has an invalid value. Please correct and try again.
In a red banner at the top of the screen and submitted what was being entered anyway.
I now have the time to revisit the App and sort out this and other bugs. I made a template out of the live SharePoint List, put it in my development site and developed a new PowerApp to submit a record. After setting up the App, I started adding Required = True to certain fields one by one (the finished product will have some fields required in any event, others have their visible/required fields managed by conditions – but in recreating the PowerApp I did not get as far as conditional statements).
So adding Required=True for the first few was fine. At each step I tested and if I tried submitting without filling in a field the field was highlighted with a request to fill it in, and the record was not saved. Then suddenly the PowerApp reverted to the behaviour I had before (saving data even with a field not filled in and giving the message: An entry is required or has an invalid value. Please correct and try again.
Looking at other forums I tried the following:
Made all fields in the PowerApp not required (it submitted fine) and then re-applied a required field – error returned.
Also in the SharePoint List, originally none of the fields were mandatory. However I made all fields mandatory in SharePoint, made them all non-Mandatory again and tried again – same problem.
Can anyone give me any hints, I have seen a few posts about a fix being considered, but I will need to report back to my employers with some sort of roadmap if this is the case.
Cheers,
AndyC
