I'm trying to run a Flow on an on-premise SharePoint Site. The On-premise data gateway is running and I created a connection to it. I am also able to successfully run Flow on a list that does not contain a lookup field to another list.
My probem is when the list contains a lookup field to another list on the same SharePoint site, I get a 'BadRequest' error. Status code is 400
The body of the output is:
"message": "The field 'Facility' is not supported in query. The lookup list does not exist.\r\nclientRequestId: 77a48c5b-681f-4c9d-adde-87fc6ee117b4\r\nserviceRequestId: df31829e-94eb-f03a-9712-1f8d7aab0173;df31829e-64f3-f03a-9712-1275f26f90c8;e031829e-f406-f03a-9712-1fbbed50d9df;e031829e-b40f-f03a-9712-1a5d0f7d12c2;e031829e-8418-f03a-9712-1aba8e301699;e031829e-5420-f03a-9712-14c03c1b4500",
Has anybody else come across this?
Could you share a screenshot of your flow? how is it created?
Besides, error 400 means a setting in an action of the flow doesn’t function as expected, you may need to correct the problem inside the flow definition. Please try to update the flow or Resubmit to try the run again with the updated configuration.
I don’t have on-Premise SharePoint to test this issue, so I made a simple test with SharePoint Online and it didn’t return any error message. If you also SharePoint Online, please make a simple test on your side to see if it will work.
I was able to successfully run a flow on a list with a lookup on another on-premise site. So I'm thinking there's something different about the setup of this on-premise server. I think some configuration settings needs to be modified but don't know which one.
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!