cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MShelnutt
Helper V
Helper V

Code Error

@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?-

 

MShelnutt_1-1617221259249.png

 

 

-Michael Shelnutt

1 ACCEPTED SOLUTION

Accepted Solutions
v-albai-msft
Community Support
Community Support

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

View solution in original post

2 REPLIES 2
v-albai-msft
Community Support
Community Support

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

@v-albai-msft 

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

 

I really appreciate the help.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,232)