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?
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.