Unanswered

Add Row to Excel Table Using Sharepoint HTTP Request

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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!

Categories:

Using connectors

I have the same question (0)

All responses (4)

Answers (0)

PowerAppsWizard 388 on at

Like (0)

Report
Copy link

Link copied!

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
?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks @PowerAppsWizard. Unfortunately not that simple. Still getting a 404 error

Was this reply helpful? Yes No
meyer 10 on at

Like (0)

Report
Copy link

Link copied!

Did you figure this out? I'm stuck on the same "404 Not Found"

Was this reply helpful? Yes No
NaufalP 75 on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No