Answered

SharePoint List not showing items - Date Issues

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello everyone! I have created 4 SP Lists that all contain a date field. I have set up the gallery for each list so that the data will only display when the date picker selected = A date in each of the SP lists. (Each Gallery has a similar Filter.)

It works for all dates except for the single digit day dates that contain a zero in the front. The format for each date field in the SP List is "mm/dd/yyyy".Examples below:

Any bit of help will be appreciated!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

WiZey 3,023 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @Anonymous ,

Have you tried this format?

Text(DatePicker.SelectedDate; "m/dd/yyyy")

In your filter it would look like this:

Filter( source, Text(DatePicker.SelectedDate; "m/dd/yyyy") in Title )
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@WiZey Thank you for responding. However, now the complete opposite is happening. All dates with single day dates (ie. 7/03/2022) show up but any double digit days (ie. 7/12/2022) do not show.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@WiZey I went into the SP lists to make sure that single digit dates like 7/7/2022 or 12/7/2022 were changed to 07/07/2022 and 12/07/2022. Still using your formula, I just changed the date format to mm/dd/yyyy and it's working perfectly! Thank you!!