
Instructions on how to approve AppSheet in your Office 365 settings are available here. In order to connect an Office 365 data source to AppSheet, an admin managing your organization's Office 365 account may be required to approve AppSheet as a OAuth app. Additionally, if a SharePoint site has been migrated to an on-premises server, it will no longer be accessible to AppSheet. In most cases, if you create a file or folder directly in a SharePoint site, the file/folder will automatically be created in the default drive of the site for you. Contents that are stored in user-created drives are currently not accessible. If using SharePoint, please note that AppSheet can only access files and folders that are stored in the default drive of a SharePoint site or sub-site.

Otherwise, you'll see conflict ("409") error messages and the app won't be able to save changes to the spreadsheet. Consequently, if you intend to build an app that updates the data (as most apps do!), please make sure to close the spreadsheet first. With Office 365, if a user has the spreadsheet open for editing, other users and third-party apps like AppSheet can't make updates to the spreadsheet.


While this process is mostly seamless, there are some specific behaviors of which you should be aware.
