Unanswered

Filter table ListBox

(0) Share

Report

Posted on by CGeorgeoff

Trying to do a simple filter of Column 2 of a table and present column 1 in a listbox. The filter value is input from selection list. the code below was applied to the "items" property of the listbox.

Filter(AreaID, AreaID.'Project 123' = Project_Selection_List_1.SelectedText.Value)

Warning is "Delegation warning. The "Filter" part of this formula might not work correctly on large datasets.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

Sort by

BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Try:

Filter(AreaID, 'Project 123' = Project_Selection_List_1.SelectedText.Value)

If you are always expecting less than 500 records to be returned (or up to 2000 if you change the row-limit setting), you can safely ignore delegation warnings.

Hope this helps,

Bryan

Was this reply helpful? Yes No
CGeorgeoff 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Good to know about the delegation limits, thank you. Unfortunately the code is still not working, now receiving the following.

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@CGeorgeoff wrote:

Hi,

Good to know about the delegation limits, thank you. Unfortunately the code is still not working, now receiving the following.

It's indicating a problem with the control named Project_Selection_List_1. Is that a dropdown?

Also, what type of column is 'Project 123'?

Bryan

Was this reply helpful? Yes No
CGeorgeoff 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the prompt response Bryan.

Yes, that is a dropdown. Currently the type is set to "text", I have tried with "General" as well.

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Assuming your column is a single line of text type, try the following:

Filter(AreaID, 'Project 123' = Project_Selection_List_1.Selected.Value)

Was this reply helpful? Yes No
CGeorgeoff 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Each entry in that column are 5 digit numbers (ex. 01030).

For the above, selected.value wasn't a option so changed to selected.result
Resulted in an error again, see below.

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

OK, if you've been changing the column types around, Power Apps is probably confused as to what type of data to expect in the column. Typically, it reads the table schema only during the connection of the data source, so please disconnect and then reconnect the data source. This will force Power Apps to re-read the schema and hopefully straighten this out for you.

Bryan

Was this reply helpful? Yes No
CGeorgeoff 23 on at

Like
a
(0)

Report
Copy link

Link copied!

I have deleted and re-added the data source without success. The equation is still returning the same error.

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@CGeorgeoff wrote:

I have deleted and re-added the data source without success. The equation is still returning the same error.

This version is non-delegable, but give it a try:

Filter(AreaID, Project_Selection_List_1.Selected.Result in 'Project 123')

If that still doesn't work, can you verify the answer to each of these questions:

AreaID is a SharePoint List which contains a column named 'Project 123'

'Project 123' is a column of type: single line of text

Project_Selection_List_1 is a dropdown

The Items property of Project_Selection_List_1 is Distinct('Project 123')

Is the answer "yes" to all 4 of those questions?

Bryan

Was this reply helpful? Yes No