# Power table and Cell Update binding

**URL:** <https://forum.inductiveautomation.com/t/power-table-and-cell-update-binding/86344>\
**Category:** Ignition\
**Tags:** ignition81, vision\
**Created:** [February 26, 2024, 8:14am UTC](https://forum.inductiveautomation.com/t/power-table-and-cell-update-binding/86344 "2024-02-26T08:14:14Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Aiasa21](https://avatars.discourse-cdn.com/v4/letter/a/aeb1de/32.png) [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\
**Post date:** [February 26, 2024, 8:14am UTC](https://forum.inductiveautomation.com/t/power-table-and-cell-update-binding/86344/1 "2024-02-26T08:14:15Z")

</div>

Good morning, I'm using the Cell Update binding in a Power Table and at the moment I set the Row index statically.

I would like to be able to modify the index in some way, maybe with a column value of that specific row, but I don't understand how to do.

I tried to do as explained in the Cell Update view ( "Rows can be specified explicitly by their index or by referencing another column (e.g. "Name=Compressor") but I don't understand how to do it.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/e/2ee925c98820d5a14487795af94579c54e97ade7.png)

If I try in this way I have this error  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/a/dad7e7c8699060241bfef616e59b7fbd40c00dfc.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [February 26, 2024, 12:34pm UTC](https://forum.inductiveautomation.com/t/power-table-and-cell-update-binding/86344/2 "2024-02-26T12:34:41Z")

</div>

Your screenshot shows two of each row/column combination.

---

<div class="post-metadata">

**Author:** ![Aiasa21](https://avatars.discourse-cdn.com/v4/letter/a/aeb1de/32.png) [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\
**Post date:** [February 26, 2024, 1:03pm UTC](https://forum.inductiveautomation.com/t/power-table-and-cell-update-binding/86344/3 "2024-02-26T13:03:43Z")

</div>

My goal is to be able to change the order of the rows dynamically. I mean, normally if I have to make the power table works I set it in this way

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/1/a1b850b7dc6710700ae83de61b740861509cb1ac.png)

But if I want to change the order of the rows I should change the 0 with the 1 in the first 3 rows and the 1 with the 0 in the last rows. If I have maybe 20 rows and 10 columns and I have to insert one in the 7th rows it's a problem.

So I would like to understand how to do this in a faster way. Actually I don't understand how to put into pratice the example here, that should be what potentially I need

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/6/96fb28648bd92d73b2f17932a9c97bec832eff40.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [February 26, 2024, 1:08pm UTC](https://forum.inductiveautomation.com/t/power-table-and-cell-update-binding/86344/4 "2024-02-26T13:08:22Z")

</div>

The cell update binding cannot handle a variable number of operations. You need to generate your entire dataset with a script. Or, perhaps, with the expression functions in my Integration Toolkit module.

Please provide more information on where the `value` for each cell comes from.

---

<div class="post-metadata">

**Author:** ![Aiasa21](https://avatars.discourse-cdn.com/v4/letter/a/aeb1de/32.png) [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\
**Post date:** [February 26, 2024, 1:23pm UTC](https://forum.inductiveautomation.com/t/power-table-and-cell-update-binding/86344/5 "2024-02-26T13:23:10Z")

</div>

> [@pturmel](#):
>
> `value` for each cell comes from.

Thanks for the reply, I simply create custom properties and I use the "Insert property value" button to bind them.

For example in this case the power table is called Power Table\_PLC

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

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [February 26, 2024, 1:26pm UTC](https://forum.inductiveautomation.com/t/power-table-and-cell-update-binding/86344/6 "2024-02-26T13:26:09Z")

</div>

Sounds like a fixed list of rows with a fixed order. What else are you trying to do?

---

<div class="post-metadata">

**Author:** ![Aiasa21](https://avatars.discourse-cdn.com/v4/letter/a/aeb1de/32.png) [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\
**Post date:** [February 26, 2024, 1:31pm UTC](https://forum.inductiveautomation.com/t/power-table-and-cell-update-binding/86344/7 "2024-02-26T13:31:19Z")

</div>

Yes you're right, but for example if one day I will have to insert another PLC in the row [1], I should change the actually [1] to [2] and the insert the new row; and of course if I wll have other 10 rows after that I should increment by one all that rows.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [February 26, 2024, 1:37pm UTC](https://forum.inductiveautomation.com/t/power-table-and-cell-update-binding/86344/8 "2024-02-26T13:37:25Z")

</div>

If you expect the list to change, and don't want to manually fix the binding every time, perhaps you should be using the output of the [system.devices.listDevices()](https://www.docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-device/system-device-listDevices) function.

---

<div class="post-metadata">

**Author:** ![Aiasa21](https://avatars.discourse-cdn.com/v4/letter/a/aeb1de/32.png) [@Aiasa21](https://forum.inductiveautomation.com/u/Aiasa21)\
**Post date:** [February 26, 2024, 2:01pm UTC](https://forum.inductiveautomation.com/t/power-table-and-cell-update-binding/86344/9 "2024-02-26T14:01:29Z")

</div>

Actually I have a script to ping the devices because we use Kepserver.

Anyway thanks for the help!
