Hello I have an app that is connect to different excel datasources. the app allows the user to choose a client from a dropdown. each client has its own datasource (excel) which is uploaded and connected to the app. The client name matches the name of the datasource associated with that client. Currently when I call the value selected from the dropdown menu (clientlist.selected) to a variable, it has a type of record, or if I use (clientlist.slected.Result) it's stored as text. The problem is I cannot use that to call a datasource. is there a way to convert that variable to a datasource type so I can show the chosen client information without having to make a different screen for each client. I have too many clients to do that.

Report
All responses (
Answers (