Hi folks
I'm using a KQL query connector action in a topic, receiving a record type output.
{
"value": [
{
"Count": 121,
"IsAtRisk": 0,
"IsFailed": 0,
"IsSev2": 0,
"Status": "ACTIVE"
},
{
"Count": 22,
"IsAtRisk": 1,
"IsFailed": 0,
"IsSev2": 0,
"Status": "ACTIVE"
}
]
}
I can display this just fine as a message, it will be displayed as a string. Of course it's not really pretty. So I want to convert it either to
- a simple string so I can parse it into a flow for formatting, then returning a text string.
- a formatted message/table, possibly using an adaptive card or other means without the need for a flow. (preferred)
I've been trying converting using Text(), JSON(), within variables and without, and a million other things, but I'm always running into errors. For example:
- When using Text(): Expected text or number. We expect text or a number at this point in the formula.
- When using a flow: There is an error: 'BindingIncorrectTypeError'
In Logic Apps / Power Automate Flows it's so easy to convert data types, but in Copilot it seems quite complicated. I appreciate the help!