Is it possible to have a button change the select list?

If I understand correctly, you want to change the Current Selected Option of a Select list column by using a button (?), if thatโ€™s it, you might wanna try something like this :slight_smile:

ModifyRows([Books ๐Ÿ“š].Filter(Title=thisRow.[Books ๐Ÿ“š].Title AND Status="Reading ๐Ÿ“–"),Status,"Completed ๐Ÿ“š"))

(It comes from my reading tracker where Status is my select list column)

In this formula :

  • [Books ๐Ÿ“š] is the table where the select list you want to modify is
  • The first part of the Filter() : Title=thisRow.[Books ๐Ÿ“š].Title is just a filter for selecting the right row in the table where the select needs to be changed (You can add as many filters you need)
  • The second part of the Filter() : AND Status="Reading ๐Ÿ“–" was to get the โ€œcurrent selected optionโ€ in the select list and needed to be changed
  • The last part of the formula just says what column needs to be โ€œupdatedโ€ by ModifyRows() and by what it should be updated.

But, thereโ€™s a con doing this in this way, if later, you decide to change the Selectable Options in your select list, youโ€™ll need to change it in your formula too, especially the โ€œcurrent statusโ€ part : Status="Reading ๐Ÿ“–"

I hope this is what you were looking for :sweat_smile: