Skip to main content

Notifications

Announcements

No record found.

Calling Actions from Copilot Studio
Unanswered

How to list rows coming back from Connection action response?

Posted on by 18

Hi, 

 

I have created a simple co-pilot in copilot studio, which calls into the Dataverse Virtual entities and I want to display the result in adaptive card Or in mark down. I am unable to find a way to iterate through the response from action and further create the layout for responding back to user. 

 

Currently - i can throw a message there and it just shows json response to user, which isn't readable. 

 

rizworks_0-1704981008300.png

 

Categories:
  • Pranita Profile Picture
    Pranita 2 on at
    Re: How to list rows coming back from Connection action response?

    Similar to you I have also did a same thing. But I'm getting error Error Message: The connector ‘Microsoft Dataverse’ returned an HTTP error with code 400. Error Code: ConnectorRequestFailure

    What can be the scenario?

  • remidyon Profile Picture
    remidyon on at
    Re: How to list rows coming back from Connection action response?

    Hi @rizworks 

    You will have to use the "forAll" instruction from powerFX

     

    Here is an example of an adaptive card fetching a record list and displaying the results:

    {
     type: "AdaptiveCard",
     version: "1.5",
     body: [
     {
     type: "TextBlock",
     text: "My list",
     weight: "bolder",
     size: "large"
     },
     {
     type: "TextBlock",
     text: "Available records:",
     weight: "bolder",
     size: "medium",
     separator: true
     },
     {
     type: "Container",
     items: 
     ForAll(Topic.MyRecordVariable,
     {
     type: "TextBlock",
     text: "- " & recordProperty1 & " (ID:" & recordProperty2 & ")",
     wrap: true
     }
     )
     }
     ]
    }

     

Helpful resources

Quick Links

Exciting News for Copilot Studio Communi…

Get ready to experience a whole new level of engagement with the Copilot Studio…

Celebrating the May Super User of the…

LaurensM is an exceptional contributor to the Power Platform Community…

Check out the Copilot Studio Cookbook…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
renatoromao Profile Picture

renatoromao 6,459

#2
Pstork1 Profile Picture

Pstork1 1,954

#3
Expiscornovus Profile Picture

Expiscornovus 1,648

Featured topics