I am building a custom page for a model driven app.
I have two tables with a one-to-many relationship: Investor Account > Investor Product.
In Investor Account, my PK is Investor Number - a single line text field.
In Investor Product, I have a lookup field that points to Investor Account; the field is named Investor Account.
I have two galleries - see screenshot.
On the left is a gallery for the parent - IAGallery with data from Investor Account table.
On the right is a gallery for the child - IPGallery with data from Investor Product table.
I want to select a record from the gallery on the left - IAGallery, and it must filter the records in the gallery on the right - IPGallery.
In the second gallery - IPGallery, for Items, my formula looks like this:
Filter('Investor Products',IAGallery.Selected.'Investor Number'='Investor Account')
The error says I am comparing a text and a record - see screenshot.
What am I missing please?
