# Vision power table

**URL:** <https://forum.inductiveautomation.com/t/vision-power-table/65267>\
**Category:** Ignition\
**Tags:** ignition80, vision\
**Created:** [October 17, 2022, 5:15am UTC](https://forum.inductiveautomation.com/t/vision-power-table/65267 "2022-10-17T05:15:52Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [October 17, 2022, 5:59am UTC](https://forum.inductiveautomation.com/t/vision-power-table/65267/2 "2022-10-17T05:59:14Z")

</div>

For the query that populates the table, simply add a blank column using `null as` or `'' as` in your SELECT statement.  
MySQL Example:  
`SELECT `ID`, '' as `DropDown` from some_Schema.some_Table`

Then, populate your blank drop down column using a select statement in the configureEditor extension function.  
Here is an example:

> [@How to query Database Table to populate Power Table Drop Down List within cell](https://forum.inductiveautomation.com/t/how-to-query-database-table-to-populate-power-table-drop-down-list-within-cell/27614/6):
>
> This article helped us accomplish our goal using Power Table Cell drop Down List.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/d/7d7d5e7da925f3a32a28d311e3efd0b62b8c3f0b.png)

---

_[View the full topic](https://forum.inductiveautomation.com/t/vision-power-table/65267)._