Skip to main content

Notifications

Announcements

Share Your Journey with Power Pages and Help Shape Its Future!
News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / Issue with Displaying ...
Finance forum
Unanswered

Issue with Displaying Data in Table Format on D365 F&O Copilot's SideCar

(1) ShareShare
ReportReport
Posted on by H.Hassan 69
Hi EveryOne

I am working on displaying my data in table formatI (I use Adpative Card for this) on D365 F&O Copilot's SideCar after creating a topic in Copilot Studio.

My YAML code is:

kind: AdaptiveDialog
beginDialog:
  kind: OnRecognizedIntent
  id: main
  intent:
    triggerQueries:
      - Table Format
  actions:
    - kind: SetVariable
      id: setVariable_E91nKn
      variable: Topic.ListData
      value: "{   \"endDate\": \"6/30/2024\",   \"isResponse\": true,   \"startDate\": \"6/1/2024\",   \"unpostedJournals\": [     {       \"Batch Number\": \"25136\",       \"Name\": \"GenJrn\",       \"Description\": \"General Journal\",       \"Date\": \"06/26/2024 00:00:00\"     },     {       \"Batch Number\": \"25139\",       \"Name\": \"IntJrn\",       \"Description\": \"Intercompany Journal\",       \"Date\": \"06/30/2024 00:00:00\"     },     {       \"Batch Number\": \"25140\",       \"Name\": \"IntJrn\",       \"Description\": \"Test description\",       \"Date\": \"06/10/2024 00:00:00\"     }   ] }"
    - kind: ParseValue
      id: 1nX2rj
      variable: Topic.parseListData
      valueType:
        kind: Record
        properties:
          endDate: String
          isResponse: Boolean
          startDate: String
          unpostedJournals:
            type:
              kind: Table
              properties:
                Batch Number: String
                Date: String
                Description: String
                Name: String
      value: =Topic.ListData
    - kind: SendActivity
      id: sendActivity_cLjUwq
      activity:
        attachments:
          - kind: AdaptiveCardTemplate
            cardContent: |-
              ={
               
                type: "AdaptiveCard",
                version: "1.3",
                body: [
                  {
                    type: "TextBlock",
                    text: "Unposted Journals",
                    weight: "Bolder",
                    size: "Medium"
                  },
                  {
                    type: "ColumnSet",
                    columns: [
                      {
                        type: "Column",
                        width: "stretch",
                        items: [
                          {
                            type: "TextBlock",
                            text: "Batch Number",
                            weight: "Bolder",
                            wrap: true
                          }
                        ]
                      },
                      {
                        type: "Column",
                        width: "stretch",
                        items: [
                          {
                            type: "TextBlock",
                            text: "Name",
                            weight: "Bolder",
                            wrap: true
                          }
                        ]
                      },
                      {
                        type: "Column",
                        width: "stretch",
                        items: [
                          {
                            type: "TextBlock",
                            text: "Description",
                            weight: "Bolder",
                            wrap: true
                          }
                        ]
                      },
                      {
                        type: "Column",
                        width: "stretch",
                        items: [
                          {
                            type: "TextBlock",
                            text: "Date",
                            weight: "Bolder",
                            wrap: true
                          }
                        ]
                      }
                    ]
                  },
                  {
                    type: "Container",
                    items: 
                    ForAll(Topic.parseListData.unpostedJournals,
                        {
                        type: "ColumnSet",
                        data: "${unpostedJournals}",
                        columns: [
                          {
                            type: "Column",
                            width: "stretch",
                            items: [
                              {
                                type: "TextBlock",
                                text: 'Batch Number',
                                wrap: true
                              }
                            ]
                          },
                          {
                            type: "Column",
                            width: "stretch",
                            items: [
                              {
                                type: "TextBlock",
                                text: Name,
                                wrap: true
                              }
                            ]
                          },
                          {
                            type: "Column",
                            width: "stretch",
                            items: [
                              {
                                type: "TextBlock",
                                text: Description,
                                wrap: true
                              }
                            ]
                          },
                          {
                            type: "Column",
                            width: "stretch",
                            items: [
                              {
                                type: "TextBlock",
                                text: Date,
                                wrap: true
                              }
                            ]
                          }
                        ]
                      }
                    
                 ) }
                ]
              }
