Hi there, I've been having major problems implementing the following:
I have a two tables in Dataverse:
I have a lookup column in ProductionRun that references Equipment (so I can track what equipment was used for a particular production run).
I have a Model-driven app and need to create a dropdown that will select the equipment table. I also need to filter dropdown options based on a column value in Equipment (i.e., selecting a subset of equipment for selection).
I decided to try and do this in an embedded canvas app, however I cannot figure out how to set the value of the lookup field in the canvas app. Ideally I'd like the option to save to the ProductionRun table when the onChange event is fired, but don't know what the correct statement is.