cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NathanSweeney
Frequent Visitor

Two galleries, find matches between eachother.

I have two galleries with two different data sets. Both have one common column.

I would like the fill on each gallery item to change to green or not, depending if there's a match in the other gallery.

 

I don't want to search the source data, just the galleries specifically.

I've failed trying to figure this out, help would be appreciated, thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User
Super User

@NathanSweeney 

You can reference the AllItems property of the Gallery to determine the match as AllItems is a table of all of the items in a gallery.

 

So for example, if your first Gallery has a text column called "Title" and you want to match with that, then in your second gallery, you can the TemplateFill property to the following:

 

If(ThisItem.TitleColumn in Gallery1.AllItems.TitleColumn, Green, Transparent)

 

This would set the row to green if there is a match.

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

1 REPLY 1
RandyHayes
Super User
Super User

@NathanSweeney 

You can reference the AllItems property of the Gallery to determine the match as AllItems is a table of all of the items in a gallery.

 

So for example, if your first Gallery has a text column called "Title" and you want to match with that, then in your second gallery, you can the TemplateFill property to the following:

 

If(ThisItem.TitleColumn in Gallery1.AllItems.TitleColumn, Green, Transparent)

 

This would set the row to green if there is a match.

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,025)