Create Lookup column in SharePoint list using the HTTP Request to Sharepoint

[saul89]

Hi Everyone,

I'm trying to add a lookup column to an existing Sharepoint List (allowing multiple values), using Power Automate (HTTP Request to Sharepoint).

I was able to add a 'simple' type column following the solution of this post: https://powerusers.microsoft.com/t5/Building-Flows/Create-a-new-column-in-SharePoint-list-from-Flow/...

I read the Fields REST API Documentation (https://docs.microsoft.com/en-us/previous-versions/office/developer/sharepoint-rest-reference/dn6001...) and tried to follow the instruction, but, inspite multiple attempts, I wasn't able to make it work for a Lookup Column Type.

Here are some screenshots of the attempted flows:

In this case the flow keeps running for minutes without stopping, but seems like it´s a BadGateway error. Even without the "LookupWebId" and "AllowMultipleValues" in the Body, the flow didn´t work.

In this case the flow doesn´t even start and I get this error: 

"An entry without a type name was found, but no expected type was specified. To allow entries without type information, the expected type must also be specified when the model is specified."

Thank you in advance for your help!

Regards,

Saul

[v-litu-msft]

Hi @saul89,

Please look at this document, maybe it will help you:

https://docs.microsoft.com/en-us/previous-versions/office/sharepoint-visio/jj245299%28v%3doffice.15%...

This is the Blog that how to find the GUID of the column:

https://kennekro.net/2017/02/find-guid-of-list-column-in-sharepoint/

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Cmac474]

I'm currently facing the same issue - did you ever resolve this?

[saul89]

Unfortunately not 😞

[Cmac474]

This will work - but you need to know the GUID of the of the list you are looking up

[CarlHRVA]

@Cmac474 wondering if you could tell me what I'm doing wrong here. I'm getting the following error:

An entry without a type name was found, but no expected type was specified. To allow entries without type information, the expected type must also be specified when the model is specified.

The body of my HTTP request looks like this:

{
'parameters': {
'__metadata': {
'type': 'SP.FieldCreationInformation'},
'FieldTypeKind': 7,
'Title': 'Hotel Name',
'LookupListId': '{static GUID for lookup list here}',
'LookupFieldName': 'Title'
}
}

This would be immensely helpful if I could get it to work. Thanks in advance for any advice you can give!

[CarlHRVA]

Figured it out looking at another post. I didn't have the correct headers for my request and I was missing  "/addfield" in the Uri, once added it worked perfectly.

[Cmac474]

Just got to this now, glad you figured it out 🙂

[AnouckFierens]

I tried everything that was placed in this post but I keep on receiving the error: 

Incorrectly formatted json stream. clientRequestId: 2164ceae-6e26-4930-a7b3-319ef1fe6368 serviceRequestId: 778edf9f-c0f7-3000-0da3-62988f3ee026

 

Am I doing something wrong?

[SmoothOperator]

I am currently looking for a solution in creating a LookUp column from Power Automate and tried maaany solutions found online; alongside with experimentation, I have not actually manage to do this. 

Can anyone add up to this?

[Cmac474]

I just ran this test again and it works

SIte Address

Method = Post

URI = _api/lists/getbytitle('LISTNAME')/fields/addfield

Headers = accept application/json;odata=verbose

                  content-type application/json;odata=verbose

body = 

{
'parameters': {
'__metadata': {
'type': 'SP.FieldCreationInformation'},
'FieldTypeKind': 7,
'Title': 'Name of Column you want to create',
'LookupListId': '{GUID of the list you want to look up - remove the %7B and %7D }',
'LookupFieldName': 'Field you want to lookup'
}
}

[AnouckFierens]

I just tried this again and for me this isn't working.

[svramkuna]

Hi @Cmac474 ,

Can you tell me how to get GUID and also View ID for  the particular list.

Thanks in Advance

[Cmac474]

You have to go to the list and then open the settings for the list and it will be at the end of the URL  List=%7B'ListID'%7D

*edit (didn't see the view id part)

while in settings, scroll down to views and click on the one in question - same as above, except View=

[Praba]

{
'parameters': {
'__metadata': {
'type': 'SP.FieldCreationInformation'},
'FieldTypeKind': 7,
'Title': 'Project name',
'LookupListId': '{}',
'LookupFieldName': 'P name'
}
}

this is working fine but there is a custom option inside the look up (Add a column to show each of these additional fields:) how to choose this.