cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Naps
Helper I
Helper I

Filter image column based on different column value in the same row

Hi,

 

I have two tables. A parts table which contains an column called Part_Image and a column called Part_Name and a service table which contains a column called Service_Part_Name (value matches the parts table). 

I have a gallery that displays some data from the service table but I want to load the image from the parts table but I can't quite figure out how I can filter for my image column.

Filter(Parts, Parts_Part_Name = gallery.select.Service_Part_Name) retrieves the whole row but how can I retrieve only the Part_Image column so I can actually display it as an image?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Nogueira1306
Community Champion
Community Champion

LookUp(Parts, Parts_Part_Name = gallery.select.Service_Part_Name).Part_Image

 

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

View solution in original post

2 REPLIES 2
Nogueira1306
Community Champion
Community Champion

LookUp(Parts, Parts_Part_Name = gallery.select.Service_Part_Name).Part_Image

 

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

View solution in original post

Thanks, that did the trick. One small adjustment I had to make was changing gallery to ThisItem.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,860)