cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JayFreedman
New Member

SubmitForm clears all fields, then errors on required field

I'm working on my first PowerApp, so assume I know nothing... I've been following the tutorials on powerapps.microsoft.com.

 

It's a simple three-screen app (Browse, Details, and Edit/Create) where the DataSource is a table in Dynamics CRM. The Edit/Create screen has one required field (LastName) and a dozen or so other fields including text fields and binary fields.

 

When the New button in the Browse screen is clicked and NewForm executes, the Edit/Create screen opens in New mode. I enter data in some or all of the fields, including LastName. When I click the Accept button to execute the SubmitForm function, the app first clears all the fields and then throws an error because the required field is empty. Nothing ever gets submitted to the database.

 

Does anyone have a clue about why the fields are being cleared?

12 REPLIES 12
v-micsh-msft
Community Support
Community Support

Hi @JayFreedman,

 

That should be caused by the Editform control.

Once there is a record submitted, it will then switch to Newform mode, which would clear all the input boxes.

Check the document below for more information about form controls:

 

Edit form and Display form controls in PowerApps

Please refer to the Create Record part.

Besides, for the error message you encountered, that should be caused by some required fields have no data when submitting.

Please make sure all the fields which have been marked with " * " is filled with proper data.

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

As I described in my original post, the record is not being submitted, because the clearing of the fields and the appearance of the error message occur first. This is not the normal operation of the SubmitForm action. The record never reaches the database, as I can prove by either refreshing the Browse screen or by logging into Dynamics CRM and examining the table.

 

I need to know what is causing the fields to be blanked out because this is an absolute show-stopper.

Any additional ideas?

No ideas but got the same problem. Did you find a solution?

 

Regards,

Fabian

Hi Fabian,

 

No, I never solved this problem. Fortunately for me, I've moved on and it's now somebody else's problem.

Hi Jay,

 

That is also a solution Smiley Wink. I solved it. The problem that I encountered was in the SP list. The Title column is always there for some reason. I tried to hide is but it is required. So i added it to power app. I put unique radom valeus in it and make it the same colour (white) as the background at the buttom of the form. This solved the problem for me.

 

Regards,

Fabian

I have this same problem.  My form is connected to SharePoint list and I have two date fields that are required.  If I fill out the title and all the other fields on the form then hit the Check in upper right corner to submit the form it gives the error that the date field is required but clears out all the other fields in the entire form.

vaishalivyas1
Helper III
Helper III

Hi,

 

Even I am facing this problem . I have searched alot but nothing is working for me. I am using CRM as data source. 

Hi @sscarcella

 

You got any solution for this? even I am facing this problem.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (48,492)