You’re offline. This is a read only version of the page.
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
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
Hi @yashag2255 ,
Found my mistake. As 'Override Cleanup' has spaces in between we need to specify it in single quotes.
Thanks for your help
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?
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.
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:
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!
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
Share
Report
All responses (
Answers (
