Forum Discussion

Copper Contributor

Oct 17, 2024

Patch Multiple Items in SP list online

Hello everyone, I am trying to patch multiple values in a single SP online list. I have a Add New Button in Form where it stores a collection of 4 column which I had set up in a data table. When I a...

SharePoint Online

deanshepherd

Brass Contributor

Oct 17, 2024

here is a method how patch all records in power apps

// FORALL + PATCH Method
ForAll(
CollectionOfChanges,
Patch(Datasource, DatasourceRecord, UpdateRecord)
)

Thanks
D

sumershanbhag

Copper Contributor

Oct 17, 2024

Hi @deansheperd, I am already using this for my patch function. Still I am getting this error.

deanshepherd
Brass Contributor
Oct 17, 2024
if you allready have cites in the sharepoint list and you just want to update that cities row then you will need to throw a lookup in there somthing like this

ForAll(CollectionOfChanges, Patch(Datasource, LookUp(Datasource, ID = ThisRecord.ID), ThisRecord))
- sumershanbhag
  Copper Contributor
  Oct 18, 2024
  Using ForAll is giving me multiple SP list items. I tried by removing the ForAll and I got single item.