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

Error - An entry is required or has an invalid

All off a sudden I get an error when editing a shareopoint list item that has  a custom powerapp sharepoint edit form, with no changes made to the app in a month. Also the error doesn't identify which field or column is causing the issue. Any help or suggestions on how to troubleshooting this issue?

1 ACCEPTED SOLUTION

Accepted Solutions

@srg 

So the Update properties of the columns you know are required are all good?  If so, then I would next take a look at the SharePointIntegration.OnSave property and see what that formula looks like.  

This will be found on the left control tree.  You can click on the SharePointIntegration and then in the formula bar, drop down the list on the left and choose the OnSave property.  See if there are issues there or post back what you are seeing.
EDIT: It should be a SubmitForm(yourForm).  Make sure the yourForm is the name of the form that is your edit form.

 

Finally, I would select the EditForm in the left control tree and then delete it.  Then immediately do an undo (ctrl-z) to bring it back.  Many times, if the form has gotten "confused", doing this will "Reset" it back to "normal".

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

View solution in original post

8 REPLIES 8
yashag2255
Dual Super User II
Dual Super User II

@srg 

 

Can you please share more details about the error that you are getting? Can ou please share a screenshot? That way we might better identify the issue and assist you with this. 

The error started to pop up with no changes made to the sharepoint custom forms, it does pop up only in the edit form and not in the new form. I didn't make any changes to the list item, just opened it to edit and hit save and I get the error. Attached is the error screenshot.

 

I have republished the app with no luck couple of times. I have also checked if the any of the fields were made required by mistake, but none are except for what I already know and have been filling them

 

Thank you !!

 

 

@srg 

Take a look at the Update properties on the EditForm for the known required columns.  I'd be curious to see if there are any errors in them or if they are somehow not providing the information needed to satisfy the "required" requirements.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Hello Randy,

 

How can I get to update properties, is it in the advanced tab of the column properties?

@srg 

EditForms are containers of DataCards.  Your Edit form will have as many datacards as you have fields assigned.

Each DataCard has (depending on the underlying field/column type) an Update property, a Default property, and a DataField property.

The curiosity is on the Update property for those datacards...

So, click on a datacard in your control tree (left side) and then click on the Advanced properties on the right.  Under the Data section (and you might need to click on "More options" to see it), you will find the Update and other properties mentioned.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Thank you Randy, I was able to locate the update property, it mentions the corresponding DataCardValue and I didn't notice anything wrong there.

@srg 

So the Update properties of the columns you know are required are all good?  If so, then I would next take a look at the SharePointIntegration.OnSave property and see what that formula looks like.  

This will be found on the left control tree.  You can click on the SharePointIntegration and then in the formula bar, drop down the list on the left and choose the OnSave property.  See if there are issues there or post back what you are seeing.
EDIT: It should be a SubmitForm(yourForm).  Make sure the yourForm is the name of the form that is your edit form.

 

Finally, I would select the EditForm in the left control tree and then delete it.  Then immediately do an undo (ctrl-z) to bring it back.  Many times, if the form has gotten "confused", doing this will "Reset" it back to "normal".

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

View solution in original post

Thank you Randy, the OnSave was not configured properly(not sure how it was working earlier, may be we didn't test it properly). You are a savior !!

 

Thank you Yash for looking into this !!

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

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Carousel April Dunnam Updated 768x460.jpg

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors
Top Kudoed Authors
Users online (2,847)