Default value for Region "Global"
The "Region" will be filled also by some rules:
IF Country == "DE" THEN Region = "EMEA"
IF Country == "US" THEN Region = "Americas"
...
When opening now a query in excel which includes both fields and new WIs are created, then the "Region" first gets the default value. After publishing I can see the correct value for "Region" in Excel but not in AzDO
Press again to "Publish" doesn´t work, because the data "didn`t" change
When I edit afterwards another field, then the "Region" field will be updated correctly in AzDO
Steps to reproduce
WI has two fields eg "Country" and "Region".
Default value for Region "Global" The "Region" will be filled also by some rules: IF Country == "DE" THEN Region = "EMEA" IF Country == "US" THEN Region = "Americas" ...
When opening now a query in excel which includes both fields and new WIs are created, then the "Region" first gets the default value. After publishing I can see the correct value for "Region" in Excel but not in AzDO
Press again to "Publish" doesn´t work, because the data "didn`t" change When I edit afterwards another field, then the "Region" field will be updated correctly in AzDO