I have a sharepoint list which we're adding a Text column to, and I'm using a quick powerapp to go back and fill in the blanks with the correct value(after looking up the correct value in a SQL connector). I've been using a button like:
ClearCollect(updateItems,RenameColumns(Filter(myList,newColumn=""),"ID","IDRef"))
with the idea being to create a collection with items which haven't had the newColumn filled in yet and then hitting another button to do a ForAll UpdateIf bit on that column. I'd previously used something similar to add a numeric version of the created date and it worked well. However, our list has since grown to over 2000 items, and it doesn't seem like the Filter command actually checks anything past the first 2000, even though I was under the impression that "=" and IsBlank(which I've also tried) are delegable to sharepoint. What am I missing?
NEVERMIND
Naturally, as soon as I make the post I figure it out... I changed the comparison to ColumnName = Blank() instead and it worked. Leaving this up for future reference.
