Unanswered

Drop Down Not Working

(0) Share

Report

Posted on by mglemser

Hi everyone. I am trying to filter a gallery based off a drop down list.

The drop down is populated by a collection when the screen is visible using the following code: ClearCollect(collectCO, Sort(Distinct(Table13,'CO Number'),Result,Ascending))

I have a gallery that I want to filter for the item selected in the drop down. It works when I use the following code but is giving me a delegation error around || :

Filter(Table13,('CO Number' = drpCO.Selected.Result || drpCO.Selected.Result = Blank()))

When I change the code to Filter(Table13,('CO Number' = drpCO.Selected.Result)), it gives me a red X. I have been following tutorials online and it always works fine for them. Can anyone help point me in the right direction?

Thanks.

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@mglemser

Please consider changing your Formula on the Dropdown to the following:

Sort(Distinct(Table13, 'CO Number'), Result)

Then set your Gallery Items property to:

Filter(Table13, IsBlank(drpCO.Selected.Result) || ('CO Number' = drpCO.Selected.Result) )

I hope this is helpful for you. If not, let me know what type of column 'CO Number' is in your list and what datasource you are using.
mglemser 82 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Randy. Thanks for the response. I am trying to avoid "or" statements in the filter to avoid a delegation error. Is there a way I can rewrite the filter so it doesn't have || ?
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@mglemser

Or statements are delegable! What you are Or'ing impacts delegation potential, but not the fact that you OR or AND in the formula. There is no need to avoid them.
mglemser 82 on at

Like
a
(0)

Report
Copy link

Link copied!

I am receiving the following delegation warning when I use the "or" statement. I don't need the gallery filter to account for when the drop down is blank because I want the user to select a drop down value before the data is displayed.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@mglemser
The formula I provided is delegable to most all delegable datasources...what datasource are you using?
mglemser 82 on at

Like
a
(0)

Report
Copy link

Link copied!

I am using Excel.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@mglemser

Ah, the dreaded Excel!

Delegation doesn't make a difference when you are using Excel because nothing is delegable to Excel. So the fact that you have a warning is not that relevant as nothing else that you put in will delegate either. Excel is file based, so there is no "service/server" to submit a delegable query to. So, PowerApps has to deal with the maximum number of rows that it can from the file at a time.

So...you would need to just ignore this warning as there is no way to write delegable criteria to the Excel connector.