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.

[EddieE]

@PowerUser19 

For each of your UpdateIf statements, include the Title filed data as well. i think this maybe your issue?

eg

UpdateIf(
   VisitorRequestList,
   PD_Visit_Required="true" And 'Approval List Gallery_1'.Selected.UniqueID=UniqueID And 
   User().Email = ApprovalForm_1.LastSubmit.'PD Manager'.Email,
   {
      Title: yourDataCardTitleFieldName,
      PD_Manager_Approval:"Approved"
   }
);

Usually, an editing to a data source where you have REQUIRED fields needs to include those required fields as part of the updated record - doesn't matter if they have changed or not, they must be there.

[PowerUser19]

Hi @EddieE ,

Thanks so much four response. Tried it but didn't work. Getting the same error.

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

[EddieE]

@PowerUser19 

Did you adjust all 3 UpdateIf() statements, or just this one?

[PowerUser19]

@EddieE  I adjusted all 3. 

[EddieE]

@PowerUser19 

I suspect your condition inside the UpdateIf's isn't working correctly ie not return a true of false. I'd test each condition individually to test this idea, eg

// I cannot see a field called PD_Visit_Required in your list of columns
// If this is a field in your list, what data type is it? You are using type TEXT but if 
// it's a Boolean then the below won't work
PD_Visit_Required="true"

and

// The below may need to be switched around?
'Approval List Gallery_1'.Selected.UniqueID=UniqueID

// ie, reference your data source column name first
UniqueID = 'Approval List Gallery_1'.Selected.UniqueID

Try these things and see how you go.

[PowerUser19]

Hi @EddieE ,

Thanks so much for your response. I got the fields hidden in the form. Also it is a text field and not Boolean. I will try the above suggestion to change the source reference now.

I was wondering why the C&A Visit Required field is showing as the custom card and other 2 showing as normal data cards?

[PowerUser19]

Hi @EddieE ,

I made the source reference change. Didn't help yet. But all the functions are working as it should on Approval. Is there a way to capture this error message and not show it on Approval? Even if I could hide the error message that pops up while approving, that should be good.

I also made sure the visit required fields are not empty.

[EddieE · Accepted solution]

@PowerUser19 

The Custom card maybe the issue. Custom cards are ones that don't come across when the form is built by powerapps and are ones that you create manually - although, this card does appear to have been created by powerapps?? 

You could try deleting it then re-adding it back in to see if that fixes the issue?

[PowerUser19]

@EddieE  It is created by PowerApps. All the forms in the field are created by adding the fields from SharePoint.  I noticed lot of other fields are showing as custom card too

I will try to remove and add the C&A Data card back. There are bunch of references, I will first make a note of those before I remove the field and try to add it back in.