Hello developers,
I am trying to update 2 columns in my SharePoint list when a button is clicked.
The first column which is a single line updated successfully but the second column which is multi-line text is not updated, any comments why?
I try to combine both updates in one patch and separate them but still, it didn't work, here is the code:
Patch(RequestLegal ,First( Filter( RequestLegal, ID=Gallery1.Selected.ID) ),{'ApproverComments': txtTest.Text});
Patch(RequestLegal ,First( Filter( RequestLegal, ID=Gallery1.Selected.ID) ),{'Approval Status':"Approve"});
The ApproverComments in SharePoint list is a plain text:
Help me how to solve this problem, please.
Solved! Go to Solution.
Dear all,
Thank you I discover my mistake and it was as the following:
I reset the textbox before updating the data that's why it appears empty every time:
Hi,
Have you checked the column name, if it is correct ? Also if there are any special characters in text ?
Hi @aisha96cs96 ,
Do you mean that you can not update ApproverComments field successfully?
I've made a similar test but not met the same problem like your description.
Here's my test for your reference:
1) test11 is my test field, its setting:
2)my textinput setting:
3) my update formula:
Patch(test1,First(test1),{test11:TextInput1.Text})
And I could use this formula to update successfully.
Please check :
1)whether you have required field?
2)whether you use right fieldname, control name?
3)whether your connection is valid?
Best regards,
Dear all,
Thank you I discover my mistake and it was as the following:
I reset the textbox before updating the data that's why it appears empty every time:
User | Count |
---|---|
135 | |
127 | |
75 | |
72 | |
69 |
User | Count |
---|---|
221 | |
135 | |
78 | |
58 | |
54 |