Unanswered

Azure DevOps trigger "When a work item is closed" fails TF212023

(0) Share

Report

Posted on by Cecilie

Hi,

I have built a Power Automate flow using the Azure DevOps trigger "When a work item is updated". My flow worked fine up to a couple of weeks ago when it started failing with the following message:

TF212023: You cannot compare fields with different data types in the WHERE clause of a work item query. The error is caused by «[System.ChangedDate] >= '2021-06-17T12.41.55.5279680Z'».

With also: type name: "Microsoft.VisualStudio.Services.Common.VssPropertyValidationException, Version=14.0.0.0, Culture=neutral, "errorCode":0

I have tried rebuilding the flow from scratch, but it still won't trigger.

My step looks like this:

Any ideas on how to fix this? Could it be a setting (timezone, time formatting) in my Azure DevOps organisation?

Best regards,

Cecilie

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Rahber 1,935 on at

Like (0)

Report

In your screenshot you are using when a work item is updated. IS the problem with Work item is updated or work item is completed?

In your screenshot i don't see any date being used. Can you confirm that?

Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.

Thanks,
Rahber

Was this reply helpful? Yes No
Cecilie 4 on at

Like (0)

Report

Hi, the problem is with "work item is updated". My flow is supposed to update the status field in a Sharepoint list if the corresponding user story in Azure DevOps changes board column, independent of whether it is completed or not. E.g. if the user story is moved from "New" to "Active" column, the status field in my Sharepoint list should automatically be updated to "Active".

I am not setting any dates in my flow. The date criteria that fails is inherent to the trigger. Which is why I'm wondering if there could be an issue with the environment or organization settings of my Azure DevOps board.

Regards,
Cecilie

Was this reply helpful? Yes No