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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,322)