In the list below items 12 and 13, could change to 11 and 12 because sometimes some data before item 12 could be missing. The blocks (1) that work are too lengthy, blocks (2) are simpler, specially if I want to apply them to all the items, but these don’t work. Any ideas? Tks. [the LIST] [works…

Thank you for these references. I tried the dictionary lookup as you suggested and it worked perfectly. As you mentioned, this is better than relying on indices. (As in the case that I doing - extracting data from APIs - the indices are fixed most of the time, but occasionally they are not). THANK…

To extract a list item when the item INDEX may vary

MIT App Inventor Help

ABG August 4, 2020, 2:53am 4

This looks like JSON data, which does not fit well into spreadsheets.
Here are some JSON samples:

1 Like