# Power Table Cell Dropdown

**URL:** <https://forum.inductiveautomation.com/t/power-table-cell-dropdown/22892>\
**Category:** Ignition\
**Tags:** scripting\
**Created:** [February 26, 2019, 8:21pm UTC](https://forum.inductiveautomation.com/t/power-table-cell-dropdown/22892 "2019-02-26T20:21:06Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Phil\_B](https://avatars.discourse-cdn.com/v4/letter/p/c89c15/32.png) [@Phil\_B](https://forum.inductiveautomation.com/u/Phil_B)\
**Post date:** [February 26, 2019, 8:21pm UTC](https://forum.inductiveautomation.com/t/power-table-cell-dropdown/22892/1 "2019-02-26T20:21:06Z")

</div>

Hello All,

I am trying to make a power table with a drop down for entries of a certain column.

On the configureEditor extension function i have out the following:

```auto
	if colName == 'name':
		lineName = self.LineName
		tagPath = lineName + "/" + lineName + "/Cells"
		cells = system.tag.read(tagPath).value
		cellList = []
		for row in range(cells.rowCount):
			cellName = cells.getValueAt(row,"Cell")
			cellList.append(tuple([row,cellName]))
			
		return {'options': cellList}

```

This gives me my desired options in drop down form but the value of the table doesn’t change when i select a new value from the drop down. I made sure that i made the column editable in the table configurations but it doesn’t work. any suggestions?

---

<div class="post-metadata">

**Author:** ![Paul.Scott](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul.scott/32/4578_2.png) [@Paul.Scott](https://forum.inductiveautomation.com/u/Paul.Scott)\
**Post date:** [February 26, 2019, 8:36pm UTC](https://forum.inductiveautomation.com/t/power-table-cell-dropdown/22892/2 "2019-02-26T20:36:58Z")

</div>

Have you enabled the `onCellEdited` Extension Function? The `configureEditor` Extension Function only modifies how you edit cells, you would need `onCellEdited` to actually apply the new value from the dropdown.

---

<div class="post-metadata">

**Author:** ![Phil\_B](https://avatars.discourse-cdn.com/v4/letter/p/c89c15/32.png) [@Phil\_B](https://forum.inductiveautomation.com/u/Phil_B)\
**Post date:** [February 26, 2019, 8:39pm UTC](https://forum.inductiveautomation.com/t/power-table-cell-dropdown/22892/3 "2019-02-26T20:39:51Z")

</div>

Perfect. Turned that on and uncommentated the example at it works. Thank you for the quick reply.

---

<div class="post-metadata">

**Author:** ![ybfautom](https://avatars.discourse-cdn.com/v4/letter/y/eada6e/32.png) [@ybfautom](https://forum.inductiveautomation.com/u/ybfautom)\
**Post date:** [October 25, 2019, 7:24pm UTC](https://forum.inductiveautomation.com/t/power-table-cell-dropdown/22892/4 "2019-10-25T19:24:24Z")

</div>

I have a Power Table populated with a manually created dataset. A cell dropdown function is in place by means of configureEditor extension. Using a great example posted by PGriffith at: [Force configure cell update in power table](http://forum.inductiveautomation.com/t/force-configure-cell-update-in-power-table/16318/6)

My problem is drop down function stops working when trying to populate Power Table from a DB source.  
I tried using property bindings from different sql queries without succes.  
Any hint?

---

<div class="post-metadata">

**Author:** ![paulm1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paulm1/32/5900_2.png) [@paulm1](https://forum.inductiveautomation.com/u/paulm1)\
**Post date:** [January 22, 2020, 2:08am UTC](https://forum.inductiveautomation.com/t/power-table-cell-dropdown/22892/5 "2020-01-22T02:08:04Z")

</div>

Check out the following topic.  
If you scroll down to the solution you will see two examples of Cell Dropdowns.  
The second example sounds like what you are looking for.  
Good Luck.

> [@How to query Database Table to populate Power Table Drop Down List within cell](http://forum.inductiveautomation.com/t/how-to-query-database-table-to-populate-power-table-drop-down-list-within-cell/27614):
>
> I have used the extension function configureEditor to script defined drop down boxes within Power Tables before. Now I would appreciate some help using a database table query to populate the drop down cell. I have read most of the related forum articles but I am still struggling. I am a rookie so I could really use some very specific scripting help. My database table I want to query titled shift. The column i would like the query drop down to be in is labeled name. Believe me when I say yo…