Dropdown list from a Google Sheet

The community member is trying to set up a dropdown of classes stored in a Google Sheet to register students linked to a specific class. They encountered an issue where the data stored in the column they tried to extract was not showing up. A community member suggested setting the appropriate column to extract into a variable, and then using this variable in a Buttons input with the Dynamic items property, which they said is a better experience than a dropdown. The community member confirmed that this solution worked for them.