Bad Gateway when trying to access sharepoint list using REST API

(1) Share

Report

Posted on by summercoke77

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

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

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

and following is the error message

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.

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Gopala_Krishna 1,495 on at

Like
a
(1)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
brooksg23 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@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!

Was this reply helpful? Yes No
bassiekb1983 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No