cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jgriebel
Level: Powered On

Bad Gateway - SharePoint List - Get Items

Hi Together, 

 

When using the Action "Get Items" (from SharePoint list) I get the Bad Gateway error.

 

When debugging it turned out that the "Limit Columns by View" was the root cause.

While this was working well last week it now returns the error.

 

When I do the same action with blank in "Limit Columns by View" it is working well.

 

 

image.pngimage.png

 

best regards 

Jens G. 

7 REPLIES 7
Community Support Team
Community Support Team

Re: Bad Gateway - SharePoint List - Get Items

Hi @jgriebel,

 

I have made a test on my side and don't have the issue that you mentioned.

 

Please take a try to create a new flow to see if the issue still exists.

 

Best regards,

Alice

jgriebel
Level: Powered On

Re: Bad Gateway - SharePoint List - Get Items

Hi @v-yuazh-msft

 

I have tested my Flow and the Bad Gateway still coming up, I tried it with 2 different views both failed. 😞image.png

 

I also created an new Flow with same actions and it also fails, so no difference if I reuse an existing or build a new one.

Best regards

Jens 

EdgarB
Level: Powered On

Re: Bad Gateway - SharePoint List - Get Items

I am new to Sharepoint and Flow and a flow that we have in place is having the exact issue also started this week. Has anyone found a workaround for this? Disabling the limit view is not an option because there are too many lookup fields in our SharePoint List and it also fails. 

Super User
Super User

Re: Bad Gateway - SharePoint List - Get Items

I can confirm that I've experimented the same issue 2 or 3 days ago and now it works. I've pinged the Flow team on this.

 

Kind regards

 

 

Serge Luca

Office 365 MVP

Flow MVP

 

aka Doctor Flow

@sergeluca

Super User
Super User

Re: Bad Gateway - SharePoint List - Get Items

I can confirm that I've experimented the same issue 2 or 3 days ago and now it works. I've pinged the Flow team on this.

 

Kind regards 

 

Serge Luca

Office 365 MVP

Flow MVP

 

aka Doctor Flow

@sergeluca

EdgarB
Level: Powered On

Re: Bad Gateway - SharePoint List - Get Items

Tested yesterday and today and we can get it going by selecting All Items view but still does not work when selecting a custom view. 

Super User
Super User

Re: Bad Gateway - SharePoint List - Get Items

I'll test with views. But I remembere that i brokes when I switched to view last time. I'll keep you informed

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,926)