Query Based Dropdown List - choose value column in query


#1

Let’s say I have a Query Based Dropdown List which maps user names to the user ids, but one of my queries on the dashboard gets user data from another datasource and in the table the id isn’t saved but only the name. Is it possible for this query to get the name from the Query Based Dropdown List instead of the id, but all other queries get the id?
So I don’t need two different Dropdown Lists with the same usernames in it?