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

[paulm1]

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?

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…