Filter a Gallery with Date from a SharePoint list

(0) Share

Report

Posted on by lliu_western

289

Hello community,

I have a gallery that reads from a SharePoint list (ListA) and display records from that ListA. I have a dropdown filter with distinct date value from List A.

I want to filter the gallery with the dropdown. I tried formulas like the one below, but it's not working.

Filter('List A', 'Work Date' in Dropdown_FilterDate.SelectedText.Value)

I know it's because the dropdown is reading the dates as text but and in SharePoint, the colume for "Work Date" is set to be a date so the two format are not matching, hence not filtering. But I tried converting the Dropdown_FilterDate.SelectedText.Value to a date such as Filter('List A', 'Work Date' in Date(Dropdown_FilterDate.SelectedText.Value)) but it still doesn't work

any help and advice is appreciated. Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

WarrenBelz 154,393 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @lliu_western ,
Try
Filter( 'List A', Text('Work Date',ShortDate) = Text(Dropdown_FilterDate.SelectedText.Value,ShortDate) )
or maybe
Filter( 'List A', DateDiff( 'Work Date', DateValue(Dropdown_FilterDate.SelectedText.Value), Days )=0 )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
lliu_western 289 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz Thank you so much for your quick respond. Tried both, but not working, still keep trying. Thanks

Was this reply helpful? Yes No
lliu_western 289 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz Actually, never mind, it worked! I had another filter that was causing it not working. THANK YOU.

Was this reply helpful? Yes No