title: PowerApp Distinct function with DropDown variable
body: <p>I am trying to create dependent (linked) dropdowns in my PowerApps. Specifically, I want to select the distinct values of a column selected from a drop-down (see below, where the first dropdown contains the column, and the second should contain the distinct values of that column:</p>
  <p><a href="https://i.stack.imgur.com/CqT4G.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CqT4G.png" alt="The first dropdown contains the column, and the second should contain the distinct values of that column" /></a></p>
  <p>I want to have the distinct values of the column selected in the first dropdown.</p>
  <p>I tried to use this function for the second dropdown:</p>
  <pre><code>Distinct('SQLTableName', dropdown_1.SelectedText.Value)
  </code></pre>
  <p>But it does only generate the selected value itself, instead of a list of distincts, as seen below:</p>
  <p><a href="https://i.stack.imgur.com/JTw3L.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JTw3L.png" alt="the result of first function" /></a></p>