title: How do I add a dropdown column to my collection in PowerApps?
body: <p>I have a gallery connected to an Excel table. I want to add some of the gallery columns to a collection.
  I am doing-</p>
  <p><code>ClearCollect(Attgallery,ShowColumns(Gallery3.AllItems,&quot;Name&quot;,&quot;Language&quot;,&quot;Mentor&quot;,&quot;Type&quot;,Dropdownatt.Selected.Value));</code></p>
  <p>The last column that I am adding here is a dropdown value which is giving me the error. The dropdown is a new column which was not present in the Excel table. How do I add it to the collection?</p>
  <p>Edit: I tried changing my code.</p>
  <pre><code>ClearCollect(Attgallery,ShowColumns(Gallery3.AllItems,&quot;Name&quot;,&quot;Language&quot;,&quot;Mentor&quot;,&quot;Type&quot;));
  ClearCollect(Finalcollection,AddColumns(Attgallery,&quot;Attendance&quot;,Dropdownatt.Selected));
  </code></pre>
  <p>Now the collection is getting created, but from the dropdown values only the last value that was selected is being assigned to every row of the collection.</p>