After publishing this, when I entered "Table Format" (the question I asked in Copilot's SideCar), it returns an empty message instead of a table.


Is there anyone who can help me understand why I am getting an empty message in response? Or can anyone tell me if there is a different way to get a table format via Copilot Studio?

Thanks in advance.

Categories:
Development / Customization / SDK
  • H.Hassan Profile Picture
    H.Hassan 69 on at
    Issue with Displaying Data in Table Format on D365 F&O Copilot's SideCar
    Hi,

    Thank you for updating me about this

     

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,524 Super User 2024 Season 2 on at
    Issue with Displaying Data in Table Format on D365 F&O Copilot's SideCar
    Hi H.Hassan,

    A small update. In the new preview of 10.0.41, adaptive cards are supported.
  • H.Hassan Profile Picture
    H.Hassan 69 on at
    Issue with Displaying Data in Table Format on D365 F&O Copilot's SideCar

    Oh, I have been facing this issue for a long time. Thank you very much for verifying this with Microsoft.

    Thanks for creating the post and updating me about it.

    Since Adaptive Card is not supported in this version, I must need to display my data in table format. Is there any other way to display my data in table format on the D365 F&O Copilot's SideCar?
     

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,524 Super User 2024 Season 2 on at
    Issue with Displaying Data in Table Format on D365 F&O Copilot's SideCar
    A reply from Microsoft on adaptive cards. This is currently not supported. This will be added in version 10.0.41.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,524 Super User 2024 Season 2 on at
    Issue with Displaying Data in Table Format on D365 F&O Copilot's SideCar
    I created the question on Viva Engage. Note that it requires a login to be able to see the details: https://www.yammer.com/dynamicsaxfeedbackprograms/threads/2877413344509952
     
    When someone is interested, you can sign up for feedback forums using this link: https://experience.dynamics.com/insider
  • H.Hassan Profile Picture
    H.Hassan 69 on at
    Issue with Displaying Data in Table Format on D365 F&O Copilot's SideCar
    Hi,
    Yes, please create a post in  feedback group on Viva Engage (Yammer) regarding this issue. Kindly provide me the link so I can follow up as well. I have asked my infra team to create Microsoft ticket for this but it takes so much time.

    Thanks in advance
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,524 Super User 2024 Season 2 on at
    Issue with Displaying Data in Table Format on D365 F&O Copilot's SideCar
    Hi,

    I just tested this on the F&O copilot sidecar. I have the same behavior as you see. There is no table presented. Are you able to verify this with Microsoft? If not, I can create a post on a feedback group in Viva Engage (aka Yammer).
  • H.Hassan Profile Picture
    H.Hassan 69 on at
    Issue with Displaying Data in Table Format on D365 F&O Copilot's SideCar
    Hi,
    Thank you for verifying the adaptive card in your environment.

    I would like to ask if you tested this on the D365 F&O Copilot's SideCar. In my case, it works fine in the testing Copilot environment (I created it on a different Copilot where the testing environment functions correctly). However, for Copilot for Finance and operation (the testing environment is not working, so I couldn't test on Copilot for Finance and Operations), the adaptive card is not visible in the D365 F&O Copilot's SideCar upon publishing.

    Regarding the previous client errors when opening the D365 F&O SideCar, I have resolved the issue. It was related to the datatype of the input parameter (used for saving user-entered data in Copilot SideCar) in the X++ code.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,524 Super User 2024 Season 2 on at
    Issue with Displaying Data in Table Format on D365 F&O Copilot's SideCar
    Great, I was using another editor. Now it works. I created a completely new Copilot and triggered this card. It gives a table in my environment.

     
    Have you tried the same in an empty Copilot solution instead of within the Copilot for Finance and Operations? Maybe it is related to some issues where testing was not working and I think you also had some client errors when opening F&O sidecar. 
    At least the adaptive card coding seems to be OK.
  • H.Hassan Profile Picture
    H.Hassan 69 on at
    Issue with Displaying Data in Table Format on D365 F&O Copilot's SideCar
    Hi,
    I have sent the YAML code. Could you please copy and paste it using the 'Open in editor' feature in your Copilot Studio environment?

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Share Your Journey with Power Pages and Help Shape Its Future!

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans