Dynamic drop down options

Hi All,   I am creating application where I am importing the data from excel sheet After importing the data people should be able to edit data They will edit one field and they should get drop down options to change other fields based on the field changed I am able to implement upto this But I have a special requirement For eg, I have three tables with following associations employee info,             department    department leader   I need that if   when the department is changed  drop down for leader should give all options related to the department (based on value of associated leader related to that dept in other rows  ).I have already tried setting selectable objects for reference selector but the drop down shows no value then   Thanks in Advance
1 answers

In selectable objects option, you can set a microflow as a source that will return a list of objects of your dropdown entity. In that microflow, you can filter objects based on whatever conditions you want to.