Power Platform Community Forum Thread Details

Hi,

I want to expose a list of records (name only) from a dataverse table as a multiselect choice to the user in copilot studio chatbot. The user must be able to select multiple records. The selected records will then be related to the user's account record in dataverse. Is that possible?

thanks very much,

Seán

Categories:

Topic creation & management

Hi Sean,

This is an Interesting requirement.

I have not done this. But i can give some idea if that can help you.

To Retrieve dataverse records, You can use Power Automate to query records (names) dynamically from a table.
After the List Rows action, add a Compose or Select action to create the JSON payload for the adaptive card's choices. Use an expression to transform the list of records into a suitable JSON format.
Create an Adaptive Card JSON template similarly and use the output from Power Automate to populate the choices. Explore the Adaptive Card Actions inside Power Automate.
You can display as multi-select adaptive card. The records are dynamically populated in the adaptive card as selectable options with the Input.ChoiceSet field and the isMultiSelect: true flag.
Then you can display the card to the user.
After the user selects records and submits the card, the bot can capture the selected options.
Finally, again use Power Automate to link the selected records to the user’s account or any action that you require.

(Addition to Point 2) - Dynamically create an array of objects where each object has a title (to display) and a value (the ID or identifier) like the below sample.