We are trying to use Power Automate to raise a ticket in JIRA using the values in MS Forms response. We are using the HTTP Connector and utilizing JIRA REST API to do the same.
One of the fields in the MS Form is a "Multi-select" and we tried to map this to a custom field in JIRA (also multi-select), and the payload structure is as expected by JIRA. However, the response from the MS Form has some characters which are not accepted by JIRA. I have tried split, replace functions as well but the issue is still there.
This is the raw output body of the response from the form.
"body": {
"responder": "abc@abc.com",
"submitDate": "11/4/2024 3:09:59 PM",
"r411ed29bec5b4f6e962b2ece0a14d6ac": "",
"r5af2a2d9d4c94dddb4cff8ce09c1f171": "test",
"r29c673c0223340659c93089e699c203b": "test",
"r9eb31da20fa5487dbd01410d8524f5d2": "[\"value1\",\"value2\"]",
"r367f2f7858264d689c0da1447ebb515a": "ABC",
"r297efb80d36d4dd3a6db1f2ae74fa647": "Test CoA Field"
}
This is the payload created dynamically.
"customfield_xxxxxx": [
{
"value": "\"value1\""
},
{
"value": "\"value2\""
}
]
However, JIRA expects this in the below format.
"customfield_xxxxxx": [
{
"value": "value1"
},
{
"value": "value2"
}
]
Any guidance from the community would be appreciated.
