Error with google sheets

MIT App Inventor Help
1

hello

I have an application that brings information from google sheets, while there is information it works fine but when it finds an empty cell it gives an error.

image
image1211×682 60.4 KB

I have tried this other one, it does not give error but it always says “no hay datos” and when there is data it also says “no hay datos”.

image
image1212×726 67.5 KB

can you help me?

2

Obviously SN.Text is always empty

Screenshot_20241204_122411_DuckDuckGo
Screenshot_20241204_122411_DuckDuckGo829×129 41.3 KB

Taifun

3

How can I solve it ?

4

Set SN.Text to something as you are doing it in your first screenshot

Taifun