Power Platform Community Forum Thread Details

Issues with filtering a gallery using a date picker

Hello!

Right now I have four date only columns in a dataverse table, S1, S2, S3, and S4. When I created a form in my app including these date fields, only S1 appeared as a Date Only field, as the other 3 (S2, S3, and S4) included hour and minute fields. I was confused as to why, but I hid them and moved on.

Now, I'm trying to filter this list in a gallery using a date picker (date_picker) control and it appears that only rows in the table are filtering correctly from the S1 field. The others (the ones with the hour and minute fields included when I made the form) aren't comparing correctly when the list is being filtered. I'm a bit confused as to what's going on.

I verified that the columns are Date Only columns in the dataverse. I'm also able to correctly compare the date fields when applying some conditional formatting like highlighting matching dates. The issues I run into is when I'm trying to filter the table using the code below:

Filter('[SOURCE], ThisRecord.S1=date_picker.SelectedDate || ThisRecord.S2=date_picker.SelectedDate || ThisRecord.S3=date_picker.SelectedDate || ThisRecord.S4=date_picker.SelectedDate)

Interestingly, when I expand this code to convert all dates to ShortDates, it filters correctly. This code below, works:

Filter('[SOURCE]', IsBlank(date_picker) || Text(ThisRecord.S1, DateTimeFormat.ShortDate)=Text(date_picker.SelectedDate, DateTimeFormat.ShortDate) || Text(ThisRecord.S2, DateTimeFormat.ShortDate)=Text(date_picker.SelectedDate, DateTimeFormat.ShortDate) || Text(ThisRecord.S3, DateTimeFormat.ShortDate)=Text(date_picker.SelectedDate, DateTimeFormat.ShortDate) || Text(ThisRecord.S4, DateTimeFormat.ShortDate)=Text(date_picker.SelectedDate, DateTimeFormat.ShortDate))

The problem with this is that the Text Function won't delegate and I anticipate that becoming an issue down the road.

Are there any known issues with Date columns between the Dataverse and PowerApps? I'd love to get this to work without running into the delegation issues related to Text Functions.

Thank you in advance!

Categories:

Entities

Tables

Microsoft Dataverse

Quick Links