How to create flow to create a new lookup column with all multiple value property enabled in a given share point list?

[pcakhilnadh]

I have a SP List named "MyList" I wanted to create a new lookup column to it from Power automate? 

How to  write the flow for this task?

[v-xiaochen-msft · Accepted solution]

Hi @pcakhilnadh ,

I did a test for you.

_api/lists/getbytitle('your list name')/fields/addfield

accept application/json;odata=verbose

content-Type application/json;odata=verbose

{
'parameters': {
'__metadata': {
'type': 'SP.FieldCreationInformation'},
'FieldTypeKind': 7,
'Title': 'BB',
'LookupListId': 'your related list Id',
'LookupFieldName': 'Title'
}
}

//GUID of the list you want to look up - remove the %7B and %7D

_api/web/lists(guid'your list id')/fields('@{body('Send_an_HTTP_request_to_SharePoint')['d/Id']}')

X-HTTP-Method MERGE

{'AllowMultipleValues': true }

Best Regards,

Wearsky