How to change the data source of data viewer list by blocks?

I have a product list in google sheet. The user has two language options. I want to change the product name to the user selected language. I have put the names of the products (In both languages) in different columns (In the same row). How can I change it (actually get it from another column) by blocks?

1 Like

The Data Viewer is a design time component when it comes to connections which means there isn’t any available option to change the source at run time.

Having said that, I would create TWO Data Viewers one for each option. Once the use selects the other option, I will hide the default one and show the other which should give the desired outcome.

2 Likes

Thank you