web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to compare two gal...

Power Apps

Suggested Answer

How to compare two galleries

(1) Share

Report

Report

Posted on by MB-09091235-0

2

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

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,970 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

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?
Suggested answer

Ammar Zaied 97 on at

Like
a
(0)

Report
Copy link

Link copied!
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.

Join the conversation