Patch a single field in a Sharepoint list

(0) Share

Report

Posted on by mjburley

370

I am converting a power app to use a Sharepoint list instead of CDS for its data source (licencing issues).

Not wanting to recode too much, I just want to use Patch to update a single field in the list, but I cannot get to work. The auto suggest when editing a formula does not show my fields, and when I write them in, it just red underlines it all.

The docs say

Patch (List, baserecord, items:values)

So I use

Path ( 'My SP List', ID = IDNumber, { recordLabel : " some text"})

where ID is the column ID in the SP list, IDNumber is my power app variable I have retrieved earlier using LookUp, and recordLabel is the field I want to update with "some text".

Am I missing something obvious here, like I need to do formsubmit or use a flow like others have done? This would require reworking of my app...

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

eka24 20,925 on at

Like (1)

Report
Copy link

Link copied!

Try this :
Patch('My SP List',First(Filter('My SP List', ID =IDNumber)),{recordlabel:"some text"})

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like (2)

Report
Copy link

Link copied!
@mjburley

You can make the PATCH work like this.

Patch('My SP List', LookUp('My SP List', ID = IDNumber), { recordLabel : "some text"})

@eka24

Suggest you always use LOOKUP to find the record instead of FIRST + FILTER as suggested above. FIRST + FILTER offers lower performance because the entire dataset must be retrieved then filtered. LookUp stops immediately after finding the record you wanted.

First(Filter('My SP List', ID = IDNumber))

---
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