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 / Filtering a sharepoint...
Power Apps
Unanswered

Filtering a sharepoint list depending on multiple conditions

(1) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

I'm currently making an app for car booking.

 

Most of the app is already runing smooth, i can make punctual booking that will only allow me to select a car that has not been booked yet depending on the date i choose.

 

I'm now trying to do a reccurent booking page.

The user can select the date etc ... and the app generate a collection filled with every booking entry.

 

So i have :

Collection1 : list of all the booking entry the user wants

SPList_planing : list of all the already existing booking

SPList_fleet : list of all the car aviable

 

What i used to filter the cars on the punctual booking page :

 

Filter(
SPList_Fleet,
Not(
Immatriculation in Filter(
SPList_Planing, [CONDITIONS TO CHECK THE DATETIME]).immat

My problem is i can't see how to do this in loop so i can filter the car list depending not just on one date like i did on the punctual booking page but on every date entry in the Collection1 so i'm sure that the cars i list to the user are aviable for every booking entry ?

Categories:
I have the same question (0)

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
WarrenBelz Profile Picture

WarrenBelz 429 Most Valuable Professional

#2
11manish Profile Picture

11manish 191 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 122 Super User 2026 Season 2

Last 30 days Overall leaderboard