ForAll not updating? Invalid argument type message

[iskguy]

ForAll(MatchGallery.AllItems,UpdateIf(Customer_Records,ThisRecord.RecordID=RecordID,{'Record Status':"Final"}))

What is wrong with this statement?  I am getting an invalid type message on the datasource table 'Customer_Records'. All I want to do is go through all items in a gallery and set the Record Status to Final. Thanks

[TheRobRush · Accepted solution]

Here's how it would look syntax wise, (did this on my own gallery so will need to chaneg names)

Gallery name is Gallery4, Source is CalendarDates, and column I am editing is named Title

UpdateIf(CalendarDates, ID in Gallery4.AllItems.ID, {Title:"Final"})

[iskguy]

Thanks!

[TheRobRush]

If you end up going over 2k items in that dataset, because then we will need to work on making that formula delegable. UpdateIf only works on smaller Data Sources currently.

You can try this in that case

ClearCollect(MatchGalleryCollectionToPatch, MatchGallery.AllItems);
UpdateIf(MatchGalleryCollectionToPatch,true,{'Record Status':"Final"});
Patch(Customer_Records,MatchGalleryCollectionToPatch)

sugggested by @AhmedSalih