web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Search between dates -...

Power Apps

Answered

Search between dates - Powerapps

(0) Share

Report

Report

Posted on by Kumar9024021

195

Hi,

I have a date field (Event From Dt, Event To Date) in my form as per below screenshot. Based on the date selected, I should search my sharepoint list and show records in Gallery. Any inputs would be helpful.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hey @Kumar9024021

If you want to search for the event in a specific time period, you can use the below expression:

Filter(DataSourceName, EventDate > DatePicker1.SelectedDate && EventDate < DatePicker2.SelectedDate)

Here, DatePicker1 is used to select the start date of the range and DatePicker to select the End Date of the range.
EventDate is the name of column in your data source.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

1 people found this reply helpful.

Was this reply helpful? Yes No
klethbridge 2 on at

Like (0)

Report
Copy link

Link copied!

I am experiencing the same issue. It will only work with a single date, but not between two dates. Have tried multiple variations on the above suggestions.

Was this reply helpful? Yes No

Join the conversation