# Accessing Dataset Tag Value using Power table Cell Update binding **URL:** \ **Category:** General Discussion\ **Created:** [June 17, 2019, 2:42pm UTC](https://forum.inductiveautomation.com/t/accessing-dataset-tag-value-using-power-table-cell-update-binding/25873 "2019-06-17T14:42:10Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![ronyansz](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ronyansz/32/9554_2.png) [@ronyansz](https://forum.inductiveautomation.com/u/ronyansz)\ **Post date:** [June 17, 2019, 2:42pm UTC](https://forum.inductiveautomation.com/t/accessing-dataset-tag-value-using-power-table-cell-update-binding/25873/1 "2019-06-17T14:42:10Z")
I am trying to do power table cell Update binding to values from a Dataset tag. I cant seem to figure out syntax to access the values ![Cell%20update](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/4bca716b2518b4db9478ce00b6c45a8bed7f212e.png) ---
**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:** [June 17, 2019, 3:26pm UTC](https://forum.inductiveautomation.com/t/accessing-dataset-tag-value-using-power-table-cell-update-binding/25873/2 "2019-06-17T15:26:13Z")
You can’t do actual expressions in a cell update binding, only direct references to tags or other component properties. You’ll need to make separate custom properties for the individual dataset values you want to extract, then reference those in the cell update binding. ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [June 17, 2019, 4:36pm UTC](https://forum.inductiveautomation.com/t/accessing-dataset-tag-value-using-power-table-cell-update-binding/25873/3 "2019-06-17T16:36:09Z")
Is this just from a single dataset tag or multiple ones? If a single one, you can take care of everything with the onCellEdited function. Actually, it can be done with multiples, but there’s more work involved. NOTE: The bottom portion of the script is not necessary for performing changes, just to audit what change has been done. ```python # Set dataset tag with new value import system system.tag.write('[default]path/to/dataset/tag', system.dataset.setValue(self.data, rowIndex, colIndex, newValue)) # Add to Audit Log. The audit log can tell that a change has happened to a dataset, # but not what specific change. event_timestamp = system.date.now() actor = system.tag.read('[System]Client/User/Username').value actor_host = system.tag.read('[System]Client/Network/Hostname').value action = 'schedule change' action_target = str(self.data.getValueAt(rowIndex,0)) + ':' + str(colName) action_value = str(newValue) status_code = 0 args = (event_timestamp, actor, actor_host, action, action_target, action_value, status_code) query = 'INSERT INTO audit_events ("EVENT_TIMESTAMP", "ACTOR", "ACTOR_HOST", "ACTION", "ACTION_TARGET", "ACTION_VALUE", "STATUS_CODE") VALUES (?,?,?,?,?,?,?)' system.db.runPrepUpdate(query, args, 'Audit') ``` ---
**Author:** ![ronyansz](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ronyansz/32/9554_2.png) [@ronyansz](https://forum.inductiveautomation.com/u/ronyansz)\ **Post date:** [June 17, 2019, 6:34pm UTC](https://forum.inductiveautomation.com/t/accessing-dataset-tag-value-using-power-table-cell-update-binding/25873/4 "2019-06-17T18:34:10Z")
in ignition 7.9, I would just write {ticketDetails}[0,12] and it would work just fine. Cant seem to work in Version 8 ---
**Author:** ![ronyansz](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ronyansz/32/9554_2.png) [@ronyansz](https://forum.inductiveautomation.com/u/ronyansz)\ **Post date:** [June 17, 2019, 7:02pm UTC](https://forum.inductiveautomation.com/t/accessing-dataset-tag-value-using-power-table-cell-update-binding/25873/5 "2019-06-17T19:02:02Z")
i have managed to solve this using component scripting, extension functions; Configure Cell ![Configure%20%20cell](https://us1.discourse-cdn.com/inductiveautomation/original/2X/3/35e4ca0d3608c0226c6c090fb595d882229a6056.png) ---
**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:** [June 17, 2019, 7:20pm UTC](https://forum.inductiveautomation.com/t/accessing-dataset-tag-value-using-power-table-cell-update-binding/25873/6 "2019-06-17T19:20:01Z")
I wanted to double check, but I don’t see any regression here - as expected, a `{dataset}[row, col]` reference doesn’t work _in a cell update binding_ in 7.9 any more than it does in 8.0. `{dataset}[row, col]` **is** how you reference a specific cell out of a dataset in a standard expression context (eg, expression tag, or a standard expression binding), but cell update bindings have not (and will not, for technical reasons) ever supported full expression evaluation. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/3/3c7dcbe34b5543db78d4718dfaca0fb7470cf70a.png) ---
**Author:** ![ronyansz](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ronyansz/32/9554_2.png) [@ronyansz](https://forum.inductiveautomation.com/u/ronyansz)\ **Post date:** [June 17, 2019, 8:07pm UTC](https://forum.inductiveautomation.com/t/accessing-dataset-tag-value-using-power-table-cell-update-binding/25873/7 "2019-06-17T20:07:13Z")
first check with {dataset[row,col]} in 7.9