Unanswered

Filter with Index function throw error

(0) Share

Report

Posted on by rameshmukka

1,115

I earlier used Index function to filter a collection or gallery with multi select values from a combo box without any issue. Today I have noticed this weird error while using the same index function.

The second argument to the 'Index' function must be between 1 and 1, the lower and upper bounds of the table. The upper bound may be reduced due to the non-delegation limit.

Here is my code at OnChange property of my combo box. My 'Project Type' column is a single line of text column in my data source.

ClearCollect(
 colPLEWebTemp,
 Filter(
 'PVRT Metrics List',
 And(
 Division = cmb_Filtr_Division.Selected.Title,
 Department = cmb_Fltr_Dept.Selected.Title,
 Or(
 IsEmpty(Self.SelectedItems),
 IsBlank(Self.SelectedItems),
 'Project Type' = Index(
 Self.SelectedItems,
 1
 ).Title,
 'Project Type' = Index(
 Self.SelectedItems,
 2
 ).Title,
 'Project Type' = Index(
 Self.SelectedItems,
 3
 ).Title,
 'Project Type' = Index(
 Self.SelectedItems,
 4
 ).Title,
 'Project Type' = Index(
 Self.SelectedItems,
 5
 ).Title
 )
 )
 )
);

The combo box items property has

SortByColumns('Project Types List',"Title")

Has anything changed recently with respect to this function or related areas. Kindly help what could be done here?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

WiZey 3,023 Moderator on at

Like (0)

Report
Hello @RameshMukka ,

The way "Index()" works, it looks for the Nth record in the collection. If your collection has less than 5 items, it won't be able to retrieve an inexistant 5th item, thus returning the error.

One way you could maybe fix it is checking if the "Project Type" exists in the table of selected items from your combobox.

ClearCollect( colPLEWebTemp, Filter( 'PVRT Metrics List', And( Division = cmb_Filtr_Division.Selected.Title, Department = cmb_Fltr_Dept.Selected.Title, Or( IsEmpty(Self.SelectedItems), IsBlank(Self.SelectedItems), 'Project Type' in Self.SelectedItems.Title ) ) ) );

Was this reply helpful? Yes No
rameshmukka 1,115 on at

Like (0)

Report

@WiZey Thanks for the clarification. However Index function helps to deal with the delegation problem. "in" operator brings me delegation issue. My list is going to have more than 2000 items. Is it achievable?

Was this reply helpful? Yes No
WiZey 3,023 Moderator on at

Like (0)

Report
Yes, you can store your records in a local collection, thus removing the delegation warning.

1st: Collect(collection, datasource) 2nd: Filter(..., status in collection.column)

Was this reply helpful? Yes No
rameshmukka 1,115 on at

Like (0)

Report

@WiZey Isn't the "in" operator here causing the delegation problem? I have to check the column value in the combobox selected items. As long as I have "in" operator, I will have delegation problem.

Was this reply helpful? Yes No
joe-mv 2 on at

Like (0)

Report

@RameshMukka - Did you ever find a solution to this problem and overcome Delegation?

Was this reply helpful? Yes No
jpullins1 on at

Like (0)

Report

Were you able to resolve this issue? My filter literally just stopped working, claiming to have the same issue.

Was this reply helpful? Yes No
rameshmukka 1,115 on at

Like (0)

Report

@jpullins1
There is an old method of doing it. Reza Dorrani described both methods here. Please check it out. I had to use old method to get around the issue.
https://youtu.be/Wr42PeW6_wU

Was this reply helpful? Yes No