cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kumarraj88
Helper III
Helper III

copying of managed metadata column from one list to another is not working

 

Update item:

Step 1:  I am using Parse step and then updating some of the empty column of an existing item in a list and also replacing existing column with same values, so that all columns content will be available at one particular version.

 

1.get item

2. Parge JSON

2. update item

4. send http request to sharepoint site

 

Update item one of the managed metadata column:

2.JPG

 

And from this source list I am would like to copy that item to another list under different site collection. For which I am using “send an https request to SharePoint site”.

Here it is copying all the columns except “managed metadata fields”. Ex: Branch.

 

In the body I am using like this. Am I doing something wrong here? Do I need use different body here?

Capture.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
v-litu-msft
Community Support
Community Support

Hi @kumarraj88,

 

What's the error occupied when you Send HTTP request to SharePoint?

Could you please share the whole configuration of the HTTP request?

 

This is the document that introduction about SharePoint rest service:

https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/get-to-know-the-sharepoint-rest-service

 

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.

View solution in original post

3 REPLIES 3
v-litu-msft
Community Support
Community Support

Hi @kumarraj88,

 

What's the error occupied when you Send HTTP request to SharePoint?

Could you please share the whole configuration of the HTTP request?

 

This is the document that introduction about SharePoint rest service:

https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/get-to-know-the-sharepoint-rest-service

 

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.

View solution in original post

    

Here is my configuration of sending https to SharePoint site/list.

This is an example for one of the managed metadata column.

 

"ManagedServiceLevel":{

"_metadata":{

"type": "SP.Taxonomy.TaxonomyFieldValue"

},

"TermGuid": "@{body('Update_item')?['ManagedServiceLevel']?['TermGuid']}",

"WssId": -1

},

Capture.PNG

 

@v-litu-msft

I am using below steps:

 

1. Get item

2. Parse JSON

 

{
"type": "object",
"properties": {
"@@odata.etag": {
"type": "string"
},
"ItemInternalId": {
"type": "string"
},
"ID": {
"type": "integer"
},
"Title": {
"type": "string"
},
"Client": {
"type": "object",
"properties": {
"@@odata.type": {
"type": "string"
},
"Id": {
"type": "integer"
},
"Value": {
"type": "string"
}
}
},
"Client#Id": {
"type": "integer"
},
"Client_x003A_ClientNumber": {
"type": "object",
"properties": {
"@@odata.type": {
"type": "string"
},
"Id": {
"type": "integer"
},
"Value": {
"type": "string"
}
}
},
"Client_x003A_ClientNumber#Id": {
"type": "integer"
},
"Branch": {
"type": "object",
"properties": {
"@@odata.type": {
"type": "string"
},
"TermGuid": {
"type": "string"
},
"WssId": {
"type": "integer"
},
"Label": {
"type": "string"
},
"Path": {},
"Value": {
"type": "string"
}
}
},
"Branch#WssId": {
"type": "integer"
},
"ManagedService": {
"type": "object",
"properties": {
"@@odata.type": {
"type": "string"
},
"TermGuid": {
"type": "string"
},
"WssId": {
"type": "integer"
},
"Label": {
"type": "string"
},
"Path": {},
"Value": {
"type": "string"
}
}
},
"ManagedService#WssId": {
"type": "integer"
},
"ManagedServiceLevel": {
"type": "object",
"properties": {
"@@odata.type": {
"type": "string"
},
"TermGuid": {
"type": "string"
},
"WssId": {
"type": "integer"
},
"Label": {
"type": "string"
},
"Path": {},
"Value": {
"type": "string"
}
}
},
"ManagedServiceLevel#WssId": {
"type": "integer"
},
"ClientServiceManager": {
"type": "object",
"properties": {
"@@odata.type": {
"type": "string"
},
"Id": {
"type": "integer"
},
"Value": {
"type": "string"
}
}
},
"ClientServiceManager#Id": {
"type": "integer"
},
"OperationsLead": {
"type": "object",
"properties": {
"@@odata.type": {
"type": "string"
},
"Id": {
"type": "integer"
},
"Value": {
"type": "string"
}
}
},
"OperationsLead#Id": {
"type": "integer"
},
"SiteFocal": {
"type": "object",
"properties": {
"@@odata.type": {
"type": "string"
},
"Id": {
"type": "integer"
},
"Value": {
"type": "string"
}
}
},
"SiteFocal#Id": {
"type": "integer"
},
"SiteManager": {
"type": "object",
"properties": {
"@@odata.type": {
"type": "string"
},
"Id": {
"type": "integer"
},
"Value": {
"type": "string"
}
}
},
"SiteManager#Id": {
"type": "integer"
},
"Notes1": {
"type": "string"
},
"SpecialRequirements": {
"type": "array",
"items": {
"type": "object",
"properties": {
"@@odata.type": {
"type": "string"
},
"TermGuid": {
"type": "string"
},
"WssId": {
"type": "integer"
},
"Label": {
"type": "string"
},
"Path": {},
"Value": {
"type": "string"
}
},
"required": [
"@@odata.type",
"TermGuid",
"WssId",
"Label",
"Path",
"Value"
]
}
},
"SpecialRequirements@odata.type": {
"type": "string"
},
"SpecialRequirements#WssId": {
"type": "array",
"items": {
"type": "integer"
}
},
"SpecialRequirements#WssId@odata.type": {
"type": "string"
},
"UniqueItemID": {
"type": "string"
},
"Created": {
"type": "string"
},
"Modified": {
"type": "string"
},
"CreatedWFCheck": {
"type": "string"
},
"ModifiedWFCheck": {
"type": "string"
},
"Author": {
"type": "object",
"properties": {
"@@odata.type": {
"type": "string"
},
"Claims": {
"type": "string"
},
"DisplayName": {
"type": "string"
},
"Email": {
"type": "string"
},
"Picture": {
"type": "string"
},
"Department": {
"type": "string"
},
"JobTitle": {
"type": "string"
}
}
},
"Author#Claims": {
"type": "string"
},
"Editor": {
"type": "object",
"properties": {
"@@odata.type": {
"type": "string"
},
"Claims": {
"type": "string"
},
"DisplayName": {
"type": "string"
},
"Email": {
"type": "string"
},
"Picture": {
"type": "string"
},
"Department": {
"type": "string"
},
"JobTitle": {
"type": "string"
}
}
},
"Editor#Claims": {
"type": "string"
},
"{Identifier}": {
"type": "string"
},
"{IsFolder}": {
"type": "boolean"
},
"{Thumbnail}": {
"type": "object",
"properties": {
"Large": {},
"Medium": {},
"Small": {}
}
},
"{Link}": {
"type": "string"
},
"{Name}": {
"type": "string"
},
"{FilenameWithExtension}": {
"type": "string"
},
"{Path}": {
"type": "string"
},
"{ContentType}": {
"type": "object",
"properties": {
"@@odata.type": {
"type": "string"
},
"Id": {
"type": "string"
},
"Name": {
"type": "string"
}
}
},
"{ContentType}#Id": {
"type": "string"
},
"{VersionNumber}": {
"type": "string"
}
}
}

 

 

 

3. update item → The reason why I am updating is because end user fills only some columns and flow will automatically fill remaining empty columns.(Here I am updating existing item in source list) Until here it is working fine.

4. send http to SharePoint site.

Capture.PNG

Here I am trying to copy the item from one list to another which includes Managed metadata.

 

@RandyHayes @yashag2255 if you have some spare time, is it possible to comment on my issue? 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,834)