web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Strange Data Type Mism...
Copilot Studio
Suggested Answer

Strange Data Type Mismatch Error when calling Power Automate cloud flow from Copilot Studio Agent

(0) ShareShare
ReportReport
Posted on by 2
Hi there,
 
I'm calling a cloud flow called ReadCustomerList from a Copilot Studio agent.  The cloud flow works great and is triggered as a standard API.  I select the flow in Copilot Studio, it gives me the right inputs and outputs (see below):
 
The "List" variable which is just a JSON blob gets returned from the flow.  When I run, everything seems to work fine but then I get the following error message:
 
Error Message: The parameter with name 'Messages' on flow 'ReadCustomerList' ('35f30234-7933-ed11-9db1-000d3a381ab5') evaluated to type 'TableDataType' , expected type 'TableDataType' Error Code: FlowActionBadRequest Conversation Id: a9294bf3-bad5-419b-a833-c8560382f80d Time (UTC): 2026-02-02T21:44:48.724Z
 
It's strange because it says it's expecting TableDataType and not getting a TableDataType.  
 
I'm wondering why Copilot isn't picking this up as a table?  Do I need to do some sort of formatting or parsing?
 
This is the JSON that gets returned:
{
"List": [
{
"Customer": "1992",
"Country": "GB",
"Name": "IDES UK",
"City": "London",
"PostalCode": "L3B 6H7",
"Street": "",
"Region": "GM"
},
{
"Customer": "3500",
"Country": "GB",
"Name": "Hever Industrial UK",
"City": "High Wycombe",
"PostalCode": "HP12 3TL",
"Street": "",
"Region": "HA"
},
{
"Customer": "301417",
"Country": "GB",
"Name": "UK Systems",
"City": "",
"PostalCode": "",
"Street": "",
"Region": ""
}
],
"Messages": [
{
"Message": "3 customer(s) found based on your search criteria."
}
]
}
I have the same question (0)
  • Suggested answer
    sandeep_angara Profile Picture
    426 Moderator on at
    The total JSON is enclosed in { } so it treats it as a record. Try extracting List [] or Messages [] from this JSON. Those are the arrays (collection of records) which are compatible with Table data type.
     
  • ChrisProcessAI Profile Picture
    2 on at
    hi @sandeep_angara thanks for this - how do I extract from the JSON?  Which operation do I use in the cloud flow?

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 161

#2
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 130 Super User 2026 Season 1

#3
Arild Aarnes Profile Picture

Arild Aarnes 61 Super User 2026 Season 1

Last 30 days Overall leaderboard