how to filter a gallery excluding collection data

(0) Share

Report

Posted on by TomasGomes

Hi, I'm relatively new to powerapps and I'm creating an app to reserve parking spaces.

When I reserve a place, I would like that same place to stop appearing in the gallery where available places appear.

Until now, when a new reservation is created, the user first chooses the dates and at that moment I create a collection where I insert the data of the reservations that exist with those dates.

Now I want the gallery to show all the items in the list of places except the records that are in the collection (the records that have the same date)

this is where a collection is created:

this is what I put in gallery; Items and the error:

this are my lists:

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@TomasGomes

Filter(yourlistingallery, !(ID in yourcollection).ID))

Was this reply helpful? Yes No
TomasGomes 8 on at

Like (0)

Report
Copy link

Link copied!

thanks for your support but unfortunately didn´t work

Was this reply helpful? Yes No
Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Try

Filter('PA007 Parking Spot', !ID in reservationsInDates)

Was this reply helpful? Yes No
TomasGomes 8 on at

Like (0)

Report
Copy link

Link copied!

my objective was the opposite of that, but still don´t work

Was this reply helpful? Yes No
Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Oops! The ID should just be the SharePoint List ID... maybe try
Filter( 'PA007 Parking Spot', Not(Filter('PA007 Parking Spot', Title in reservationsInDates)) )

Was this reply helpful? Yes No
TomasGomes 8 on at

Like (0)

Report
Copy link

Link copied!

still don´t work, maybe another way to exclude from the gallery the items with the same date as the selected one ?(like when the user chooses a date, reservations already made on that same date do not appear in the gallery)

Was this reply helpful? Yes No
Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I see the problem... the "in" operator only works on a one-column table. What about this:

Make a new column in your 'PA007 Parking Spot' list named "Reserved", default value "false"
When you collect the items for reservationsInDates, patch the 'PA007 Parking Spot' value for this column to "true"
Then filter 'PA007 Parking Spot' for Reserved = false

Was this reply helpful? Yes No
Verified answer

Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@TomasGomes I think I got it this time:

1) Add a new collection, one column only, to store the Spot (or other unique identifier). This can be collected as the same time as your reservation. Example:
Collect(reservationsInDates,{Spot: TextInput.Text, 'Date From': TextInput2.Text, 'Date To': TextInput3.Text}); Collect(reservationsFilter,{Spot:TextInput.Text})
2) Use that for your filter. Example:
Filter(ParkingSpot,Not(Spot in reservationsFilter),Spot)

In the above example, the first gallery is all the spots, which in your case I'm assuming is your 'PA007 Parking Spot' list. Then I collected the reservation into two collections. In your case, it would be collected in reservationsInDates and the new one column collection. Lastly, filter out those items in the one column collection.

Was this reply helpful? Yes No