Unanswered

How to compare two galleries

(1) Share

Report

Posted on by MB-09091235-0

Hello, I have created two galleries that are linked to two different databases. I'd like to compare the items in these two galleries. The item is Site label. If the text has the same value, I'll display it as follows. It's possible ?

Categories:

Building Power Apps

I have the same question (1)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (1)

Report

Hi

Unfortunately no matter how many times I load your question, I see nothing below your words, so :-( I am unable to help you much.

But you aren't really comparing the galleries, you care comparing just a single Column correct?

Was this reply helpful? Yes No
Suggested answer

Ammar Zaied 97 on at

Like (0)

Report
it's possible to compare the items between two galleries and display them if the Site label has the same value. Here’s a basic way to achieve this in Power Apps:

Steps:

Assume two galleries, Gallery1 and Gallery2, are linked to two different data sources. Each gallery has a text label showing the Site label.

Add a label to your screen where you want to display the matching Site labels.

Use a formula to compare the items in the two galleries. Here's an example of how you can do it:

ForAll(Gallery1.AllItems, If( !IsBlank( LookUp(Gallery2.AllItems, SiteLabel = ThisRecord.SiteLabel) ), Concat(ThisRecord.SiteLabel, Text(ThisRecord.SiteLabel) & ", ") ) )

Explanation:

ForAll(Gallery1.AllItems, ...): Loops through all the items in Gallery1.

LookUp(Gallery2.AllItems, SiteLabel = ThisRecord.SiteLabel): Searches for the item in Gallery2 where the Site label matches the current item in Gallery1.

Concat: Combines all the matching Site labels from the galleries.

ThisRecord.SiteLabel: Refers to the Site label in the current record of Gallery1.

Was this reply helpful? Yes No