web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Compare two collection...

Power Apps

Answered

Compare two collections & filter gallery

(0) Share

Report

Report

Posted on by JmeBrey

55

Hello,

I would like to compare 2 collections in 2 galleries, remove the duplicate values and only show the remaining items . Please see the screenshot below

I have a collection that holds booked desks, and a collection that shows all desks. I would like the gallery 'GalleryDesks' to ommit the 2 entries in 'galleryBooked' - is this possible?

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Ram Prakash Duraisamy 5,877 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @JmeBrey,

You can try below query,

You need to use ForAll inside ForAll to find the query and remove the value from collection

ForAll(galleryDesk,ForAll(galleryBooked,If(galleryDesk.Desk=galleryBooked.Desk,Remove(galleryDesk,First(Filter(galleryDesk,Desk=galleryBooked.Desk))))))

Let me know if you have any queries

Please Mark as Answer if it's helpful

Subscribe:https://youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

Blog:https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @JmeBrey :

Do you want to get desks that are not booked in ‘Available desks’?If so,please try:

I assume there are two tables:

ClearCollect('Booked desks',{Name:"Desk 1",Date:"2-25"},{Name:"Desk 2",Date:"2-29"}); ClearCollect('Available desks',{Name:"Desk 1",Date:"2-25"},{Name:"Desk 1",Date:"2-29"},{Name:"Desk 1",Date:"2-30"},{Name:"Desk 1",Date:"2-36"},{Name:"Desk 1",Date:"2-37"},{Name:"Desk 2",Date:"2-41"})

Please try:

Filter('Available desks',!(Name&Date in Concat('Booked desks',Name&Date)))

Best Regards,

Bof

Was this reply helpful? Yes No

Join the conversation