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 / Use Patch funtion to p...
Power Apps
Unanswered

Use Patch funtion to patch data on Sharepoint List

(0) ShareShare
ReportReport
Posted on by 122

Let me ask how do I patch the data from the last collection to the Sharepoint List RestockDetail. I also did this and only patched one item. My RestockDetail List:

Edward00_0-1689852144878.png

 

Edward00_0-1689847335103.png

My collection:

Edward00_1-1689847376292.png

I want to patch the data from the collection to List RestockDetail including sizes 39, 40, 36. Please help me, sir.

Categories:
  • Geeks_D Profile Picture
    1,169 on at

    Hi 

    You will need the ForAll Statement for this and a control to mark all the items you will wish to patch into the SharePoint 

    Revert if you need more help 

  • Edward00 Profile Picture
    122 on at

    Can you give specific examples?

     

  • v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @Edward00 ,

     

    Please check the return value of this formula:

    Filter(
     colRestockProduct,
     ThisRecord.xxxxxxx ,
     ThisRecord.xxx
    )

    vbofengmsft_0-1689921983902.png

    If this filter only returns one item , you can only update one row.

     

    In addition , If you want to add a new row , the syntax should be

    Patch( DataSource, Defaults(DataSource), ChangeRecordTable1) 

    Modify or create a record in a data source 

     

    Best Regards,

    Bof

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 409 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 252 Most Valuable Professional

Last 30 days Overall leaderboard