cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TerrificTerri
Resolver II
Resolver II

Comparing 2 galleries

I feel really out of sorts here.  I know this answer is simple, but cannot seam to get the correct direction.  I want to compare the values in Gallery 1 to Gallery 2 and have to label in Gallery 2 return a value of true or false. (Then ultimately have to check mark in Gallery 1 show true if the values do not match.  However, the values will never be exactin.)

 

Any help in the right path would be much appreicated.  I am urently needing this and have spent a lot of time going nowhere (it feels).  Thanks you

Capture.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User
Super User

@TerrificTerri 

 

If you are just trying to return a true or false if the item in Gallery 2 (right) is in Gallery 1 (left), then put this formula on your label.

Lookup(galIncomingExcelDate.AllItems, StartsWith(lblAssignedTo.Text, lblSPAssignedTo.Text), true)

That will give you what you are looking for.

 

I hope that 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

3 REPLIES 3
RandyHayes
Super User
Super User

@TerrificTerri 

 

If you are just trying to return a true or false if the item in Gallery 2 (right) is in Gallery 1 (left), then put this formula on your label.

Lookup(galIncomingExcelDate.AllItems, StartsWith(lblAssignedTo.Text, lblSPAssignedTo.Text), true)

That will give you what you are looking for.

 

I hope that 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!

totally awesome......all you PowerApps people Rock!  Thanks for the help

 

CBThree
New Member

I have a similar but different question. I have a gallery that displays a list of users that have completed the review of a document and I would like to compare it to another list of all users in the department to return a list of people that have not reviewed the list. 

I’m sure there’s a simpler way to do this, but I new to PowerApps 

 

Can you help?

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Kudoed Authors
Users online (3,446)