I'm trying to create a flow to retrieve Sharepoint list items via an on premise gateway. The gateway works fine otherwise (and in other flows). The "Get Items" step correctly displays all the lists for that site. However it does not see the views.
Without being able to select a view to limit the columns, I get a 502 error when using the flow:
Is there a way I can manually enter a value for the view? I've tried just entering the name, but that didn't work. When looking at the details of the run history, I saw that it seemed to use the list ID in the query, so I tried that for the view also, but it didn't work. Is there another way to do this?
If the error code 500 or 502 appears, the failure is temporary or transient. Click or tap Resubmit to try the flow again.
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Hi @DHC518 ,
Does the issue still exist?
Where are your region?
There is some issue of the UK environments recently.
Please take a reference the Flow Support:
UK environments have fully recovered as of about 01:50 UTC May 15.
Community Support Team _ Zhongys
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I don't think the 500 error is a transient error. This 500 error is legitimate for when you exceed the number of lookup columns like this list does, but you should be able to select a view that is within the limits to get around it. That is my issue -- I can't select a view, or manually enter one.
Speakers, submit your sessions now! Call for speakers ends Feb. 10!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!