Sorry if this reads a little weird, English is not my first language so I used AI to help me structure this clearly.
Since yesterday, I’ve been having two issues in Power Apps that were not happening before:
1. Excel Online (256 Row Limit Error)
Dropdowns and comboboxes connected to Excel Online now fail if the table has more than 256 rows. I get an "Error when trying to retrieve data from the network". In Live Monitor, I see:
"Requested 2000 rows. Received 256 rows."
Oddly, a normal gallery connected to the same data source still works perfectly fine as long as I don’t filter it.
2. SharePoint (>5000 Items)
Around the same time, I started having issues with large SharePoint lists (I think it happens when it exceeds 5000 items). If I bind a gallery directly to the list, it works. But if I try to filter it, it breaks. Example:
Filter(SharePointList, StartsWith(FieldName, "Test"))
3. The Collection Workaround Returns Blank
I used a common workaround to load more than the normal limit by combining ascending and descending sorts. Now, it just returns a blank collection with no error. Example:
Concurrent(
ClearCollect(colPart1, Sort(DataSource, UniqueIDColumn, SortOrder.Ascending)),
ClearCollect(colPart2, Sort(DataSource, UniqueIDColumn, SortOrder.Descending))
);
ClearCollect(
colFinal,
colPart1,
Filter(colPart2, Not(UniqueIDColumn in colPart1.UniqueIDColumn))
);
This was all working perfectly until recently, so I’m wondering if Microsoft changed something with delegation or limits.
Has anyone else seen this?
