cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Update SharePoint (multi line text column) list using patch is not working

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:

plain.PNG

 

txtTest.PNG

 

Help me how to solve this problem, please.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

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:

 

 009.PNG

 

View solution in original post

3 REPLIES 3
Highlighted
Resolver I
Resolver I

Hi,

 

Have you checked the column name, if it is correct ? Also if there are any special characters in text ?

 

Highlighted
Community Support
Community Support

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:

114.PNG

 2)my textinput setting:

1142.PNG

 

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,

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

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:

 

 009.PNG

 

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (5,449)