Patch Shared unique ID into Sharepoint List

[ShannonC]

I'm creating an app that patches multiple items at once into a Sharepoint list, I'm wanting these items to be associated with each other via a unique ID only they all share.

Is it possible to have a column in a Sharepoint List that Powerapps can check when patching and when adding the new items into the list, put the next increment of that number for their rows?

If not, ideas for other solutions welcome

[WarrenBelz · Accepted solution]

Hi @ShannonC ,

Quite easily (for example) if you use a number and column RefID below - you would find the biggest one and add 1

With(
   {
      wRef:
      Sort(
         ListName,
         RefID,
         Descending
      )
   },
   Patch(
      ListName(
      ForAll(
         YourPatchingList As aPatch,
         {
            Field1: aPatch.Field1,
            Field2: aPatch.Field2,
            . . . . . . . . .
            RefID: First(wRef).RefID + 1
         }
      )
   )
)

I have also allowed for the same field names in source and target above.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[ShannonC]

Fantastic, worked like a charm 🙂