Forum Discussion

sumershanbhag's avatar
sumershanbhag
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
sumershanbhag's avatar
sumershanbhag
Copper Contributor
Oct 17, 2024
Hi anyone has solution on this?
  • deanshepherd's avatar
    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's avatar
      sumershanbhag
      Copper Contributor
      Oct 17, 2024
      Hi @deansheperd, I am already using this for my patch function. Still I am getting this error.
      • deanshepherd's avatar
        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))

Resources