# How to query Database Table to populate Power Table Drop Down List within cell

**URL:** <https://forum.inductiveautomation.com/t/how-to-query-database-table-to-populate-power-table-drop-down-list-within-cell/27614>\
**Category:** Ignition\
**Tags:** database, ignition79, scripting\
**Created:** [August 20, 2019, 11:25pm UTC](https://forum.inductiveautomation.com/t/how-to-query-database-table-to-populate-power-table-drop-down-list-within-cell/27614 "2019-08-20T23:25:38Z")\
**Posts on this page:** 1\
**Showing post:** 6

<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:** [August 28, 2019, 8:28pm UTC](https://forum.inductiveautomation.com/t/how-to-query-database-table-to-populate-power-table-drop-down-list-within-cell/27614/6 "2019-08-28T20:28:45Z")

</div>

This article helped us accomplish our goal using Power Table Cell drop Down List.

> [@Power Table Drop Down List with ability to enter new text?](http://forum.inductiveautomation.com/t/power-table-drop-down-list-with-ability-to-enter-new-text/12876):
>
> Using Ignition 7.9.0 on windows 7 x64 I have a power table that has a vendor column. What I’d like to do is give an authorized user the option of selecting from a list of existing vendors or just enter in their own. Right now, under the confgureEditor extension Functions I have the following code: [code] if colName == ‘vendor’: # Create a list of Areas and Bays via SQL Query query = “SELECT DISTINCT vendor FROM assets” vlist = system.db.runPrepQuery(query) #move the data into a python l…

 ![Power%20Table%20Drop%20Down%20List%20configureEditor%20Script](https://us1.discourse-cdn.com/inductiveautomation/original/2X/6/67a4c564e57386c7590d6ecc0fbd28aa060037b5.png)

---

_[View the full topic](https://forum.inductiveautomation.com/t/how-to-query-database-table-to-populate-power-table-drop-down-list-within-cell/27614)._