An entry is required or has an invalid value

[PowerUser19]

Hello experts,

I am building an app for visitor request automation. I see the submit form doesn't have an issue updating the form inputs in SharePoint. I tested it by just using a submitform code in a sample button.

In my code, when I commented the below, the error message did not show up. So I strongly believe there is something wrong in the below code which is bringing up the "An entry is required or has an invalid value" error message. 

UpdateIf(VisitorRequestList,PD_Visit_Required="true" And 'Approval List Gallery_1'.Selected.UniqueID=UniqueID And User().Email = ApprovalForm_1.LastSubmit.'PD Manager'.Email, {PD_Manager_Approval:"Approved"});
UpdateIf(VisitorRequestList,VE_Visit_Required="true" And 'Approval List Gallery_1'.Selected.UniqueID=UniqueID And User().Email = ApprovalForm_1.LastSubmit.'VER Manager'.Email, {VE_Manager_Approval:"Approved"});
UpdateIf(VisitorRequestList,CA_Visit_Required="true" And 'Approval List Gallery_1'.Selected.UniqueID=UniqueID And User().Email = ApprovalForm_1.LastSubmit.'CA Manager'.Email, {CA_Manager_Approval:"Approved"});

The Title field in the SharePoint list is "Required" and it is a Required field in the form as well. There is always data in this field. No other fields are mandatory in the form or the list.

I double checked if there are any hidden fields that are marked as "Required". Except the Title, none of the fields mandatory. Not sure what I am missing here. Struggling to fix this error for quite a long time. Your help is much appreciated.

[PowerUser19]

@EddieE Removing and adding the field back didn't help. But I did one more testing to confirm if it is only the C&A field which is giving the issue and Yes it is.

When I commented the C&A item in the below code, I got through without any error message. I believe there is some issue with the C&A field setup in SharePoint or the PowerApps data card or somewhere else related to this field.

UpdateIf(VisitorRequestList,PD_Visit_Required="true" And UniqueID='Approval List Gallery_1'.Selected.UniqueID And User().Email = ApprovalForm_1.LastSubmit.'PD Manager'.Email, {Title:'Approval List Gallery_1'.Selected.Title,PD_Manager_Approval:"Approved"});
UpdateIf(VisitorRequestList,VE_Visit_Required="true" And UniqueID='Approval List Gallery_1'.Selected.UniqueID And User().Email = ApprovalForm_1.LastSubmit.'VER Manager'.Email,{Title:'Approval List Gallery_1'.Selected.Title,VE_Manager_Approval:"Approved"});
//UpdateIf(VisitorRequestList,CA_Visit_Required="true" And UniqueID='Approval List Gallery_1'.Selected.UniqueID And User().Email = ApprovalForm_1.LastSubmit.'CA Manager'.Email, {Title:'Approval List Gallery_1'.Selected.Title,CA_Manager_Approval:"Approved"});

[EddieE]

@PowerUser19 

Was the CA_Visit_Required field originally a Yes/No field which has been changed to type TEXT field? This could be one reason why this is occurring, there could also be other code inside your app causing the issue.

One way to test the first one above is to create a totally new field for CA visit reqd - use a different field name. Set it up as type TEXT and use that in your formula to see what happens.

It definitely sounds like this field is the problem

[PowerUser19]

@EddieE  Thank you sure will try today! 

[PowerUser19 · Accepted solution]

Hi @EddieE ,
After a long struggle, I was able to solve the error with the below code. In some cases,  one or two of the managers' email can be blank based on the area chosen. In those cases, the error message was showing up (when the last submitted email id was blank). So I included the blank condition check before the UpdateIf command. Thankfully, I don't see the error message anymore. 

Thank you so much for your help and support. Really appreciate it.  🙂

If(Not(IsBlank(ApprovalForm_1.LastSubmit.'PD Manager'.Email)),UpdateIf(VisitorRequestList,PD_Visit_Required="true" And 'Approval List Gallery_1'.Selected.UniqueID=UniqueID And User().Email = ApprovalForm_1.LastSubmit.'PD Manager'.Email, {PD_Manager_Approval:"Approved"}));
If(Not(IsBlank(ApprovalForm_1.LastSubmit.'VER Manager'.Email)),UpdateIf(VisitorRequestList,VE_Visit_Required="true" And 'Approval List Gallery_1'.Selected.UniqueID=UniqueID And User().Email = ApprovalForm_1.LastSubmit.'VER Manager'.Email, {VE_Manager_Approval:"Approved"}));
If(Not(IsBlank(ApprovalForm_1.LastSubmit.'CA Manager'.Email)),UpdateIf(VisitorRequestList,CA_Visit_Required="true" And 'Approval List Gallery_1'.Selected.UniqueID=UniqueID And User().Email = ApprovalForm_1.LastSubmit.'CA Manager'.Email, {CA_Manager_Approval:"Approved"}));

[EddieE]

@PowerUser19 

Fantastic, great work. My next suggestion was to check some data that was throwing the error but you beat me to it, lol

If your issue is solved then mark your comment as the solution so that others can find it. If you feel any of my suggestions helped with the solution you can also mark these as solutions as well 🙂 - you can mark 1-many solutions.

Well done again, all the best