Filter gallery with relationship sharepoint lists

[nasolme]

Hi community,

I have 2 sharepoint lists (customers and deals).

In the first gallery I look for my client. In the second I want to display the deals associated with my customers. The primary key in the customer list is "ID" and repeated in the deals list is "SIREN_ID".

So i don't understand why my formula return an error :  Filter(BDD_DEAL; BrowseGallery1.Selected.Titre = SIREN_ID) 

[gabibalaban]

@nasolme ,

Maybe 

Filter(BDD_DEAL; BrowseGallery1.Selected.ID = SIREN_ID) 

will do the job ?

[nasolme]

@gabibalaban No.. 

[gabibalaban]

@nasolme ,

In your formula, you want to compare an integer with a text. As I undestood the relationship  between the lists is ID -> SIREN_ID is one to many.

maybe I missed something 

[nasolme]

The ID in customers List is an automatic number.
In the Deals list, i found this ID with LookUp.

And yes, a customers can have many deals

[RandyHayes]

@nasolme 

@gabibalaban is correct that your formula should be:

Filter(BDD_DEAL; SIREN_ID=BrowseGallery1.Selected.ID) 

What is the error you are getting from that?

[nasolme · Accepted solution]

@RandyHayes 

@gabibalaban

I found the solution. the difficulty was that my customer ID in my deal list comes from a lookup column. So the value was not recognized as a number.

I had to add ".Id" after "SIREN_ID"

Filter(BDD_DEAL; BrowseGallery1.Selected.ID = SIREN_ID.Id)