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
Solved! Go to 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
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
I plugged it it and there are no red squiggles, so looks good!
I really appreciate the help.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
169 | |
94 | |
64 | |
64 | |
60 |
User | Count |
---|---|
242 | |
163 | |
95 | |
85 | |
82 |