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

  • Have you tried the suggestions given here? May 29, 2020 at 5:04

1 Answer 1


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

  • This worked thanks. I need to include addfield in uri and parameters in the body
    – tf1970
    May 29, 2020 at 8:33
  • Yes. Glad it worked for you. Please Upvote(^) and accept as an Answer as it helped you. May 29, 2020 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.