web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Need help checking if ...
Power Apps
Unanswered

Need help checking if a certain Date/Time would fall under any Start and End time range of any item in my SharePoint list.

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello,

 

First and foremost, I am very new to PowerApps and SharePoint lists, so bear with me if certain things are obvious or seem lacking in effort on my part; I assure you I am trying my best..

 

I'm working on a PowerApp which uses SharePoint lists as its primary data source. In my SharePoint list, I have various items that contain a start and end time in a Date/Time format. Within my power app, I would like to be able to check if a certain date/time would overlap with any of the start and end times in my SharePoint list. So, if I have 01/01/2019 1:00 AM, any item in my Sharepoint list that has start and end times that the above date would fall under would be obtained and stored in a collection of some sort.

 

I have some vague ideas on how I could approach this, but as a whole, I am fairly lost. If anyone could put me in the right direction I would very much appreciate it. I am assuming I would need some sort of loop to be able to iterate through the SharePoint list, but I'm not sure if PowerApps has this kind of functionality. Maybe using a Flow action would help with this, but I am also not too familiar with flow either. This is my very first app, so any advice is appreciated.

 

Thanks again.

Categories:
  • RezaDorrani Profile Picture
    12,145 on at

    Hi @Pundrew 

     

    You can use

    Filter(DataSource,EndDate > Today() && StartDate < Today()) this should give you all the records that are within the current time frame

     

    You can replace Today with your date field value

    DateField.SelectedDate

     

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at
    Would this account for the time as well? Because time is the more important piece that I'm trying to match, rather than the date.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 402 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 296 Most Valuable Professional

Last 30 days Overall leaderboard