# Add an array to a list of arrays

**URL:** <https://connect.superhuman.com/t/add-an-array-to-a-list-of-arrays/13554>\
**Category:** Ask the Community\
**Created:** [January 30, 2020, 11:01pm UTC](https://connect.superhuman.com/t/add-an-array-to-a-list-of-arrays/13554 "2020-01-30T23:01:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Johg\_Ananda](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/johg_ananda/32/13930_2.png) [@Johg\_Ananda](https://connect.superhuman.com/u/Johg_Ananda)\
**Post date:** [January 30, 2020, 11:01pm UTC](https://connect.superhuman.com/t/add-an-array-to-a-list-of-arrays/13554/1 "2020-01-30T23:01:29Z")

</div>

I’m using a button to add an array to a column of arrays. If the row is blank `ModifyRows()` works fine to set the value to the new array.  
 ![Screen Shot 2020-01-30 at 2.53.20 PM](https://global.discourse-cdn.com/coda1/original/2X/7/713e01bad61d94f2ee7ad1217373b7b0063c63e4.png)  
The problem arises if the row already has a value. In the example below, the row value is set to ‘Shannon Drake’:  
 ![Screen Shot 2020-01-30 at 2.54.13 PM](https://global.discourse-cdn.com/coda1/original/2X/d/d639808663e9f8bf42bc1bb2b8483ed64f9c89fa.png)  
I have tried `list()` and `listcombine()` to add my value to the row, each time the existing value gets replaced as what looks like ‘Plain Text’ and loses its blue ‘array’ circle that denotes it’s lookup relationship. In this formula [User Member] is ‘Joseph Winke’ and thisRow.Assign exists as (Shannon Drake).  
` ModifyRows(thisRow, thisRow.Assign,list([User Member],thisRow.Assign)`  
Results in:  
 ![Screen Shot 2020-01-30 at 2.55.35 PM](https://global.discourse-cdn.com/coda1/original/2X/b/ba56e1f8512c292b15c3dc62cbed7a52146009db.png)

---

<div class="post-metadata">

**Author:** ![Federico\_Stefanato](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/federico_stefanato/32/10092_2.png) [@Federico\_Stefanato](https://connect.superhuman.com/u/Federico_Stefanato)\
**Post date:** [February 1, 2020, 1:55pm UTC](https://connect.superhuman.com/t/add-an-array-to-a-list-of-arrays/13554/2 "2020-02-01T13:55:29Z")

</div>

Hi @Johg_Ananda,

Unfortunately, it’s a bit more trickier.  
It took some time to me to figure out how it actually works.  
It’s (again) all about _data types_.  
When you have a **Lookup Column** , you have either a **row** (single select) or **multiple rows** (multi select) references, which is not _exactly_ a `List()` of rows.

Therefore, you need to simulate an actual lookup starting with the Table you are referring.  
Basically, the overall outcome must come out from a filtering, not a composition.

I created a simple example which is perhaps explaining much better. I also added some explicative columns in the target table, so that you can debug and play around yourself.

https://coda.io/embed/LYMVmXL5DK/_su_xK?viewMode=embedplay&hideSections=true

Let me know if I correctly got your point and if it helps.

Very curious to see if somebody else faced this and found a better explanation/solution.  
Cheers!

---

<div class="post-metadata">

**Author:** ![Johg\_Ananda](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/johg_ananda/32/13930_2.png) [@Johg\_Ananda](https://connect.superhuman.com/u/Johg_Ananda)\
**Post date:** [February 1, 2020, 7:24pm UTC](https://connect.superhuman.com/t/add-an-array-to-a-list-of-arrays/13554/3 "2020-02-01T19:24:11Z")

</div>

Thank you so much for helping me with this. Very clever and getting me to think different about my approach. I understand what you mean … I like the idea of `list()` working and I understand it might need to be like this. Thanks! 🙏

---

<div class="post-metadata">

**Author:** ![Federico\_Stefanato](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/federico_stefanato/32/10092_2.png) [@Federico\_Stefanato](https://connect.superhuman.com/u/Federico_Stefanato)\
**Post date:** [February 1, 2020, 7:59pm UTC](https://connect.superhuman.com/t/add-an-array-to-a-list-of-arrays/13554/4 "2020-02-01T19:59:43Z")

</div>

You’re very welcome! 🙂
