Skip to main content
Community site session details

Community site session details

Session Id : TN393Z9UOrHL1BGKxUuf9n
Power Automate - Using Connectors
Unanswered

Add Row to Excel Table Using Sharepoint HTTP Request

Like (0) ShareShare
ReportReport
Posted on 12 Mar 2022 21:59:01 by

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:

Flow.png

Hoping someone can point me in the right direction!

  • NaufalP Profile Picture
    75 on 31 Aug 2023 at 03:50:45
    Re: Add Row to Excel Table Using Sharepoint HTTP Request

    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 

     

    NaufalWahika_0-1693453809637.png

     

    Does it means it's no longer possible to add rows using the 'Send an HTTP to SharePoint' action?

     

    Thanks,

  • meyer Profile Picture
    10 on 03 Jul 2022 at 06:56:53
    Re: Add Row to Excel Table Using Sharepoint HTTP Request

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

  • Community Power Platform Member Profile Picture
    on 13 Mar 2022 at 22:54:27
    Re: Add Row to Excel Table Using Sharepoint HTTP Request

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

  • PowerAppsWizard Profile Picture
    388 on 13 Mar 2022 at 21:26:04
    Re: Add Row to Excel Table Using Sharepoint HTTP Request

    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

    PowerAppsWizard_0-1647206709913.png

    ?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Featured topics

Loading complete