I’m moving a client from GoogleSheets to OneDrive/Excel and while testing noticed that when I upload an image, it copies to the directory several times and continues to copy until I reset changes on the application. The issue didn’t happen on GoogleSheets. I checked Audit History based on some notes found here by Adam and found the error below. It mentions “You do not have permission to access one or or tables in the app” yet I was able to access the data and make adjustments etc. Can someone assist?
Looks to me like the app or app user doesn’t have permission to update the Users table, presumably with the name of the uploaded file (and probably other things). Given that you’re seeing multiple copies of the uploaded file, I speculate the app uploads the file before attempting to update the table. The table update fails, but the uploaded file is not removed.
You need to figure out why the app can’t modify the table.
If the app knows in advance the app user doesn’t have access to the table, it should have the opportunity to prevent the file upload. This might be an enhancement request.
Thanks Steve, I see my changes are not being stored. Is there something I’m supposed to do on the excel spreadsheet to provide Appsheet with permission to access the spreadsheet? When selecting OneDrive/Excel as the data source you go through inserting credentials for the Office365 account etc but is something more that’s required?
I’m afraid I have no experience with anything but Google Sheets. Perhaps @Aleksi can chime in?