Powerapps Delegation Issue: Sharepoint List and Date

[skewa1]

I am having a problem with my SharePoint List. My filter, below, hasa delegation problem:

I am trying to filter by Month formatted as mmm-yyyy

Filter(Text(Submission_Date,"[$-en-US]mmm-yyyy")=Dropdown1_2.Selected.Value||Dropdown1_2.Selected.Value=Blank())

My Drop down dates at formatted in mmm-yyyy (e.g. Oct-2022). Submission_Date (in sharepoint) is in Date format.

[BideyYusuf · Accepted solution]

Hello @skewa1 

Normally you cant filter a date column with a text. what i do in this situation is create a text column separately to get any date i select in text value. then i can use a text to filter a text and it would work perfectly.

Filter([Datasourse],DateTextColumn= Dropdown1_2.Selected.Value||Dropdown1_2.Selected.Value=Blank())

you can also use a datepicker to do this for you easily.

You can try this:

Filter([Datasourse],DateColumn = DatePicker1.SelectedDate || IsBlank(DatePicker1.SelectedDate))

The Format can be on your Label control properties, you dont need to put it on the filter -  Text(ThisItem.DateTest,"mmm, yyyy")

The date Picker will still filter the value from the selected date.

Find attached GIF file to see it works.

Hope this helps

[v-liwei-msft]

Hi @skewa1 

If your datasource is SharePoint then there is no way to get around delegation warning (and incomplete results) for large lists when filtering with dates.  

DateTime values are not delegable in SharePoint.

I recommend that you add the data source to a collection first, so as to avoid delegation warnings

Best Regards,

Levi