Code Error

[MShelnutt]

@RandyHayes 

Hi Randy,

I had to modify my On Select property so it will update one of my SharePoint columns in the record, but I am not writing it correctly, can you take a look?-

-Michael Shelnutt

[v-albai-msft · Accepted solution]

Hi @MShelnutt ,

Have you already set the variable varFormData to one of the records in list ‘Customer Complaints 21’ ?

I would suggest you check below things:

1. You cannot use the control name directly. You should use the output of this control. For example, if this is a Text-input control, you should use formula like:

DataCardValue19_1.Text =XXX

If this is a dropdown control, you should use formula like:

DataCardValue19_1.Selected.Value

2. Seems you want to update the Choice column ‘Form Status’ based on the value of DataCardValue19_1? If yes, try below formula(assume your DataCardValue19_1 is a dropdown control):

If(DataCardValue19_1.Selected.Value="Ask for Manager Exception- no return",
Patch('Customer Complaints 21',
varFormData,
{'Form Status':{Value:"Pending Approval"}}
 ),
Patch('Customer Complaints 21',
varFormData,
{'Form Status':{Value:"Submitted"}}
)
)

Best regards,

Allen

[MShelnutt]

@v-albai-msft 

I plugged it it and there are no red squiggles, so looks good!

I really appreciate the help.