I’ve just checked my emails and the security notification from Microsoft came on my second account. Which is kind of strange, as I’ve been logged in with my main in my browser.
So that could be the issue, I’ll take a look this evening and give an update - hopefully it just connected the wrong account
thanks for your answer. I unfortunately couldn’t get it to work - could it be that your suggestion is for connecting Google services? As I can’t find anything like that on Azure.
ah… you have an Azure node. I thought it was a google spreadsheet.
Were you able to access the Workbook by its ID? If you can access it, then you didn’t have enough permissions to list resources. Otherwise, it may be another issue with permissions (like the account you are connecting from doesn’t have access to the spreadsheet)
Yeah it’s the Excel365 node. Accessing it by its ID isn’t really working, as I’m trying to append rows to my table for which I’d also need the ID of each column.
I gave my app the Files.ReadWrite permission scope as written in the docs:
Could this be the source of the issue? (I am having the same problem and noticed my work access works fine but not personal — both using Azure)
Note : Support for workbooks stored in OneDrive Consumer platform is still not available. At this time, only the files stored in business platform are supported by Excel REST APIs.