1. Go to File > Settings > Advanced Settings and increase the Data row limit for non-delegable queries to 2,000.
2. Check the Filter function for any blue warning dots, as they indicate delegation issues. Simplify the query if necessary.
3. On the OnStart property of the app (or a suitable screen), load the data into a collection with the formula:
ClearCollect(colJobTitles, Filter(JobTitles, Region = var_CurrentRecord.Emp_Region))
4. Set the Items property of the combo box to this collection using:
Filter(colJobTitles, /* any additional conditions */)
5. Use StartsWith for search optimization, which is delegation-friendly -
Filter(JobTitles, Region = var_CurrentRecord.Emp_Region && StartsWith(Title, ComboBox1.SearchText))
6. Verify that var_CurrentRecord.Emp_Region includes the expected regions for all matches to avoid accidental exclusions.
