Gallery->Items and filtering by dropdown

[TCop93]

Hi. I am struggling to connect two dropdown panel to the gallery to work properly

My first dropdown Items code is

Sort(Distinct(IB_Input; Coverage); Result; Ascending)

My second dropdown Items code is 

Sort(Distinct(IB_Input; Sales_Play); Result; Ascending)

I am trying the following code in the Gallery Items, but the gallery shows empty box

Filter(IB_Input;Coverage=Dropdown_SalesPlay.Selected.Result; Sales_Play=Dropdown_Coverage.Selected.Result)

Any suggestions would be really helpful as this is the last thing to do for this app. 

[Ashwin7104]

Hey @TCop93  - Please try below code

Filter(IB_Input;Coverage=Dropdown_SalesPlay.Selected.Result && Sales_Play=Dropdown_Coverage.Selected.Result)

[TCop93]

@Ashwin7104  Thanks for the prompt response.

It works, but the exclamation marks appears in a sign. When testing the app, only some rows appear after dropdown option selection, not all. 

Am I doing the cascading dropdown right like this? I saw some YT tutorials and some advices here and a lot of people are using isblank formula in the gallery items section, which is very different from what I've done. 

[Ashwin7104 · Accepted solution]

@TCop93 - Please make sure its "&&" in your filter query and compared types are correct.

[TCop93]

It actually worked! Thank you 🙂

Not all the data showing as I have more than 2k records, need to find solutions for it now... 

[Ashwin7104]

@TCop93  - We must apply the delegation idea so that data is filtered in the data source and then fed into PowerApps. What's is the data type for Coverage and Sales Play? Is SharePoint being utilised as a data source?

[TCop93]

@Ashwin7104  Unfortunatelly not SharePoint, but Excel... I am now moving to Sharepoint with all the data as, according to information I've found, PowerApps do not treat Excel as delegatable. Thus, the migration process is in place. It should work smoothly on SharePoint now.

Thank you for your support.