Can anyone tell me why this started happening? I’ve never had any problems like this but now my added or deleted (or edited) rows keep changing back to previous state?
Just started making new app, not a single automation and this is the first view I made. I’m having the same problem with my other app as well. Is it because my use of MS login account and that for some reason it doesn’t update correctly?
Added video to check.
Edit: Just checked adding a row, it disappears on screen but when I open the data source, the new row is added. Added another row and it disappears but it is added on excel. After refreshing the screen couple of times, they appear back on screen.
Just checked adding a row, it disappears on screen but when I open the data source, the new row is added. Added another row and it disappears but it is added on excel. After refreshing the screen couple of times, they appear back on screen.
Please post screenshot–not video–of the column list for the table so that we can see the column names, types, and which column is key. Please also post a screenshot of the spreadsheet.
Note that Excel is not the best data source. There can be issues if someone else has the Excel sheet open when the app is trying to use it.
Actually the reason is the business office365 login. What happens is, if the excel file has several sheets, the sync only works correctly in first sheet. Extra sheets do exactly what’s mentioned.
I copied the app to my personal MS account, which uses https://onedrive as datasource and everything works correctly. Business account uses https://mybusinessname.sharepoint as datasource and this seems to be the problem.
So what happens is if I make a file with more than one sheet, and even with three columns in each sheet, first sheet syncs correctly when adding or editing rows. On the second sheet and following, the edits or adding/deleting rows affects to excel file correctly, but on screen values and rows revert back to previous state. Only refreshing browser updates the screen to correct. Syncing the app usually don’t work, need to refresh the browser.
This has been now tested with my Gmail, personal live and business 365 accounts with the help of two different support representatives and they both noticed the same problem. Basic app works correctly other accounts but when copied to business, the problem occurs. Solution for this is to separate the sheets to their own spreadsheet files, and then they work perfectly.
Support couldn’t help me on this case other than they witnessed the problem occurring.