Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Using Connectors / Bad Gateway when tryin...
Power Automate - Using Connectors
Answered

Bad Gateway when trying to access sharepoint list using REST API

(1) ShareShare
ReportReport
Posted on by summercoke77 2

i am using Power automate to getting data from sharepoint list without using REST API directly.

 

recently i have a requirement to use REST API to perform aggregate function sum and average the SharePoint list column.

 

Following is the sample flow i did

summercoke77_1-1613727649578.png

 

i used the send an HTTP request to sharepoint in automate instead, see below.

 

summercoke77_0-1613727581646.png

 

but when run process gets stuck in send an http request to SharePoint step.

and following is the error message

summercoke77_2-1613727751463.png

 

i tried to create a new list with simply two column list also same error.

 

I create a simple list in another site also i ran into same error.

 

what do i missed here ?

 

any pointer is  very very much appreciated and many thanks in advance. ...

 

 

Note : the flow will keep running for long time and will required to cancel the running. it just wont timed out or throw a run time error other than the bad gateway message i shown above.

  • bassiekb1983 Profile Picture
    bassiekb1983 2 on at
    Re: Bad Gateway when trying to access sharepoint list using REST API

    In my scenario the BadGateway error message was caused because of a column validation on that list. The value in that column did not meet the column validation, hence the Bad Gateway 502 error. 

     

    bassiekb1983_0-1657568067424.png

     

  • brooksg23 Profile Picture
    brooksg23 2 on at
    Bad Gateway when trying to access sharepoint list using REST API

    @summercoke77 did you figure out what syntax you had incorrect that was invoking the bad gateway error message? I am facing a similar problem. Thanks in advance!

  • Verified answer
    Gopala_Krishna Profile Picture
    Gopala_Krishna 1,491 on at
    Re: Bad Gateway when trying to access sharepoint list using REST API

    @summercoke77 

    This usually happens when there is an error in the query syntax that we are trying to pass, or we have misconfigured the data when passing the query.

     

    I suggest to please check the data present in the action body of the "Send HTTP request to SharePoint" action and check if you have misconfigured or entered an incorrect input.

     

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    if the information shared helps you, please consider giving a thumbs up 👍 and mark solution as resolved

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

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!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans