cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jgriebel
Advocate I
Advocate I

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
v-yuazh-msft
Community Support
Community Support

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

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 

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. 

sergeluca
MVP

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

sergeluca
MVP

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

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. 

sergeluca
MVP

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

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Users online (38,897)