
Announcements
One of the data sources for my Canvas App is an Excel Online Sheet which contains a table. Some of the columns in the table have a data validation applied to show a list of values.
In my App I have added the Form and have connected the excel data source to show some of the columns as DataCards etc...
The issue I have is the Lists from the excel data validation. do not show in the respective fields. How can i change the DataCardValue to show a drop down list of the choices from that column in the excel file?
The purpose of the app is for user to fill out the fields by either typing it in the text box or choose from a list of values for some of the fields. Then submit to save back to the excel online table.