Search code examples
azure-devopssharepointpower-automate

Connect Azure DevOps Queries to SharePoint List using Power Automate

I want to connect "Queries" option from azure devops to my sharepoint list using power automate.

Link to the screenshot/ picture

I have a custom query in the "queries" option in azure devops that has data.

How can I transfer that data into sharepoint list using power automate?

Solution

  • Just as @Sam Nseir mentioned, the action of Get query results under Azure Devops connector can help get the query results in Azure DevOps. Then, you may consider to Create item in SharePoint list with the results. However, once the query results changed, to synchronize the update into SharePoint list will be difficult.

    For this, I generated a simple workflow for your reference.

    enter image description here

    1. Get all items in the SharePoint list; enter image description here
    2. Delete all the items in the list; enter image description here
    3. Get query results from Azure DevOps; enter image description here
    4. Create new items into the list with each work item from the query result; enter image description here

    Kindly note that the item ID will be changed after each re-creation. You may consider using a custom column in the SharePoint list to identify each work item from the query result. Hope the sample could help.