cancel
Showing results for 
Search instead for 
Did you mean: 

Powerapps SQL Server Connector Search/Filter on DateTime columns

Hi,

 

unfortunately powerapps cannot search/filter on MS SQL Server datetime columns. You can read about this here;
https://powerusers.microsoft.com/t5/Building-Power-Apps/Date-DateTime-SQL-AZURE/td-p/13830/page/2

and here

https://powerusers.microsoft.com/t5/Building-Power-Apps/Filter-and-Lookup-not-working-with-date-valu...

I also opened a support ticket  with MS support and they could only provide workarounds that will not delegate the search to the SQL Server backend. Which is in our case not sufficient because we have far more than 2000 records (the max for delegation limit.

So here is my idea/request;

Please provide functionality to support delegation of datatime searches to MS SQL Server so there is now row limit and better performance

 

Thank you

Jan

aka MasterB

Status: New