I have a Powerapp with two dropdowns. "Region" and "Asset". When a region is selected in the "Region" dropdown, I'd like the "Asset" dropdown to only show the assets found in that region. My filtering is working, but I get a delegation warning that the filter might not work on large data sets. I think the answer is to set a variable, but I'm so new to using this program that I'm not quite sure how to do it.
Region dropbox set to: 'Region List'
Asset dropbox set to: Distinct(Filter(Assets_Regions, Region.Value = DropdownRegion.Selected.Value),'Asset Name')