14-05-24 06:49 AM
a week ago
I read the IDs via the Graph API. To make sure that I don’t have the same Excel anywhere else, I created a new Excel with different data in a different folder. That is, this time I read data from Sheet2 (Tabelle2) and write data to Sheet1 (Tabelle1). The IDs must be correct, otherwise the Get Worksheet as Collection would not work. But Sheet1 remains empty.
What else I noticed is that I receive the following error message
when writing collection, if the collection contains numbers, even though the collection is formatted as text:
When the collection has just text (in RowA) there is no error message.
a week ago
@ewilson In the meantime I was able to test the request URL with Postman (Sharepoint Graph Exlorer is unfortunately not allowed in our company). I had the same problem. This means that the problem is on our (Sharepoint) side and we have to keep looking at ourselves.
Thank you for your support so far!