Hi all
I'm trying to adapt this blog post by Paul Murana (specifically Andy Lawrence's interpretation for Sharepoint) to post multiple rows of data into an Excel Table held in Sharepoint in one go rather than having to do an insane number of iterations for an apply to each. This is the blog: https://www.tachytelic.net/2021/08/power-automate-export-to-excel/
As far as I can tell I have the right inputs for SiteID and FileID but the Sharepoint HTTP request keeps coming back with a "404 - NOT FOUND" error.
This is the request I have:
Hoping someone can point me in the right direction!
Hi All,
Re-upping this thread because I'm stuck in finding a way to add a table row in an excel file using the 'Send an HTTP Request to Sharepoint' action,
I stumbled upon this documentation: Excel Services REST API | Microsoft Learn
Does it means it's no longer possible to add rows using the 'Send an HTTP to SharePoint' action?
Thanks,
Did you figure this out? I'm stuck on the same "404 Not Found"
Thanks @PowerAppsWizard. Unfortunately not that simple. Still getting a 404 error
Hi
I used this method but with onedrive as I had similar issues with using this with sharepoint. In Onedrive is works fine for me.
Are you maybe missing the headers of the http request
Content-Type application/json
?