When patching rows in a site's file, if a column is being filled with an Excel formula, the value of such column for the last row will be applied to all the others

Question

I'm trying to patch some rows in a range in an Excel file contained in a Sharepoint site.

This is the URL:

PATCH https://graph.microsoft.com/v1.0/sites/{site id}/drive/items/{workbook id}/workbook/worksheets/{worksheet id}/range(address='Users!P3:Y12')

And this is the payload:

{
   "values": [["38", "62172", "", "", "en_GB", "", "2024-08-15 12:49", "2025-06-11 12:49", "=HYPERLINK(\"https://address.com/sync=read&target=plans&filter=subscription&value='38'\", \"Plans\")", "=HYPERLINK(\"https://address.com/?sync=read&target=RSassignations&filter=subscription&value=38\", \"RSassignations\")"],["39", "62172", "", "", "en_GB", "", "2024-08-15 12:52", "2025-06-11 12:52", "=HYPERLINK(\"https://address.com/?sync=read&target=plans&filter=subscription&value='39'\", \"Plans\")", "=HYPERLINK(\"address.com/?sync=read&target=RSassignations&filter=subscription&value=39\", \"RSassignations\")"],["40", "62172", "", "", "en_GB", "", "2024-08-15 12:53", "2025-06-11 12:53", "=HYPERLINK(\"address.com/?sync=read&target=plans&filter=subscription&value='40'\", \"Plans\")", "=HYPERLINK(\"https://address.com/?sync=read&target=RSassignations&filter=subscription&yesvalue=40\", \"RSassignations\")"]]
}

You can see that the value of the "id" parameter in the URLs in the last columns of every subarray is different, but this is the output and — in fact — what gets printed in the file:

So the formulas of the last row overwrites the previous one, but it doesn't happen for the other columns.

---

I tried looking for hints in the response, but the only interesting bit that I found is the part about the value types: it seems that for the last two columns, which are filled with Excel formulas, the header of the colum is written instead:

Answer 1

What do I have to do to keep this thread high in the feed? I understand that we are not paying for full support, but our plan says we have right to use the community support and it seems that our thread will just be forgotten in the enormous mass of other threads added everyday.