patch all record titles

[StuCundy]

I have recently imported a database in from Access.  All relationships are intact.  I want to make the title of the parent record be a mix of name and surname and ID#.  I can do this in powerapps but obviously just does one record at a time, I have 3000 items.  I have researched patch but cannot seem to get it right.  Is this where i should be looking?  Be grateful to some help.

[WarrenBelz · Accepted solution]

Hi @StuCundy ,

You can do a ForAll Update based on a Collection made from the list, but this is limited to 2000 items at a time unless you can collect it in more than one filtered batch. If you have a text or numeric field that will split this, it can be done with a ClearCollect on the first and a Collect on the second OR your could do it in batches as the code below will take a fair while to run and you need to be aware of SharePoint API call throttling limits.

So assuming you can do this, the syntax would be something like

ForAll(
   RenameColumns(
      YourCollectionName,
      "ID",
      "IDRef"
   ),
   UpdateIf(
      YourListName,
      ID=IDRef,
      {YourNewField:Given&Surname&ID}
   )
)

I have another couple of non-Power Apps solution for one-off jobs like this as well if it interests you, involving Excel and Access respectively.

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.