The results of a query to MSSQL is array of objects where the property names are the field names.
Try changing your query to something like select count(*) as RowCount from myTable
Also, instead of selecting text in the debug panel, please use the copy value button that appears under your mouse cursor when you hover over the payload in the debug window. And please use the code button when pasting code/data into the forum.
Canned replies...
Canned reply 1...
in order to make code more readable and importable it is important to surround your code with three backticks
```
like this
```
See this post for more details - How to share code or flow json
Canned reply 2...
There’s a great page in the docs that will explain how to use the debug panel to find the right path to any data item.
Pay particular attention to the part about the buttons that appear under your mouse pointer when you over hover a debug message property in the sidebar.
