Power Platform Community Forum Thread Details

Using the Microsoft CoPilot Studio Canvas I have started to build a topic that makes a query to a SQL Server Table, I am successfully returning data from the query using a Execute a SQL Query v2 node

I then output the results to the agent to confirm that I actually have something with

This returns the following whcih is stored in sqlResult as a record.

{"OutputParameters":{},"ResultSets":{"Table1":[{"Issue":"Issue 1"},{"Issue":"Issue 2"},{"Issue":"Issue 3"}]}}

However, I'm struggling to turn this into a table so I can populate my choices in the ACE card.

Following the guidance I have created a Set Variable node and called it IssueChoices which is a Table.

I have added the following formula to extract all of the Issues

I then try and display the value of IssueChoices

When displayed I just get the text and no value.

One thing that I have noticed is that in the sqlResult record the RecordSets has an upper case R and S whereas the function only allows me to use the Topic.sqlResult.recordsets value and throws an error if I try and use RecordSets.

I'm then planning on updating the ACE card choices to this Variable so the choices are dynamically populated.

Any pointers greatly appreciated.

Categories:

General topics

@RI-13061750-0

I've tried copying your sql result data in a variable, and could dynamically populate Adaptive card with those choices. Provided step by step approach below.

Output: