Here is my situation. My Samples SharePoint Online list has a lookup column named JobNumber from the Jobs list. The Jobs list has 6,000 approx. items (more than 5,000). I know. I should not keep more than 5,000 items but I have no choice if I want to retain my relationships between my lists for a long time.
So, of course, when I will create a Powerapps customized form, I will get the "The requested operation is invalid" because of the list view threshold.
So, until Microsoft fixes the 5,000 limit , what are my options??
My goal is for sure not to show the 5,000 items to the end user. I want to filter it. Can I pre-filter these more than 5,000 items and not get the error? I would like to do everything without using Patch if possible.
My current workaround is:
- Replicate all my JobNumbers from my SharePoint Jobs list in an Azure SQL server table via Flow.
- Insert my replicated JobsTable with an Azure SQL Datasource in PowerApps
- Show my filtered JobsTable datasource as a ComboBox in my PowerApps form
- Create and Update my Samples SharePoint list via Patch
This workaround is working for me but its a lot of trouble for nothing. Is this the only option I have? I can't believe it's still so complicated to do such a simple task.
thank you
