web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Create SharePoint list - BadGateway 500 error

(0) ShareShare
ReportReport
Posted on by 265

This part of the flow did work earlier, so I'm wondering if I exceeded some quota or something during test?

I get this error:

SPListFail2.png

SPListFail1.png

{
"error": {
"code": 500,
"source": "flow-apim-europe-001-westeurope-01.azure-apim.net",
"clientRequestId": "6b1d32e4-807b-42ec-bf72-13c4d579a0fb",
"message": "BadGateway",
"innerError": {
"status": 500,
"message": "Cannot add value because header 'Authorization' does not support multiple values.\r\nclientRequestId: 6b1d32e4-807b-42ec-bf72-13c4d579a0fb",
"source": "https://sharepointonline-ne.azconn-ne.p.azurewebsites.net/datasets/https%253A%252F%252Fnavteamcom.sharepoint.com%252Fsites%252FNT36/httprequest",
"errors": []
}
}
}

 

{
"Pragma": "no-cache",
"x-ms-request-id": "6b1d32e4-807b-42ec-bf72-13c4d579a0fb",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "DENY",
"Cache-Control": "no-store, no-cache",
"Set-Cookie": "ARRAffinity=7fec6b3d494d502cd339a098a470860ddaf458b68c32b8ce8e190c362de93b94;Path=/;HttpOnly;Secure;Domain=sharepointonline-ne.azconn-ne.p.azurewebsites.net,ARRAffinitySameSite=7fec6b3d494d502cd339a098a470860ddaf458b68c32b8ce8e190c362de93b94;Path=/;HttpOnly;SameSite=None;Secure;Domain=sharepointonline-ne.azconn-ne.p.azurewebsites.net",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "true",
"Date": "Fri, 24 Sep 2021 11:46:57 GMT",
"Content-Length": "597",
"Content-Type": "application/json",
"Expires": "-1"
}

_________________________________

Now, I have read in other posts that authorization could be the problem..  or the API version. So here are my info:

SPListFail3.png

 

My flow looks like this:

SPListFail4.png

 

I'm no programmer, som I follow blogs'n'such. Here is the one I use for this purpose:

Create a SharePoint list using Power Automate (sharepains.com)

 

I really hope you can help 😊

 

/Thomas

I have the same question (0)
  • Verified answer
    Expiscornovus Profile Picture
    32,932 Most Valuable Professional on at
    Re: Create SharePoint list - BadGateway 500 error

    Hi @ThomasDK,


    Can you try it without the Authorization in the Header? You already should be connected to SharePoint via the connection in the action itself.

     

    Edit: here is an example.

     

    createlist_restapi.png

  • ThomasDK Profile Picture
    265 on at
    Re: Create SharePoint list - BadGateway 500 error

    Ahh, thats why it was working before.. I use to not have it and must have added it and forgot about it again. Thanks!!!

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

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 535 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 348 Moderator

#3
developerAJ Profile Picture

developerAJ 262

Last 30 days Overall leaderboard