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)
Solved! Go to Solution.
@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)
@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
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
@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?
@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)