Answered

Dropdown Filters

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Akash17 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Please refer
https://www.youtube.com/watch?v=Qzpjq008cBY
By Reza Dorrani and
https://www.spguides.com/powerapps-cascading-dropdown/
By SP_Guides

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No