You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I am trying to come up with a solution to a dropdown multi-select filter that is going to filter text type column in my details list.
Bellow is the example of a formula that is currently on my details list Items property and actually works if drop down has 2 items selected. If it has 0 it returns this error: "Nested errors not supported in this control property: The 'Index' function cannot be called with an empty table." and if it has only 1 item selected it returns this error: "Nested errors not supported in this control property: The second argument to the index function must be between 1 or 2, the lower and the upper bounds of the table. The upper bounds must be reduced due to the non-delegation limit." If I have more than 2 item selected it doesn't do anything and does not return an error either. Plan is to have 5 selected items possible for filtering.
Is there any idea for the solution to this issue? Any comment would be appreciated.
Filter(
colData,
Index(ddFilterProgramInicijativa.SelectedItems, 1).Name in ProgramInicijativaTO Or IsBlank(Index(ddFilterProgramInicijativa.SelectedItems, 1).Name),
Index(ddFilterProgramInicijativa.SelectedItems, 2).Name in ProgramInicijativaTO Or IsBlank(Index(ddFilterProgramInicijativa.SelectedItems, 2).Name))
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Hello everybody!
I am trying to come up with a solution to a dropdown multi-select filter that is going to filter text type column in my details list.
Bellow is the example of a formula that is currently on my details list Items property and actually works if drop down has 2 items selected. If it has 0 it returns this error: "Nested errors not supported in this control property: The 'Index' function cannot be called with an empty table." and if it has only 1 item selected it returns this error: "Nested errors not supported in this control property: The second argument to the index function must be between 1 or 2, the lower and the upper bounds of the table. The upper bounds must be reduced due to the non-delegation limit." If I have more than 2 item selected it doesn't do anything and does not return an error either. Plan is to have 5 selected items possible for filtering.
Is there any idea for the solution to this issue? Any comment would be appreciated.
Filter(
colData,
Index(ddFilterProgramInicijativa.SelectedItems, 1).Name in ProgramInicijativaTO Or IsBlank(Index(ddFilterProgramInicijativa.SelectedItems, 1).Name),
Index(ddFilterProgramInicijativa.SelectedItems, 2).Name in ProgramInicijativaTO Or IsBlank(Index(ddFilterProgramInicijativa.SelectedItems, 2).Name))
Thank you in advance!
Beta Was this translation helpful? Give feedback.
All reactions