I have a screen with 3 forms and a master form. When I try and submit a 'new' form I get an error
"An entry required or has an invalid value. Please correct and try again".
Now, if I go and edit a record or copy a record to edit and save as a new record I have no issues. It is only when I try and add a new record. I can't figure out why this is happening. The only things I believe I changed were some names like StarVisible to FieldName_StarVisible. I also set 3 datacards to Required but when the form failed to submit I changed them back. I don't believe I got an error then.
In addition I only receive the error message once. If I make a change to the data entered and try and submit nothing happens. No error message either. Any ideas what I need to do to track down the offending 'entry'?
Solved! Go to Solution.
That is correct. 3 child forms feed 1 master form. How that data gets written to the data source varies. In some cases it is new, some cases it is an edit and if varCopy = true then it is a copy of a record(as you would do with an edit) but submitted as a new record.
But to be clear, you are always submitting the master form which will include the data from all the 3 child forms?
The form itself should never be in New mode. Your cases of creating a new record, editing a record or copying a record will ALL be governed by the Item variable glbFormData.
Yes. That is correct. Somehow it broke along the way. instead of spending hours troubleshooting I rebuilt all 4 forms which took the better part of the work day. Along the way I took the liberty of fixing a few idiosyncrasies in naming table naming conventions and such. It works now. Just wish I knew what had broken in the first place and how to fix it. Without a detailed error I just couldn't track it down or spend the time doing so. Kind of bummer cause I hate wasting people's time here. Hopefully someone will find some useful nuggets in the thread.
This DOES happen sometimes with edit forms. Especially if you make any changes in the underlying datasource. Sometimes a form can "recover" from the changes and some times they get "stuck" and will only go away if you cut the form from the screen and paste it back, or remove and recreate the form completely. Just depends on the changes and what it gets stuck on.
BUT...sounds like you are underway now and I wouldn't consider it a waste of time as it is just another learning experience.
Check out new user group experience and if you are a leader please create your group
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.