web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Incorrect formatting o...
Power Automate
Unanswered

Incorrect formatting of MS Form response

(0) ShareShare
ReportReport
Posted on by 8
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.
 
Categories:
I have the same question (0)
  • Suggested answer
    Expiscornovus Profile Picture
    33,175 Most Valuable Professional on at
    Incorrect formatting of MS Form response
    You can use a Select action to convert it to the correct format. In the from you can use a json function to convert the string array value to an array. In the Map you can add the value key.
     
    Below is an example
     
    From field
    json(outputs('Get_response_details')?['body/r9eb31da20fa5487dbd01410d8524f5d2'])
    In the key column of the Map field use value. 
     
    In the value column of the Map field use
    item()
     
     
    The test result
     
  • AM-04111848-0 Profile Picture
    8 on at
    Incorrect formatting of MS Form response
    Hi Expiscornovus, thanks for the response.
    However, I see the below response after implementing the function as suggested. Could you please advise.
     
  • AM-04111848-0 Profile Picture
    8 on at
    Incorrect formatting of MS Form response
    I managed to get the response in the right format. 
     
    Thanks for the help.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard