Hello again, community!
Long after talking with my team about the limitations of Microsoft Lists as a data source, we have decided to switch to Dataverse as our data source for the canvas app I'm working for my company's asset management. In the process, I have decided to create a model driven app and delve into learning about this new data source within Microsoft Learn.
In the process, I've built a more normalized structure of tables, amongst which my concern within this message is a trio of tables for an Asset Type, a Model and an Asset, each linked in reading order with a one-to-many relationship through lookup columns.
For all the forms within the latter table, I have a Phone line lookup column which I need to show and mark as mandatory only when the asset model's type is a smartphone. However, the included business rule modeler doesn't seem to allow me to add other tables for the purpose of making this validation.
Is this an inevitable limitation of the modeler? Are there any other ways I can try to apply this rule?
