Simple Date filter not working on the gallery

[RameshMukka]

I have the Date column "Date" in my SharePoint list and it is connected to my Canvas App and my filter on the gallery is below

Filter(
    'Raw Materials',
    datDateFilter.SelectedDate = Blank() || Date = datDateFilter.SelectedDate,
    drpMaterialTypeFilter.Selected.MaterialType = "All" || MaterialType = drpMaterialTypeFilter.Selected.MaterialType,
    drpSupplierFilter.Selected.'Supplier Name' = "All" || Supplier = drpSupplierFilter.Selected.'Supplier Name'
)

Below are the gallery items when no filter is selected

When I select the date filter, it doesn't fetch any items. Its so simple and doesn't work for the reason I don't understand. 

What's so cooking I am confused. Am I missing anything here?

Thanks,

Ramesh

[RameshMukka]

So weird that the Date filter doesn't work only for 01/07/2022.

[Drrickryp]

@RameshMukka 

Your problem suggests that there is something wrong with the way 01/07/2022 is stored in your list.  Go back to the original list in SharePoint and look at the actual date that is stored for 01/07/2022.  It may include a space at the end or may have been stored as a date/time.  In any event, consider deleting it and replacing it.  Then refresh the screen and go back into the app and refresh the SharePoint list. 

[RameshMukka]

I just have to edit the same record in SharePoint list to re-enter the date value. It started working. 

[Drrickryp]

@RameshMukka 

Yep, it sounds like the date for that record was corrupted somehow. You found a simple fix but often fixing the value in the original list is necessary.  Also, checking on the original data would have given you a clue as to what went wrong with it so it doesn't happen again. 

[PritishT]

Hi @Drrickryp : Thank you, it helped. I was wondering if there is a way I can modify my existing code to still use the same SharePoint Column instead of creating another one just for this scenario. My code is as below

On Visible of Home Screen I run below

Set(_dateSelected,Today());
Set(_firstDayOfMonth,DateAdd(Today(),1-Day(Today()),TimeUnit.Days));
Set(_firstDayInView,DateAdd(_firstDayOfMonth,-(Weekday(_firstDayOfMonth)-2+1),TimeUnit.Days));
Set(_lastDayOfMonth,DateAdd(DateAdd(_firstDayOfMonth,1,TimeUnit.Months),-1,TimeUnit.Days));
Set(_calendarVisible, true )

This is the Calendar View

 

Inside each date I added a Gallery control which has the below Filter function in its Items property

Filter( 
    'GFS FSS',
        Proposed_Date_of_Event=DateAdd(_firstDayInView,ThisItem.Value,TimeUnit.Days)
     && (IsBlank(drpdApproved.SelectedItems)||IsEmpty(drpdApproved.SelectedItems)||Approved.Value = drpdApproved.Selected.Value)   
     && (IsBlank(drpdHome_LocationFilter.SelectedItems) || IsEmpty(drpdHome_LocationFilter.SelectedItems) || Location.Value = drpdHome_LocationFilter.Selected.Value)
)

Now this is where the problem comes, earlier last month my SP column which has just the date, Filter function was returning item however now its not and its as you mentioned earlier. the _firstDayInView returns 2/25/2024 12:00 AM and its comparing with the SP column which just has the date

Thank you in advance

[PritishT]

adding to @RameshMukka point about refreshing the item, I dont want to refresh every individual item in the list coz its more than 1000 records