I’m working on a Data App where I need the user to select a file from a remote SFTP server. I can retrieve the list of files and store it in a list or database table. Is there a way to configure an input field in the Data App to display those entries and allow the user to select one?
Yes, this is supported using the “Dynamic Values” option for input parameters in your Data App.
With this approach, one data service can dynamically generate a list of values — for example, scanning a database or file system — and pass those values to the input of the other data service. This allows the input field to present a dropdown or selection list populated in real-time based on the current data.
In your case, you can have a data service that queries the SFTP server (or a related database table) for available files, and the user can then select one of those files directly in the Data App.
We’ve included a sandbox example to demonstrate this setup:
- Be sure to publish both data services
- Enable the Data App for
mainExample, which illustrates this dynamic behavior
DataAppExample.zip (75.4 KB)
For more information on dynamic values in Data Services, see Endpoint configuration.