web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Assigning Iteration St...

Power Automate

Unanswered

Assigning Iteration Start and End dates to Work Item Start Date and End Dates in Azure Dev ops

(0) Share

Report

Report

Posted on by frenchie

Hello everyone,

I'm building a flow in power automate to help make a recurrent task easier for me.

In azure dev ops, when any work item is assigned to an iteration (aka sprint), I want that iterations start date and end date to be applied to the work item's start date and due date respectively automatically.

This is the flow I have created:

This is the condition I have set up.

And this is the "Other Field" I have set up.

This is my first flow and I clearly know I have done something wrong.

Any advice is much appreciated.

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Expiscornovus 33,830 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @frenchie,

I see in your screenshot you placed the date value in the key field of the Other fields section.

The key is used to refer to the field you want to update. So, that would be Start Date. The date value can be placed in the value field.

Below is an example

In this example I am updating an EPIC work item.

1. Via a Send an HTTP request to Azure DevOps the current iteration is retrieved

@{variables('ProjectName')}/_apis/work/teamsettings/iterations?$timeframe=current&api-version=7.1-preview.1

2. This expression is used to retrieve the startDate from the current iteration

outputs('Send_an_HTTP_request_to_Azure_DevOps_-_List_Iterations')?['body']['value'][0]['attributes']['startDate']

3. This expression is used to retrieve the finishDate from the current iteration

outputs('Send_an_HTTP_request_to_Azure_DevOps_-_List_Iterations')?['body']['value'][0]['attributes']['finishDate']

Was this reply helpful? Yes No

Join the conversation