{{ param }}
and then in the parameter's settings choose 'Query Based Dropdown List', select the query you want to pull from, and choose to automatically select all values.id
field has been seen before. All you have to do is turn on the toggle that says Deduplicate under your action settings:id
field. A clever way of doing so is by naming whichever column you wish to designate as the identifier as id
in your SQL query e.g.select user_id as id from accounts