You’re offline. This is a read only version of the page.
4
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
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
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
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
