Power Platform Community Forum Thread Details

I'm building a chatbot and I want to generate a dynamic list of questions - but it won't accept the user response, it just returns MissingDisplayName (even though my table only has DisplayName in it).

Let me outline the steps and see if anyone can help me:

My chatbot calls out to a Power Automate flow, which returns the following string (Not included everything but don't think I need to - the body returned is the important thing)

-

    "body": {

        "tablevalues": "[{\"DisplayName\":\"Meeting Our Energy Needs\"},{\"DisplayName\":\"Fixing the Housing Market\"},{\"DisplayName\":\"Social Care\"},{\"DisplayName\":\"Reforming Football Club Governance\"}]"

    }

}
When I get this sting back in, I then parse it and convert it into a table variable (varConvertedFlow):
I then stick the variable into a question box and I get the following error:

Now this confuses me because the ONLY thing that I have in the table variable is the Display Name?!

I then started to question the output of the table - so I added varConvertedFlow to the question to see what it looked like after I had parsed it. This is the output:

- [{"DisplayName":"Meeting Our Energy Needs"},{"DisplayName":"Fixing the Housing Market"},{"DisplayName":"Social Care"},{"DisplayName":"Reforming Football Club Governance"}]

This looks good to me, so I then created a new variable (varManualProjects) using the above JSON:

I then stick this table variable (varManualProjects) into my question step and.....

It works?!! What the Duce?!

I then stuck the two variables (varConvertedFlow and varManualProjects) into the question to see if there is anything different between the two.... and they look identical:

So clearly I'm doing something wrong..... but I don't understand why the converted return from flow works differently to the manually created variable when they appear to be identical?

Categories:

General topics