Power Platform Community Forum Thread Details

Hi Community members,

Using Power Automate, I have created a flow which adds the values of custom fields like Dev Effort (Type=Decimal) & Test Effort (Type=Decimal) into system field i.e. Total Effort (Type=Decimal) field of the Product Backlog Item in Azure DevOps.

One thing to consider is that these fields will always be Blank intially when a new PBI is created & before entering any integer value.

Problem Statement: Whenever any field on a PBI is updated like adding a comment, acceptance criteria, changing priority or adding efforts, this flow deleted the description of the PBI. This needs to be fixed.

Below is the summary given by Copilot on this flow:

Your Power Automate flow seems to be set up correctly to achieve the goal of adding the "Dev Effort" and "Test Effort" fields and updating the "Total Effort" field in Azure DevOps. Here's a breakdown of what your flow is doing:

Trigger: The flow triggers when a work item of type "Product Backlog Item" is updated in the "CCS Dev" project.
Get Work Item Details: It retrieves the details of the updated work item.
Initialize Variables:
- DevEffort: Initialized to 0.
- TestEffort: Initialized to 0.
- Addition: Initialized to the sum of DevEffort and TestEffort.
Conditions:
- Condition for DevEffort: Checks if the "Dev Effort" field is null. If it is not null, it sets the DevEffort variable to the value of the "Dev Effort" field.
- Condition for TestEffort: Checks if the "Test Effort" field is null. If it is not null, it sets the TestEffort variable to the value of the "Test Effort" field.
Calculate Total Effort: The Addition variable is set to the sum of DevEffort and TestEffort.
Update Work Item: Updates the work item with the new "Total Effort" value while preserving the state and other fields.