app-inventorlistpicker

App Inventor - How to fill listpicker element with Google Spreadsheet query


I'm trying to query a Google Spreadsheet with its API and fill the results into listpicker elements. Unfortunately I do not get any result and no error message. It just happens nothing.

When I call the notifier with the result it is showing the right ones and also when I use the spreadsheets API directly through the browser I see the right results. But in App Inventor it is not filling the Listpicker Elements. I hope you can help me.

Here is an Image of my App Inventor Blocks enter image description here

Thanks a lot for your help in advance


Solution

  • Remove the red warning in the Web.GotText event, else that block will not fire!
    And check, if the URL is correct, see also my example here.

    Also you are selecting 1 column, which means, you get back a 1 column csv table as result... which means, you should use the split block and split at \n (new line) to convert the result into a list instead of using the list from csv row block...

    enter image description here