Dropdown Filters

[Mts1]

Hi all,

How can i make the below formula work : 

Distinct(Filter(CountriesAndExceptionsAndCarriers_Table, Country = DropDown_Country.Selected.Result & Exception = DropDown_Exception.Selected.Result),Carrier)

Basically, i want to filter a drop down called "Carrier" based on 2 other drops downs called "Country" & "Exception"

Thanks in advance for your help,

Regards

[Akash17]

Hi Please refer

https://www.youtube.com/watch?v=Qzpjq008cBY

By Reza Dorrani and

https://www.spguides.com/powerapps-cascading-dropdown/

By SP_Guides

[Mts1]

Hi,

I already checked this video and is not showing how to filter a dropdown with multiple dropdown results.

I don't want to use Forms on my app, but if i cannot make the requirement with dropdown i think i will be obliged to use it.

[JamieMcCarroll · Accepted solution]

Hi,

You need to use 2 & signs not one.

For example

Distinct(Filter(CountriesAndExceptionsAndCarriers_Table, Country = DropDown_Country.Selected.Result && Exception = DropDown_Exception.Selected.Result),Carrier)

You may also be better using in or exactin as opposed to the = sign as that is meant for numerical values.

Many thanks,

Jamie

[Mts1]

HI,

Thanks a lot for your answer.

I have the below error message when i'm using your formula, do you know what can be the issue ? 

Thanks in advance,

Regards

[JamieMcCarroll]

Hi,

This is just a delegation warning not an error, I wouldn't worry about this as power apps objects can only display a set amount of items at once (I think it is 5000) but the exact items can still be retrieved via searching and filtering.

Hope this helps,

Jamie

[Mts1]

Thanks a lot for your help and answer.

Your formula is working really fine on my case.

Do you know if there is any way to remove the warning message ? If not, i will leave it like that!

Again thank you, you saved me !

Regards