There are two ways you can use. The first one is to create an Action, in my case i used the action Dataverse - List all rows from selected environment, added it and then configured its Input by adding the Environment, Table and as an extra i added the Select Columns in which i set as value the logical name of my table (the table i wanted to list the data from). Then in my Topic i added an action > Call an Action > (Tab) Plugin (Preview) and from there i picked the Action i created. In the newly created action i added an output variable in order to store the results in there and i looped through this Variable using the Foreach which i found from here:
https://github.com/pnp/powerplatform-snippets/tree/main/copilot-studio/foreach-topic/
My code looks like this:
- kind: BeginDialog
id: blahblah
input: {}
dialog: BotName.component.MicrosoftDataverse-Listrowsfromselectedenvironment
output:
binding:
value: Topic.DealerOutput #The variable i created to store the results
- kind: Foreach
id: TamaGa
items: =Topic.DealerOutput
value: Topic.CurrentDealer
actions:
- kind: SendActivity
id: OZIkYY
activity: "{Topic.CurrentDealer.dataverseTableLogicalName}"
This concludes my first approach. Now, for the second way i found which in my opinion is more straightforward.
I used a Connector Action as shown below. (In my case i added the List rows from selected environment)
With this approach you can add an OData query for more complex results.
I wanted to calculate the average of the numeric values from four different columns and find which has score less than 4.90 and fetch the value and the dealer which has this value.

*The above is a different print screen to demonstrate how you can make use of the Filter Rows in a more simple way*
For my case, i left the Filter Rows empty and just inserted my columns in the Select Columns section and then i created a variable which calculates the Average.
Below a screenshot and the code i used to create it.
- kind: Foreach
id: vtX27Cad
items: =Topic.AverageFinalCount
value: Topic.CurrentDealer
actions:
- kind: SetVariable
id: CalculateAverage
variable: Topic.CalculateAverage
value: |
=(
(Topic.CurrentDealer.cr3ab_en1_finalcount +
Topic.CurrentDealer.cr3ab_en2_finalcount +
Topic.CurrentDealer.cr3ab_en3_finalcount +
Topic.CurrentDealer.cr3ab_en4_finalcount) / 4
)
- kind: ConditionGroup
id: conditionGroup_wodrIv
conditions:
- id: conditionItem_gnBiL0
condition: =Topic.CalculateAverage < 4.9
actions:
- kind: SendActivity
id: wzTSVK
activity: "**Dealer Code: {Topic.CurrentDealer.cr3ab_dealer_code}, Average Score: {Topic.CalculateAverage}"