Filter from Sharepoint to Grid ,date is Empty ,and delegation....

[llserra]

Hi

I have problems with delegation with a Sharepoint List ,with a field (Fecha_baja) Date/time to a grid, i woud like to show records with this field are empty ,but i tryed many ways with result. Does anybody can help me?

Filter(inventario;sede=varUsuario.OfficeLocation && Alquiler=1 && IsBlank(Fecha_baja)

Filter from inventario

with sede its my location ,Works

Alquiler=1 ;Works

IsBlank(Fecha_Baja) ; Not works

Try with Errors:

Text(Fecha_baja;DateTimeFormat.LongDate)=Blank()
Text(Fecha_baja;DateTimeFormat.LongDate)<>""

IsBlank(Fecha_baja)  ; Works but not show records after 2000

Any idea?
Thanks

[WarrenBelz · Accepted solution]

Hi @llserra ,

Firstly, Date queries are not Delegable, so the 2,000 record result is predictable, however I just tried this on a big list

Filter(
   inventario;
   sede=varUsuario.OfficeLocation && 
   Alquiler=1 && 
   Fecha_baja=Blank()
)

and it seemed to work (it is not looking for date values), returning 3,000 records and counting.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[llserra]

Thanks works!