cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ad99
Level: Powered On

Search for WorkItem in Azure DevOps based on title/tags in flow

Hi,

I am able to search for workitem in Azure DevOps given its ID, but I am looking for ways in which I can search for work item in Azure Devops given its title or Tags using Flow

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: Search for WorkItem in Azure DevOps based on title/tags in flow

Hi @ad99 

 

Currently flow does not support a search in work items based on title/ tags for Azure DevOps. 

 

You could probably construct a custom query for this and keep updating it dynamically to get the appropriate results. Here is my blog article where I have shown a simple example to create parametrised queries with dynamic elements from Flow: 

https://powerusers.microsoft.com/t5/Microsoft-Flow-Community-Blog/Create-Update-Parameterized-Querie...

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

5 REPLIES 5
Dual Super User
Dual Super User

Re: Search for WorkItem in Azure DevOps based on title/tags in flow

Hi @ad99 

 

Currently flow does not support a search in work items based on title/ tags for Azure DevOps. 

 

You could probably construct a custom query for this and keep updating it dynamically to get the appropriate results. Here is my blog article where I have shown a simple example to create parametrised queries with dynamic elements from Flow: 

https://powerusers.microsoft.com/t5/Microsoft-Flow-Community-Blog/Create-Update-Parameterized-Querie...

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

View solution in original post

Community Support Team
Community Support Team

Re: Search for WorkItem in Azure DevOps based on title/tags in flow

Hi @ad99 ,

 

As @yashag2255  said, search for work item in Azure Devops with its title or Tags derectly is not supported in microsoft flow currently.

 

If you would like the function to search for work item in Azure Devops with its title or Tags derectly to be supported in microsoft flow, you could submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ad99
Level: Powered On

Re: Search for WorkItem in Azure DevOps based on title/tags in flow

Hi @yashag2255,

 

When i tried to filter it based on title as shown below: (Where 'Override CleanUp12' is declared as variable)
{
"name" : "TestNew",
"queryType" : "tree",
"wiql" : "SELECT [System.Id],[System.Title],[System.State],[System.WorkItemType],[System.AssignedTo] FROM workitemLinks WHERE([Source].[System.Title]=Override CleanUp12) AND ([System.Links.LinkType] = 'System.LinkTypes.Hierarchy-Forward') AND ( [Target].[System.WorkItemType] <> '') MODE (Recursive)"
}

I am getting the following exception:
{
"$id": "1",
"innerException": null,
"message": " Expecting left bracket. The error is caused by «Override».",
"typeName": "Microsoft.TeamFoundation.WorkItemTracking.Client.Wiql.SyntaxException, Microsoft.TeamFoundation.WorkItemTracking.Client.QueryLanguage",
"typeKey": "SyntaxException",
"errorCode": 0,
"eventId": 0
}

Any clues about what I am doing wrong?

ad99
Level: Powered On

Re: Search for WorkItem in Azure DevOps based on title/tags in flow

Hi @yashag2255 ,

 

Found my mistake. As 'Override Cleanup' has spaces in between we need to specify it in single quotes. 

 

Thanks for your help

TomSt
Level: Power Up

Re: Search for WorkItem in Azure DevOps based on title/tags in flow

Hi @ad99 

I'd like to find a work item based on a specific tag.

 

For example:

 

- retrieve all work items

- from ADO project A

- that are closed

- with the tag of "xxx"

 

How would I go about that? I've suggested my initial steps below with some queries.

- Create a new 'automated from blank' FLOW

- select azure devops trigger 'when a work item is closed'

- Action: 'send HTTP request to ADO'

 

My queries:

 

- can you send me a screenshot of your HTTP request action? I;m unsure as to what values to populate.
- can you suggest the correct steps I should follow or send me a screenshot of your FLOW and I'll modify from there?

Thanks

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users Online
Currently online: 251 members 5,169 guests
Please welcome our newest community members: