I have an online SharePoint list that contains over 8,000 items. The “New Item” and “Edit Item” forms for the list do not work because they exceed the 5,000-item limit. The column that displays the error message in the forms is a lookup column.
The Lookup column is indexed. This column contains about 1500 entries with the rest of the items being empty. I am only interested in items that are not blank in the lookup column. Is it possible to filter the items in this Lookup column in Power Apps so that the New Item and Edit Item forms work correctly?