Gallery - Show only items that find match in a collection

(0) Share

Report

Posted on by plona95

Hi, here is my scenario:

I have:

- Collection 1, with A, B, C, (...), Z (let's say all the letters are there),

- Collection 2, with only "S", "C", and "G" letters in (3 entries)

- Gallery 1 using collection 1

I would like the Gallery 1 to show only these items from the Collection 1 with at least 1 match in the Collection 2 (so in our example, the Collection 1 should only show letters "S", "C", and "G").

I can't switch it for collection 2. Would you have any advice how to filter it in a right way?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

sperry1625 763 Super User 2024 Season 1 on at

Like (1)

Report
You should be able to Filter Collection 1 using Collection 2, something like this.

Filter( colOne, Name in colTwo.Name )

Use this formula in your Items property for your Gallery.

This assumes a colOne structure with a Property of Name.

Regards,

-S

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Akser 1,546 Moderator on at

Like (0)

Report
I assume the gallery's item property should look like:

Filter(Collection1, Collection1[@LetterColumnName] in Collection2[@LetterColumnName])

Was this reply helpful? Yes No