cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LorenzoSP365
New Member

SharePoint List not showing items - Date Issues

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.)

OnCallTeams.png

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:

Date1.png

Date2.png

 

Any bit of help will be appreciated!

1 ACCEPTED SOLUTION

Accepted Solutions
WiZey
Super User
Super User

Hello @LorenzoSP365 ,

 

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
)

View solution in original post

3 REPLIES 3
WiZey
Super User
Super User

Hello @LorenzoSP365 ,

 

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
)
LorenzoSP365
New Member

@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.

LorenzoSP365
New Member

@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!! 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,339)