Error Power Automate The field ‘State’ contains the value ‘XXXX’ that is not in the list of supported values – AzureDevOps

[amaurysaldana]

I'm doing a flow that runs after a work item in Azure is changed to an X state and other custom fields. Everything runs until after receiving approval or rejection from the approver, when the flow reaches the part to update the work item, specifically the custom status and throws the following error:

The field ‘State’ contains the value ‘XXXX’ that is not in the list of supported values

View el Output:

{"statusCode":400,"headers":{"Pragma":"no-cache","x-ms-request-id":"27d8475b-93ec-4554-8c3d-cd7c5d9ac3a1","Strict-Transport-Security":"max-age=31536000; includeSubDomains","X-Content-Type-Options":"nosniff","X-Frame-Options":"DENY","Cache-Control":"no-store, no-cache","Set-Cookie":"ARRAffinity=9c9c847b5bd6c73a56d4f1afae4aecaa7f5b746d703be6c728afc87b6c50d7e3;Path=/;HttpOnly;Secure;Domain=vsts-eus2.azconn-eus2-01.p.azurewebsites.net,ARRAffinitySameSite=9c9c847b5bd6c73a56d4f1afae4aecaa7f5b746d703be6c728afc87b6c50d7e3;Path=/;HttpOnly;SameSite=None;Secure;Domain=vsts-eus2.azconn-eus2-01.p.azurewebsites.net","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"true","Date":"Fri, 30 Apr 2021 20:18:32 GMT","Content-Length":"2456","Content-Type":"application/json","Expires":"-1"},"body":{"status":400,"message":"Azure DevOps rule(s) has been violated. See underlying error for details.\r\nAzure DevOps ActivityId: d69ac884-ef2a-4e03-992a-6c08ea88ad74\r\nDetails: {\"$id\":\"1\",\"customProperties\":{\"FieldReferenceName\":null,\"FieldStatusFlags\":\"none\",\"ErrorMessage\":\"The field 'State' contains the value 'Rechazado CAB' that is not in the list of supported values\",\"FieldStatusCode\":0,\"RuleValidationErrors\":[{\"fieldReferenceName\":\"System.State\",\"fieldStatusFlags\":\"required, hasValues, limitedToValues, invalidListValue\",\"errorMessage\":\"The field 'State' contains the value 'Rechazado CAB' that is not in the list of supported values\",\"fieldStatusCode\":4194317,\"ruleValidationErrors\":null}]},\"innerException\":null,\"message\":\"The field 'State' contains the value 'Rechazado CAB' that is not in the list of supported values\",\"typeName\":\"Microsoft.TeamFoundation.WorkItemTracking.Server.RuleValidationException, Microsoft.TeamFoundation.WorkItemTracking.Server, Version=14.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a\",\"typeKey\":\"RuleValidationException\",\"errorCode\":0,\"eventId\":3200}\r\nclientRequestId: 27d8475b-93ec-4554-8c3d-cd7c5d9ac3a1","error":{"message":"Azure DevOps rule(s) has been violated. See underlying error for details.\r\nAzure DevOps ActivityId: d69ac884-ef2a-4e03-992a-6c08ea88ad74\r\nDetails: {\"$id\":\"1\",\"customProperties\":{\"FieldReferenceName\":null,\"FieldStatusFlags\":\"none\",\"ErrorMessage\":\"The field 'State' contains the value 'Rechazado CAB' that is not in the list of supported values\",\"FieldStatusCode\":0,\"RuleValidationErrors\":[{\"fieldReferenceName\":\"System.State\",\"fieldStatusFlags\":\"required, hasValues, limitedToValues, invalidListValue\",\"errorMessage\":\"The field 'State' contains the value 'Rechazado CAB' that is not in the list of supported values\",\"fieldStatusCode\":4194317,\"ruleValidationErrors\":null}]},\"innerException\":null,\"message\":\"The field 'State' contains the value 'Rechazado CAB' that is not in the list of supported values\",\"typeName\":\"Microsoft.TeamFoundation.WorkItemTracking.Server.RuleValidationException, Microsoft.TeamFoundation.WorkItemTracking.Server, Version=14.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a\",\"typeKey\":\"RuleValidationException\",\"errorCode\":0,\"eventId\":3200}"},"source":"vsts-eus2.azconn-eus2-01.p.azurewebsites.net"}}

[Mira_Ghaly]

@amaurysaldana

It looks like you are setting a wrong value in the state field

Can you recheck the value passed to the state field? Or paste screens from your flow so we can help more.

Thanks.

[amaurysaldana]

View Work item en Azure with states:

[Mira_Ghaly]

@amaurysaldana

I guess you need to pass the statecode value rather than the name. 

[amaurysaldana]

How can I do that?

[Mira_Ghaly]

@amaurysaldana 

I have been looking more into this issue, from what I read I understood that this custom state should be related to a category and work item type. 

So the way you are setting it looks correct, are u able to update the item from the UI to the same state? 

[amaurysaldana]

Yes, from the UI allows me to switch to all custom states

[Mira_Ghaly]

@amaurysaldana

I would like to suggest the below to troubleshoot this issue, create a manual flow and add Getworkitemdetails action and pass the Id of an existing work item with custom state, run the flow and observe the output.

[amaurysaldana]

Hi Mira and thank you very much in advance for your help; I have run the test that you indicate and now what is next?

View Output:

{
"statusCode": 200,
"headers": {
"Pragma": "no-cache",
"Vary": "Accept-Encoding",
"x-ms-request-id": "1cd19203-cca9-4766-8e98-6bc7b6016947",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "DENY",
"Cache-Control": "no-store, no-cache",
"Set-Cookie": "ARRAffinity=b7040b1d4c9c94be2ed2daa751e390a22561d89bc6e36ec48af3eb30a83df054;Path=/;HttpOnly;Secure;Domain=vsts-eus2.azconn-eus2-01.p.azurewebsites.net,ARRAffinitySameSite=b7040b1d4c9c94be2ed2daa751e390a22561d89bc6e36ec48af3eb30a83df054;Path=/;HttpOnly;SameSite=None;Secure;Domain=vsts-eus2.azconn-eus2-01.p.azurewebsites.net",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "false",
"Date": "Sat, 01 May 2021 00:11:10 GMT",
"Content-Type": "application/json; charset=utf-8",
"Expires": "-1",
"Content-Length": "8476"
},
"body": {
"id": 18209,
"rev": 17,
"url": "https://xxx.visualstudio.com/_apis/wit/workItems/18209",
"fields": {
"System_Id": 18209,
"System_AreaId": 6110,
"System_AreaPath": "BHDL Gestión de Cambios",
"System_TeamProject": "BHDL Gestión de Cambios",
"System_NodeName": "BHDL Gestión de Cambios",
"System_AreaLevel1": "BHDL Gestión de Cambios",
"System_Rev": 17,
"System_AuthorizedDate": "2021-04-30T20:17:04.713Z",
"System_RevisedDate": "9999-01-01T00:00:00Z",
"System_IterationId": 6102,
"System_IterationPath": "BHDL Gestión de Cambios",
"System_IterationLevel1": "BHDL Gestión de Cambios",
"System_WorkItemType": "Issue",
"System_State": "Sometido CAB",
"System_Reason": "Moved to state Sometido CAB",
"System_CreatedDate": "2021-04-30T19:58:57.2Z",
"System_CreatedBy": "AMAURY SALDAÑA, BHD <amaury_saldana@xxx.com.do>",
"System_ChangedDate": "2021-04-30T20:17:04.713Z",
"System_ChangedBy": "AMAURY SALDAÑA, BHD <amaury_saldana@xxx.com.do>",
"System_AuthorizedAs": "AMAURY SALDAÑA, BHD <amaury_saldana@xxx.com.do>",
"System_PersonId": 45354870,
"System_Watermark": 72877,
"System_CommentCount": 5,
"System_Title": "Pruebas Aprobaciones CAB",
"Microsoft_VSTS_Common_StateChangeDate": "2021-04-30T20:16:24.303Z",
"Microsoft_VSTS_Common_ActivatedDate": "2021-04-30T19:59:45.39Z",
"Microsoft_VSTS_Common_ActivatedBy": "AMAURY SALDAÑA, BHD <amaury_saldana@xxx.com.do>",
"Custom_AreaSolicitante": "Tecnología",
"Custom_Tipo": "Eficiencia",
"Custom_Arquitecto": "AMAURY SALDAÑA, BHD <amaury_saldana@xxx.com.do>",
"Custom_TipodeTrabajo": "Elegir opción",
"Custom_ScrumMaster": "AMAURY SALDAÑA, BHD <amaury_saldana@xxx.com.do>",
"Custom_AreaEjecutoradelCambio": "No Aplica",
"Custom_Plataforma": "Visual",
"Custom_LugardelTrabajo": "Remoto",
"Custom_MomentoSolicitado": "A la hora indicada",
"Custom_e2fbf2b2-5662-4af1-9506-73b855944184": "15 minutos",
"Custom_499f7cc7-ba99-4145-be6f-0d5a6ad4d69a": false,
"Custom_ImplicacionesdelDesarrollo": "Elegir opción",
"Custom_ImplicapasedeObjetos": false,
"Custom_LiderdeSQA": "AMAURY SALDAÑA, BHD <amaury_saldana@xxx.com.do>",
"Custom_GestordeAmbiente": "AMAURY SALDAÑA, BHD <amaury_saldana@xxx.com.do>",
"Custom_ObjetivosAlcanzados": false,
"Custom_FueNecesarioRollback": false,
"Custom_AreadeApoyo": "No Aplica",
"Custom_TipodeCAB": "ECAB Virtual",
"Custom_8aa71c10-f7b4-4047-b3e6-0e375474e988": "2021-04-30T19:53:00.643Z",
"Custom_VentanadeCambios": "Cuando Estemos Listos",
"Custom_bdf93bde-e21a-4cba-b3c1-7f143e032cf4": "Elegir opción",
"Custom_FechaAprobadadiferentealaSolicitada": false,
"Custom_HoraAprobadadiferentealaSolicitada": false,
"Custom_MomentoAprobadodiferentealSolicitado": false,
"Custom_8c17706c-9e4a-4a4c-9d6c-db1a3861ed7c": "2021-04-30T19:53:00.643Z",
"Custom_1544e1f7-4751-4ff3-a6b7-2c2d0037a779": "Elegir opción",
"Custom_SistemasInvolucrados": "Azure",
"Custom_Empresa": "BHD León",
"Custom_EspaciodeTrabajoAfectado": "Desarrollo",
"Custom_1e0c1b51-9184-4e34-a100-82e083ff426b": "Elegir opción",
"Custom_Prioridaddelcambioasignada": "Elegir opción",
"Custom_Subtipo": "A Solicitud de Tecnología",
"Custom_858bb036-cf16-4aff-bafc-25690343a73f": "Ejecucion de Procesos Nuevos en Aplicaciones Visuales",
"Custom_4badfb76-508f-44db-8da3-a4d36a33f197": "1 Mes",
"Custom_SurgieronEventosnoContemplados": false,
"Custom_SeAfectaronServiciosNOContemplados": false,
"Custom_SeEjecutaronActividadesnoContempladas": false,
"Custom_IncluyeBasedeDatos": false,
"Custom_IncluyeControlM": false,
"Custom_FechayHoraSolicitada": "2021-05-07T04:00:00Z",
"Custom_1751b8df-0614-4d85-aa4c-480505d1b83f": false,
"Custom_CheckListLaSolicituddebeestarenEstadoImplementado": false,
"Custom_e5cbabd2-5370-4627-a96d-432da5178c74": false,
"Custom_f800335e-bdb2-49be-b29a-3c4051f67e87": false,
"Custom_CheckListDebetenertodaslasaprobaciones": false,
"Custom_CheckListElInformedeResultadodebeestarcompletado": false,
"Custom_CheckListNodebetenerObservacionespendientes": false,
"Custom_CheckListCuandoseaunECABdebetenerloscorreosdeaprobacionesagregados": false,
"Custom_CheckListLasTareasdebenestarcompletadasCamposyEstado": false,
"Custom_b9a9f487-8320-4fb6-a83d-65b4129c0fa7": false,
"Custom_22c3d49c-bf75-4c3c-9d59-81796c249bc2": false,
"Custom_8c0337d0-6b50-4c43-a68b-d14d1451f57f": false,
"Custom_86bb1586-c1a7-4ce1-86ca-e04bffea512b": "Elegir opción",
"Custom_CheckListHardeningdeServidores": false,
"Custom_4ff0e899-0973-4eba-bedf-5abd2aaf4c1d": false,
"Custom_CheckListPruebasdevulnerabilidades": false,
"Custom_0d3063c5-3cb2-4d26-a853-cae9dc000090": false,
"Custom_CheckListEspuertosegurohttps": false,
"Custom_CheckListHardeningBasedeDatos": false,
"Custom_1cb2e48a-85aa-4fc8-a7e0-378a7437cb11": false,
"Custom_1c54abb1-8ea4-4662-b5c5-c6a43e2f486d": false,
"Custom_Scriptsdeobjetos": false,
"Custom_15a2d23a-4534-4e99-a16b-572031ba5f69": false,
"Custom_TipodeDesarrollo": "Inhouse",
"Custom_73ac4951-367c-4fb1-ae4e-59a7673dab10": false,
"Custom_669c7f20-b390-4f5d-a639-e83dccf1fa58": false,
"Custom_RepositoriosenAzureDevOps": false,
"Custom_ca38ac38-2df5-41bc-8fec-ecc65e5ddc9b": false,
"Custom_d8188d03-5826-4008-84c7-35b78fecd835": false,
"Custom_f5077ae8-eb9c-4faa-bc6c-59b47ba26c81": "Verificando GP",
"Custom_7ca9ea76-48dd-49ee-9059-72656f6be503": "AMAURY SALDAÑA, BHD <amaury_saldana@xxx.com.do>",
"Custom_30379bca-e5c9-4c98-8e87-3c5e728e2e41": "AMAURY SALDAÑA, BHD <amaury_saldana@xxx.com.do>",
"Custom_64ca8624-5640-4baf-874f-6af42fe8ac9a": "AMAURY SALDAÑA, BHD <amaury_saldana@xxx.com.do>",
"Custom_ImpactoCategoria": "Moderado",
"System_Description": "<div>Pruebas Aprobaciones CAB<br></div>",
"Microsoft_VSTS_CMMI_Analysis": "<div>Pruebas Aprobaciones CAB<br></div>",
"Microsoft_VSTS_Common_Resolution": "<div>Pruebas Aprobaciones CAB<br></div>",
"Custom_3b0630e6-9fe6-459d-aeb9-e7eb5d8062e2": "<div>Pruebas Aprobaciones CAB<br></div>",
"Vsts_AssignedToEmail": "",
"Vsts_WorkItemUrl": "https://xxx.visualstudio.com/_apis/wit/workItems/18209"
}
}
}

[Mira_Ghaly]

@amaurysaldana

I can see that the status is as below:

 

[amaurysaldana]

If manually from the UI it allows me to move and change states, but the drawback is that from the automated flow it presents the error and does not update to the following states "Rejected CAB" or "Approved CAB"

[amaurysaldana]

Fue resuelto el inconveniente, y la solución fue que el usuario de servicio no estaba registrado en un grupo en Azure que tiene los permisos para poder cambiar a esos estados.

Otra cosa también, es que la extensión para manejo de Transición de estados en Azure que descargamos desde el Merkaplace a veces no funciona correctamente y provoca parte del error.

Muchas gracias.