
Announcements
Hi,
I am trying to create a flow for Due date Alert for Azure DevOps Project,
And i do not know how to do it, cause I am in a learn stage, and still do not know how to do it,
If anyone can help to create a flow, will be very helpful and if you have any question please ask!
I will explain in Details.
Hi @DivyanshB23,
You can use a WIQL query for this in a Send an HTTP request to Azure DevOps action.
Below is an example
This is the WIQL query. In this WIQL query I check if the targetdate is less than today for all work items which are of type Feature.
URI
@{variables('ProjectName')}/_apis/wit/wiql?timePrecision=true&api-version=7.1-preview.2
Body
{
"query": "SELECT [System.Id],[System.AssignedTo],[System.State],[System.Title],[System.Tags],[System.WorkItemType],[Microsoft.VSTS.Scheduling.TargetDate]
FROM WorkItems
WHERE ([System.WorkItemType] = 'Feature') AND [Microsoft.VSTS.Scheduling.TargetDate] <= '@{utcNow()}'"
}