Hello.
I am trying to filter the fields of my sharepoint list as long as the field is not equal to "Canje" but when doing so I get a delegation error and it does not load all the data. This error does not occur if I put the fields that I want to show, but since there are several of them and they will probably increase in the future, I don't want to have to do it that way.
I try it like this using not:
Filter(
Testing;
Not(Estatus="Canje");
StartsWith(
Nombre;
txtFiltro.Text
) || StartsWith(
Codigo;
txtFiltro.Text
)
)
But it only works doing it like this:
Filter(
Testing;
Estatus = "Estatus1"|| Estatus = "Estatus2" || Estatus = "Estatus3" || Estatus = "Estatusx";
StartsWith(
Nombre;
txtFiltro.Text
) || StartsWith(
Codigo;
txtFiltro.Text
)
)
