Generative Answers Variable issues inside copilot studio

(0) Share

Report

Posted on by VY-13120534-0

I’m trying to extract two values example name and city (from userinput message) from a Generative Response JSON using ParseJSON(), but Copilot Studio keeps throwing ‘JSON could not be parsed’ even though the formula validates. Has anyone solved this issue where the runtime value includes hidden extra characters and breaks JSON parsing?

which is in key value par
{"name": "Microsoft", "City": "NYC"}

so extracting it using Text(ParseJson(topic.agentextractedvalue).Name)

can someone help me on this?

Categories:

Building Copilot Studio chatbots in Microsoft Teams

Screenshot 2025-1...

I have the same question (0)

All responses (3)

Answers (0)

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report

HI @VY-13120534-0

Can you share the actual input from the user, what it looks like from the Activities tab.

Does it ever work? Are you getting this in the designer or at real published run time?

Was this reply helpful? Yes No
VY-13120534-0 on at

Like (0)

Report
this is the error message i am getting.

I wrote this prompt

You are an AI assistant that extracts structured data from user input.

UserText:

Activity.Text

string

Extract the following values if present:

ProjectArea

RequestType

Return the result in JSON format like this:

{Topic.ProjectArea}: " ",
{Topic.RequestType}: " "

If a value is missing, leave it as an empty string.
inside prompt session of generative answers

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report

Hi @VY-13120534-0

This is not valid JSON and it depends on if you want it to be two properties of a single or separate things

{Topic.ProjectArea}: " ",
{Topic.RequestType}: " "

This is valid JSON
{

"Topic.ProjectArea": "",

"Topic.RequestType": ""

}

or even

[

{

"Topic.ProjectArea": "",

"Topic.RequestType": ""

}

]

But what you pasted is not.

Also have you thought about making them Entities so they are easily extracted?

OH And it looks like you are placing Topic.XXX where the JSON name should be, but that would make it Dynaimc, which ... I don't know of that is ok or not because its going to actually put a value.

What I mean is

If Topic.ProjectArea is = "Boo" then you are going to have Boo = "", is that what you really want, or do you want the actual value that was returned to be set equal to a Name called "Topic.ProjectArea", or are you trying to set a variable value? which again would look like Boo = "something" and not sure how that makes sense.

If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

Thank you!
Sincerely, Michael Gernaey

Was this reply helpful? Yes No