I have a Power App that connects to a SharePoint list with over 3000 items to choose from in a cascade of dropdowns in a power app. One of the fields in SharePoint is a calculated field named Location that concatenates ID, City, and Address. In the app there are dropdowns and one combo box that cascade. The first Dropdown is Region, and then the second field in the cascade is the combo box that looks up the calculated field called Location whose parent is region. This part works fine and pulls up the 'Locations' in the chosen Region(no delegation warning). The next cascading dropdowns are ID, City, Address. I simply want to fill ID, City, and Address in automatically based on what was chosen in Location as each choice in Location is distinct. It works for most of the records but not all of them, and it must be because I'm getting a delegation warning. Here is the formula in the City field items: Distinct(Filter(OpenStores, Location = LocationCB.Selected.Value),City). The other fields have a similar formula. After Region is selected, it limits the Locations to only a few hundred, so it's not making sense. How can I update to always make the ID, City, and Address populate?
