Power Platform Community Forum Thread Details

Hi All,

I am trying to create JSON array out of the user responses. How can we do that in Copilot studio?

Any help will be much appreciated!

Thank you.

Categories:

Bot administration

Hi VS-07011110-0,

Create a prompt action in Copilot Studio to gather input from the user.

Use a structured approach to capture multiple responses, such as using placeholders or asking sequential questions.

Use the input from the user and structure it into JSON format.

Define a backend or inline function to parse and store the responses dynamically.

function createJsonArray(responses) {
const jsonArray = responses.map(response => ({
key: response.key,
value: response.value
}));
return JSON.stringify(jsonArray);
}

Use an Action in Copilot Studio to concatenate or structure the responses into a JSON array dynamically.

[
{
"name": "John Doe",
"email": "johndoe@example.com",
"phone": "123-456-7890"
},
{
"name": "Jane Smith",
"email": "janesmith@example.com",
"phone": "987-654-3210"
}
]

save it to a database, or send it to an API endpoint.

pls try and let me know if you need more details.