I'm really struggling with pulling data across a relationship in a canvas app and am hoping someone can help me.
I have two tables (at least just the two right now) - Approval and Placement. In the Approval Field is a columns labelled 'Regarding' which appears to have multiple relationships across multiple tables - including the Placement table. Following a video from PowerApps911 here:
My first thought was to look for the field in the field list, but the 'Regarding' field isn't list and nor are any of the fields in the related table. After doing some digging in the community I came across a similar post that led me here:
I believe I am in a minority but I have always thought that polymorphic relationships (I think now also called multi-table relationships) are a terrible idea that go against normalisation principles and create much unnecessary confusion for limited/questionable benefit. My understanding is that they are not well supported in canvas apps but as MS has recently doubled-down on them, there may be some new features in canvas apps to provide additional support either recently added or in the pipeline.
Last time I had to deal with these I seem to recall that the D365 team just put in redundant relationships / repeated fields across the entities to give us something we could run delegable filters on.