cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
summercoke77
Regular Visitor

Bad Gateway when trying to access sharepoint list using REST API

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Gopala_Krishna
Super User
Super User

@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

View solution in original post

1 REPLY 1
Gopala_Krishna
Super User
Super User

@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

View solution in original post

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (30,719)