Share
ReportHow can I filter a data table by date of the day in powerapps? I want to see only the data entered on the current day of a list in sharepoint
Categories:
You’re offline. This is a read only version of the page.
How can I filter a data table by date of the day in powerapps? I want to see only the data entered on the current day of a list in sharepoint
Hi @Anonymous
Do you mean you want to filter the data table based on the day of Today? Please try this:
All responses (
Answers (
Filter('SP list','Date Column'>=Today() && 'Date Column'<=Today())
However, since Actual Date values are not delegable for SharePoint in PowerApps, there should be some delegation warnings on the formula.
If your SharePoint list is less than 2000 records, you can ignore these warnings.
If your SharePoint list is more than 2000 records, one way is to create a Text column in your SharePoint list to convert the Date to Text, e.g. "m/d/yyy" format, then filter the list based on 'Date2Text' column which is delegable.
Filter('SP list',Date2Text=Text(Today(),DateTimeFormat.ShortDate))
You also can refer to this thread: https://powerusers.microsoft.com/t5/Building-Power-Apps/filter-a-column-by-todays-date/td-p/252420
Hope this helps.
Sik
35
