Data query dynamic drop down in details section

[Met]

Hey,

At the moment when adding a dynamic dropdown to the Details section it only seems possible to select a Simple List as the data source.

Would it be possible to extend this to allow choosing a Data Query as the source? We have a situation where the user is asked to choose an employee from a dynamic dropdown in the progressive capture, but sometimes this needs to be changed by the analyst if the wrong person was chosen. The problem is analysts sometimes make mistakes when filling in the free text field which then causes problems when we pull through the data into PowerBI to apply row-level security

I've put in a bit of a hack job where they have to supply the person's sAMAccountName and then use an autotask to pull in the full name, team etc. to verify the person exists, but being able to pull from the Hornbill user database would be a lot easier.

Thanks

Met

 

[Jim]

Did anything come of this as this would be really useful?

[samwoo]

+1 as it's not currently possible