# How to get value from data list viewer from spreadsheet

**URL:** <https://community.thunkable.com/t/how-to-get-value-from-data-list-viewer-from-spreadsheet/2654999>\
**Category:** Questions about Thunkable X\
**Tags:** beginner, help\
**Created:** [October 20, 2023, 3:40pm UTC](https://community.thunkable.com/t/how-to-get-value-from-data-list-viewer-from-spreadsheet/2654999 "2023-10-20T15:40:02Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![samyt3475q](https://avatars.discourse-cdn.com/v4/letter/s/bb73d2/32.png) [@samyt3475q](https://community.thunkable.com/u/samyt3475q)\
**Post date:** [October 20, 2023, 3:40pm UTC](https://community.thunkable.com/t/how-to-get-value-from-data-list-viewer-from-spreadsheet/2654999/1 "2023-10-20T15:40:03Z")

</div>

so i have a label and a data viewer list that connected to a spreadsheet, the problem is when i click on the data viewer list, i want the label’s text to change to the selected item text value from the data viewer list items that came from spreadsheet column, what set of blocks i should construct, thank you.

---

<div class="post-metadata">

**Author:** ![matt\_conroy](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/matt_conroy/32/150843_2.png) [@matt\_conroy](https://community.thunkable.com/u/matt_conroy)\
**Post date:** [October 20, 2023, 5:12pm UTC](https://community.thunkable.com/t/how-to-get-value-from-data-list-viewer-from-spreadsheet/2654999/2 "2023-10-20T17:12:27Z")

</div>

Hi @samyt3475q, you want to think about grabbing the data not from the data viewer but from the data source. The item click event in the data list viewer blocks will allow you to click on a row and then you can use that row ID to get the value from the data source itself.  
 ![Screenshot 2023-10-20 at 1.10.51 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/9/c99698dbd53fa1d2029949e49f61d3db9048acf0.png)  
Let me know if this works!

---

<div class="post-metadata">

**Author:** ![samyt3475q](https://avatars.discourse-cdn.com/v4/letter/s/bb73d2/32.png) [@samyt3475q](https://community.thunkable.com/u/samyt3475q)\
**Post date:** [October 22, 2023, 2:47pm UTC](https://community.thunkable.com/t/how-to-get-value-from-data-list-viewer-from-spreadsheet/2654999/3 "2023-10-22T14:47:44Z")

</div>

![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/c/dc94e5166af73a87685d1ba5539e4e41907dc1cd.png)  
Still not working, but i have tried to stored my collumn value in a varible and it does’t work either

---

<div class="post-metadata">

**Author:** ![samyt3475q](https://avatars.discourse-cdn.com/v4/letter/s/bb73d2/32.png) [@samyt3475q](https://community.thunkable.com/u/samyt3475q)\
**Post date:** [October 22, 2023, 3:08pm UTC](https://community.thunkable.com/t/how-to-get-value-from-data-list-viewer-from-spreadsheet/2654999/4 "2023-10-22T15:08:39Z")

</div>

![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/0/6030b7d0ce36d69fbf8642efa366329dd3245f20.png)  
i have made this so far, so when i click the item, the label text disappear, probably it successfully change, but it doesn’t return any text form the variable i made, how can it be?

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [October 22, 2023, 3:30pm UTC](https://community.thunkable.com/t/how-to-get-value-from-data-list-viewer-from-spreadsheet/2654999/5 "2023-10-22T15:30:54Z")

</div>

Why did you not try exactly what @matt_conroy suggested?

The “for row id” value must be a valid row id or an integer. It can’t be anything else. So you can use the green `row id` block there as @matt_conroy showed above.

---

<div class="post-metadata">

**Author:** ![samyt3475q](https://avatars.discourse-cdn.com/v4/letter/s/bb73d2/32.png) [@samyt3475q](https://community.thunkable.com/u/samyt3475q)\
**Post date:** [October 23, 2023, 2:46am UTC](https://community.thunkable.com/t/how-to-get-value-from-data-list-viewer-from-spreadsheet/2654999/6 "2023-10-23T02:46:21Z")

</div>

o yeah, thank you very much sir

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\
**Post date:** [January 21, 2024, 2:46am UTC](https://community.thunkable.com/t/how-to-get-value-from-data-list-viewer-from-spreadsheet/2654999/7 "2024-01-21T02:46:51Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
