I am trying to add a Lookup column from a SharePoint list using Microsoft Flow(Power automate). The flow retries once and says "Bad Gateway". I'm not sure why the below is not working given that I have included the 4 necessary things - FieldTypeKind, Title, LookupList, LookupField.

The aim is to get a column added to the Projects list, which is a lookup from the Workstream list.

I've tried using the LookupList name rather than ID and it didn't work. I have tried changing "Title: Workstream" to "Title: Title" which didn't work. The site address is accurate and I have been able to add SP.FieldChoice, SP.FieldText columns, which leads me to believe it's the body that needs something changing.

enter image description here


Try using below configurations in Send an HTTP request to SharePoint action to create a lookup field:

enter image description here

For more information, check below official documentation by Microsoft:

FieldLookup and FieldUser resources

| improve this answer | |
  • This worked thanks. I need to include addfield in uri and parameters in the body – tf1970 May 29 at 8:33
  • Yes. Glad it worked for you. Please Upvote(^) and accept as an Answer as it helped you. – Ganesh Sanap May 29 at 8:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.