Set (listpicker) selectionindex to (number value)

General Discussion
1

Hello,

I have a list based on a google sheet file with a list of names and some information in following collums.

I have a listpicker that asks you to pick a name

In a textbox I display the index(position number) of the selected name in the list.

So if you pick the 3 name in the row the index would be 3

The information in the collums behind the name changes so when I initialize the screen I Call Web and do the whole refresh data from sheet thing (works fine)

I dont want the user to reselect an item from the list I just want to pick the same name again with the refreshed information.
So 3 could be
Bob,1,2,3,4
And after the refresh it could be
Bob,5,6,7,8
so the exact information is not the same but the index number and the name in the list is the same

I thought about using the: Set LISTPICKER selectionindex to block but it doesnt really do what I was expecting.

blocks (1)
blocks (1)1038×284 35 KB

Clubindex.Text = 3

After the force selection it needs to start the .AfterPicking blocks

Any help is welcome.
Seen hours of tutorials and spend quite some time browsing the forum to get the app to work as it does but this is a bit that I cant seem to figure out or find.

2

get the data from the underlying list once it has updated - select item from list / index

3

If you want to update Bob's row in the Google Sheet you can use the spreadsheet component get filtered requests on 'Bob' to get the Bob data and its row number, for use later in a direct update request