link between two lists to display image

[Ben-00-38]

Hello,
I have two lists:
-equipment
- brands

on powerapps a gallery displays the items of the material list.

I would like to display the brand listing logo in the gallery.

in summary if brands ID = material ID brand.

equipement

item = Marque ID

marques

item = url

what would be the code?

[Bilakanti]

@Ben-00-38 ,

You can use AddColumns to get the url from Marques list.

AddColumns(Materiel, "url", Lookup(Marques,Marquename=Titre,url))

[Ben-00-38]

dont' work...

I don't want to add a column to the material database but display
the base image marks based on IDs.
if marque ID (material) = ID (brands) I display brands url.
lookup? may be...

[WarrenBelz · Accepted solution]

Hi @Ben-00-38 ,

This should display the image in an Image control in a Form or Gallery

LookUp(
   Marques;
   Titre=ThisItem.'Marque nom'
).url

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Ben-00-38]

thanks a lot 😀