Introduction
Azure DevOps & SharePoint Online are two different systems with different schema structures. Here, I am going to take an example of one of the fields i.e. choice field value from DevOps to SharePoint Online using Power Automate; in a similar fashion, other filed values as well multiple field values can be synced in a scheduled manner,
Let's begin here by updating the extracted value with the SPO choice field using power automate.
Created a List into SharePoint Online with a choice column where the choice column has default values
Power Automate overview "Extract value from DevOps" is explained in detail here
Site Address |
https://m365x6151710.sharepoint.com/ |
Method |
POST |
URI |
_api/web/lists/GetByTitle('Resource')/Fields/GetByID('69ca0e44-d80d-4e5b-9038-33fdc2e87c9d') |
Header |
{
"accept": "application/json;odata=verbose",
"Content-Type": "application/json;odata=verbose",
"X-HTTP-Method": "PATCH",
"IF-MATCH": "*"
} |
Body |
{
"__metadata": {
"type": "SP.FieldChoice"
},
"Choices": {
"__metadata": {
"type": "Collection(Edm.String)"
},
"results": @{variables('TechnicalSkill')}
}
} |
https://m365x6151710.sharepoint.com/_api/web/lists/getbytitle('Resource')?$select=schemaXml
Let's execute the power automate to get the output
SharePoint Online List Choice fields.
Now, these extracted values are synced with another system like SharePoint Online List, so both systems i.e. Azure DevOps and SharePoint Online List choice values, are in sync without manually updating.
Hope you have learned something useful here.