That's a great start. My screen is developed enough that it is too proprietary to post on a public board. It's pretty straightforward, though. My OneDrive Excel doc has columns for all the controls on the screen that need to be populated. I haven't gotten Static Excel to work very well. It doesn't recognize column names. The OndDrive option should work ok, though, for now. I'd be interested in reading about the comparisons of reading Excel from OneDrive vs the Excel data sources.
Filter/Lookup are features that I definitely want to start using, but for now, I'm just wanting to access the rows sequentially.
I'm thinking that the way to do this would be to. Here are my expected steps:
- (DONE) in View Data Sources, I clicked Add Data Source and selected the file and table.
- Change controls to pull data from the collection loaded in step 1.
- I expect I should set up a lookup command such as clearload on the Apps "On Load" property (I was thinking to use the screen's "on start" property, which doesn't exist, and use NEXT buttons to advance the selected row (example: on click add one to selected row, or something like that). I haven't found ways of doing any of this.
Most of the articles I have read assume you are going to identify your data connections when first building the screen. I recognize the advantages of that, but if I am doing incremental builds, I need to be able to add things later. I would think you could still get to those same connection dialogs later, like if you want to add another data source.
I assume that, in the future, I should use Forms form the start. I don't see any hints on moving my already-developed screen controls onto a form.
