# Power table dropdown list

**URL:** <https://forum.inductiveautomation.com/t/power-table-dropdown-list/28077>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [September 6, 2019, 2:55pm UTC](https://forum.inductiveautomation.com/t/power-table-dropdown-list/28077 "2019-09-06T14:55:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![roinisan](https://avatars.discourse-cdn.com/v4/letter/r/65b543/32.png) [@roinisan](https://forum.inductiveautomation.com/u/roinisan)\
**Post date:** [September 6, 2019, 2:55pm UTC](https://forum.inductiveautomation.com/t/power-table-dropdown-list/28077/1 "2019-09-06T14:55:36Z")

</div>

Hello,  
I started using power table recently, and I want that when clicking on a specific column  
a dropdown list will be shown, I saw that this could be accomplished by the  
“configureEditor” function, but when I do that no dropdown option is being shown,  
here is my code:  
"  
if colName == ‘CompanyName’ :  
drop\_down\_list =   
companies = system.db.runPrepQuery(“SELECT CompanyName from Companies”,)  
for company\_index in range(companies.getRowCount):  
key\_value\_tuple = (company\_index,companies.getValueAt(company\_index,“CompanyName”))  
drop\_down\_list.append(key\_value\_tuple)  
system.db.refresh(self, “data”)  
return {‘options’: drop\_down\_list}  
"  
I also tried the default example:

"   
if colName == ‘Mail’:  
return {‘options’: [(0, ‘A Shift’), (1, ‘B Shift’), (2, ‘C Shift’)]}  
"

but it didn’t work either.  
could anyone help please

 ![Capture](https://us1.discourse-cdn.com/inductiveautomation/original/2X/3/30b352a8390a0e13c62672cccf99a2ce9e5b16f3.png)

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [September 6, 2019, 3:37pm UTC](https://forum.inductiveautomation.com/t/power-table-dropdown-list/28077/2 "2019-09-06T15:37:41Z")

</div>

Is the column editable? Make sure you’ve overriden the ‘isCellEditable’ function, and that the column is marked ‘Editable’ in the table customizer/column attributes dataset.
