Power Platform Community Forum Thread Details

Hi all,

I have two SQL tables where

1, customers, contains list of customer and the shortcut of the country they are located, US, GB, BE, NO...

2, countries, contais list of country codes and full names (GB = Great Britain, etc...)

i need to create a dropdown which will filter the 1st list based on text input and provide selection of countries based on the second list... i manged it following way:

Filter('Countries', CountryCode in Filter(Customers, TextInput2.Text in 'Customer Name').'Country_Code').CountryName

but i get tha delegation warning because of the first in. (MS: The in (substring) operator. Supported for ("string value" in \<column>), but not for (\<column> in "string value").)

I suspect that it should not be a problem because the list is filtered already by all the other filters... but still, is there a better way to do?

Categories:

Building Power Apps