Unanswered

Updating a field in a SharePoint List with the Update function

(0) Share

Report

Posted on by stevenspray

I see many posts asking about "the patching function" to update a SP list, not sure what that is, I'm after just a simple "Update" function that I can't seem to get working.

I have a simple 'toggle' button on my app that if toggled, I want a field in the list to be updated with some text.

My list is called "ApprovalList" and there is a text column called "ISO_Approve"

When the button is toggled, it merely needs to update the corresponding SP List item's ISO_Approve value to "Approved".

On the toggle button's "OnChange" property, I have the following code...

Update(ApprovalList.ISO_Approve, "Approved")

I've also tried, among many other iterations...

Update(ISO_Approve.Text, "Approved")

I've also tried using the Set and Patch functions and can't get it working, any clues?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Vijay Tailor 2,961 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @stevenspray ,

I did not understand like, How you updating value back to SP.

Basically, if you want to update any record in SP. then you need an ID for an update or Patch the Record.

Basically, Patch COde looks like that.

See the below Code.
// Update the Recrod using Patch Patch( Sharepointlsitname,{ ID:varCheckDuplicate.ID, ApproverCOmment: "Approaved - Here is the approaved Comment" } ); //Create the Record Using Patch. Patch( Sharepointlsitname,{ Defaults(Sharepointlsitname),, Status:{ Value:"Submitted", '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference" } } );

Thanks,
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@stevenspray

Your use of the Update function is incorrect. To use Update, you need to supply three parameters, the dataSource, the OLD record, and the New Record.

You will also need to supply a valid record (using the { } notation).

What you might want to consider is the UpdateIf function. In this you can supply the Datasource, the criteria for what to update, and the changes you want to make.

UpdateIf( ApprovalList.ISO_Approve, //Datasource ID=yourCurrentRecordID, //Criteria {ApprovedColumn:approvedColumValueYouWant} //Record changes )

You will need to, obviously, replace the above names to those valid in your app and data source.

I hope this is helpful for you.

Was this reply helpful? Yes No
stevenspray 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi RandyHayes

Thank you, I was unaware of the three required parameters. What is the OLD record is blank? I think the UpdateIf might be the wrong way to go about it, I'm not sure.

I'm trying to type your syntax and it's just not working, where do I get the ID from? Also, when I type

Patch(ApprovedList.ISO_Approve PowerApps changes that to Patch(ApprovedList.'ISO_Approve' including some '' is that intended?

Also, I see you mention "ApprovedColumn", this is ISO_Approve, correct?

Was this reply helpful? Yes No
stevenspray 17 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi VijayTailor

Thanks for your input, I have now used the curly brackets and don't see the squiggly underlined red error in the code anymore, but I still see a red "X" error mentioning something about unexpected characters. I do think my syntax is slightly wrong. I am now using....

Patch(ApprovedList,{'ISO_Approve': "Approved"}

I can't seem to fit the "ID" part of the syntax in anywhere, where do I format this?

Was this reply helpful? Yes No