cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pcakhilnadh
Helper IV
Helper IV

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @pcakhilnadh ,

 

I did a test for you.

vxiaochenmsft_0-1638154413047.png

vxiaochenmsft_1-1638154433243.png

vxiaochenmsft_2-1638154512445.png

_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

 

 

 

View solution in original post

1 REPLY 1
v-xiaochen-msft
Community Support
Community Support

Hi @pcakhilnadh ,

 

I did a test for you.

vxiaochenmsft_0-1638154413047.png

vxiaochenmsft_1-1638154433243.png

vxiaochenmsft_2-1638154512445.png

_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

 

 

 

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Top Kudoed Authors
Users online (3,330)