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

(1) Share

Report

Posted on by H.Hassan

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.

I have the same question (0)

All responses (16)

Answers (0)

André Arnaud de Cal... 299,407 Super User 2025 Season 2 on at

Like (0)

Report

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

Hi,

I think you created another question where we discussed some logging and telemetry. You can try to enable the application insights to check log details and see what might be wrong. I'm not able to read YAML code.

Was this reply helpful? Yes No
H.Hassan 85 on at

Like (0)

Report

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

Hi André Arnaud,
here is my YAML Code:

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
}
]
}
]
}

) }
]
}

Was this reply helpful? Yes No
André Arnaud de Cal... 299,407 Super User 2025 Season 2 on at

Like (0)

Report

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

Hi,

The YAML code was visible, but I'm not able to understand the contents of it. That is what I meant with not able to read.

Was this reply helpful? Yes No
H.Hassan 85 on at

Like (0)

Report

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

Hi André Arnaud,
Oh Okay I thought YAML Code is not visible.
Basically, I am starting with the text "Table Format" (user enters this on SideCar). Then I create a variable named ListData and pass dummy JSON to it, which is:

{
"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"
}
]
}

Then, I parse this and name the variable parseListData. After that, I create an Adaptive Card to display this dummy data in a table format, but I get an empty message in response on D365 F&O Copilot's SideCar.

Adaptive Card:
- 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
}
]
}
]
}

) }

Was this reply helpful? Yes No
André Arnaud de Cal... 299,407 Super User 2025 Season 2 on at

Like (0)

Report

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

A simple copy and paste is not working in my Copilot Studio environment. The adaptive card is then full of errors. Are you able to isolate this in a new Copilot, export it, and send it over?

Was this reply helpful? Yes No

H.Hassan

85 on at

Like (0)

Report

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

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
                              }
                            ]
                          }
                        ]
                      }
                    
                 ) }
                ]
              }

Was this reply helpful? Yes No

H.Hassan 85 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
André Arnaud de Cal... 299,407 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
H.Hassan 85 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
André Arnaud de Cal... 299,407 Super User 2025 Season 2 on at

Like (1)

Report

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).

Was this reply helpful? Yes No