


When this button is selected, it sets a variable that switches the form to edit mode otherwise, the form is set as new mode (from what I can gather, this is a relatively standard practice). I have a button in the gallery that sits beside the data entry, that provides the user an option to edit the record that is horizontal to the line item within the gallery. This too, is successfully displaying the data connected via the Excel Online spreadsheet (including new entries made via the app that have been submitted from the form). On a separate screen, I have a gallery that is also connected to the data source. I am able to successfully submit from this form to the spreadsheet with no issues whatsoever. I have a form within my app that is connected to an Excel Online spreadsheet.

I'm unable to share screenshots of my application due to the data sensitivity, so I'll do my best to provide an overview of my setup, and a description on what I am hoping to achieve.
