Answered

An entry is required or has an invalid value

(0) Share

Report

Posted on by rpersad

829

Started getting the error 'An entry is required or has an invalid value', when submitting a form. There was one column which was set to required in the SharePoint list settings which is always filled when testing the app. I also check the form to see if it is valid else the "Save" button will be disabled so I know all required fields are filled in on the application.

The code below just check to see if there is an error with the information entered on the form. If there is an error it will show an error message else a loading screen is displayed, the form is submitted and the variable is updated with the record from the last record submitted.

Save Button code

Set(gblFormStatus, Blank());

If(And(CountRows(Filter(colProgAmendOption, Selection = "Yes" && Title = "Increase or decrease in Total Programme Credits")) = 0, Not(txtSugCredit_3.Text = txtSugCredit_4.Text)), 
    Set(showCreditsWarning, true), //Show error message
    Set(showLoading, true); //Show loading screen
    SubmitForm(frmAmmendment_); //Submit form
    Set(gblCurrentForm, frmAmmendment_.LastSubmit); //Update variable which stores the current record information and updates it with the updated information
    Set(showLoading, false) //Hide loading screen
)
 
The issue seems to be caused by the "Set(gblFormStatus, Blank());" since once removed I am able to save the record. This variable is used in the Default property of a data card in the form. However the field is not a required field on the app nor on SharePoint.
 
 
Data card Default property code
Coalesce(gblFormStatus,ThisItem.FormStatus)
 
 
 

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

timl 36,797 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Have you refreshed the SharePoint data source in your app? It might be worth doing that as a first step to see if it helps.

Was this reply helpful? Yes No
ronaldwalcott 3,862 Moderator on at

Like (0)

Report
Copy link

Link copied!

What is the purpose of Set(gblFormStatus, Blank()) if you have the default property code set to Coalesce(gblFormStatus,ThisItem.FormStatus)

Was this reply helpful? Yes No
Suggested answer

Garima_PowerPlatform 170 on at

Like (1)

Report
Copy link

Link copied!
Hi

"An entry is required or has an invalid value" typically occurs when there is a validation issue with a required field or when the form is not properly handling all input data. Given your explanation, it seems that Set(gblFormStatus, Blank()); might be clearing some required data unexpectedly.

Check Required Fields:

Even if the field is not set as required in the SharePoint list settings, it could still be required by the form itself. Verify if any data card within the form has its Required property set to true.

Default Property in Data Card:

Coalesce(gblFormStatus, ThisItem.FormStatus) is likely expecting a valid entry. If gblFormStatus is being set to Blank(), it could cause the data card to fail validation when trying to pull a value from it.

Variable Reset Issue:

Ensure that gblFormStatus is not set to Blank() unless absolutely necessary. If it’s not required, try removing Set(gblFormStatus, Blank()) entirely or conditionally setting it.

Check Data Validation:

Inspect all data cards and ensure none are set as required that are not properly handled when gblFormStatus is cleared.

If(
And(CountRows(Filter(colProgAmendOption, Selection = "Yes" && Title = "Increase or decrease in Total Programme Credits")) = 0, Not(txtSugCredit_3.Text = txtSugCredit_4.Text)),
Set(showCreditsWarning, true), // Show error message
SubmitForm(frmAmmendment_); // Submit form
Set(gblCurrentForm, frmAmmendment_.LastSubmit); // Update variable
)

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.

Was this reply helpful? Yes No
Verified answer

rpersad 829 on at

Like (0)

Report
Copy link

Link copied!

Did check the SharePoint list and found that the FormStatus column in the SharePoint list has a default value "NEW" set to it. I have to assume due to the processing the logic of the app which is causing the error. Decided to remove the Set(gblFormStatus, Blank())

Though this issue started happening this week while before I had no issues.

Was this reply helpful? Yes No
WarrenBelz 155,052 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @rpersad

Try sending an empty string instead of Blank()
Set(gblFormStatus, "");

Also what type of field are you writing back to - if it is a Choice field
Set(gblFormStatus,{Value: ""});

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No