Allow for passing dynamic filter in external data column control
In the External data column control, allow for dynamic filtering at runtime. Currently, you can not have a lookup to a MS SQL table that needs to be queried(filtered) by a value already on the form.
An example: A manager opens a form to enter a termination request. It gives them a dropdown that is connected to a MS SQL table view External Data Column control. That control would pass the filter of the manager username to the external content type, filtering the subordinates that report to him/her.

Thanks for your suggestion.
I will update this idea if there are any updates to share.
Cheers,
Euan