Introduction
Azure DevOps board is used to create a task or work item with a pre-defined or custom work item template. It can consist of multiple different types of fields like Text, Multi Text, Drop Down, Identity (People Picker), and Date Time. If, as a developer, I need to extract all schema-defined drop-down values and need to sync with another system like the SharePoint Online List choice column.
I have divided this article into two parts,
- Extraction of Work Item Drop Down values using Power Automation
- Sync the extracted drop-down values with the SharePoint Online List Choice column.
Let's begin here with the creation of a work item and extraction using power automate.
- Login to https://dev.azure.com with your valid organization credentials.
- Select the respective organization and project. (In my case, m365x6151710 is my organization, and Resource is a project name).
- Navigate to Borad from the left-hand side menu and click New Work Item.
- Select the work item as Resource (custom work item type with defined i.e. multiple dummy columns).
- Resource Work Item type has the below layout, and the User can submit the detail as provided.
- Technical Skill i.e. drop-down field, has multiple values which need to extract.
Power Auotmate Steps
This is how the entire power automate looks like.
Let's execute the power automate to get the output.
Now, these extracted values can be synced with another system like SharePoint Online List, so both systems i.e. Azure DevOps and SharePoint Online List choice values, should be in sync without manually updating.
Hope you have learned something useful and stay tuned with the next part of the article i.e. Sync these values with SharePoint Online List Choice columns as schema values.