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?
Solved! Go to 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
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
67 | |
24 | |
16 | |
16 | |
12 |
User | Count |
---|---|
116 | |
35 | |
32 | |
28 | |
26 |