Gallery->Items and filtering by dropdown

(0) Share

Report

Posted on by 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.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Ashwin7104 671 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey @TCop93 - Please try below code
Filter(IB_Input;Coverage=Dropdown_SalesPlay.Selected.Result && Sales_Play=Dropdown_Coverage.Selected.Result)

Was this reply helpful? Yes No
TCop93 42 on at

Like
a
(0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Verified answer

Ashwin7104 671 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
TCop93 42 on at

Like
a
(0)

Report
Copy link

Link copied!

It actually worked! Thank you 🙂

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

Was this reply helpful? Yes No
Ashwin7104 671 on at

Like
a
(0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
TCop93 42 on at

Like
a
(0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No