CODEWITHSUNDEEP
azure-devopssharepointpower-automate
Runtime21
Runtime21

Reputation: 11

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?

Upvotes: 0

Views: 1447

Answers (1)

Alvin Zhao - MSFT
Alvin Zhao - MSFT

Reputation: 5797

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.

Upvotes: 0

Related Questions