Answered

Filter Gallery by selected date and show data from a sharepoint list only on that date

(0) Share

Report

Posted on by jbucks

I am trying to filter a gallery that is linked to a SharePoint list called 'RFQ'. I have a Date field in it that automatically gets set to the current date time when created. I am trying to display any data that is on that date in the gallery.

Here is an example of the format of the "Date" field in my SharePoint list:

3/19/2024 8:33 AM

I have a Date picker which they use to select the date. I am converting the dates to be the same format as you will see below, I confirmed they get set to the correct format via testing with a label.

Here are 3 example I have tried that do not work:

Filter(
RFQ,
Text(Date, "mm/dd/yyyy") = Text(DatePicker1.SelectedDate, "mm/dd/yyyy")
)

Filter(
RFQ,
Text(DateValue(Date), "[$-en-US]mm/dd/yyyy") = Text(DatePicker1.SelectedDate, "[$-en-US]mm/dd/yyyy")
)

Filter(
 RFQ,
 ThisRecord.Date >= DatePicker1.SelectedDate,
 ThisRecord.Date < DatePicker1.SelectedDate
)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (1)

Report
hey @jbucks

can you try this please:

Filter( RFQ, DateValue(Text(Date, "[$-en-US]mm/dd/yyyy")) = DatePicker1.SelectedDate )

Alternatively, if you need to compare the date portions more explicitly and handle the datetime nature of your SharePoint Date field, you can adjust the filter logic to include all records from the start of the selected day to just before the start of the next day:

Filter( RFQ, Date >= DatePicker1.SelectedDate, Date < DateAdd(DatePicker1.SelectedDate, 1, Days) )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
jbucks 42 on at

Like (1)

Report

Thank you @mmbr1606 the second example worked great!

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report

@jbucks great that it helped 😉

Was this reply helpful? Yes No