web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Patch a single field i...
Power Apps
Answered

Patch a single field in a Sharepoint list

(0) ShareShare
ReportReport
Posted on by 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:
I have the same question (0)
  • eka24 Profile Picture
    20,923 on at
    Try this :
    Patch('My SP List',First(Filter('My SP List', ID =IDNumber)),{recordlabel:"some text"})
  • Verified answer
    mdevaney Profile Picture
    29,991 Moderator on at

    @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."

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

Last 30 days Overall leaderboard