Skip to main content

Notifications

Copilot Studio - Topic Creation & Management
Unanswered

Action from Power Automate expecting Table but output is string

(0) ShareShare
ReportReport
Posted on by 2

I am trying to get a list of project from an HTTP request in power automate and use the return as a "database" to search my followup question.

 

When the Action is called and Power Automate fires i get the following error on the return

 

evaluated to type ‘TableDataType’ , expected type ‘StringDataType’ Error Code: FlowActionBadRequest

 

and the flow does not even get to the Parse value

Rafael_Diaz_0-1709156080262.png

Rafael_Diaz_1-1709156093609.png

 

 

here is the output of the Power Automate flow

Rafael_Diaz_2-1709156151911.png

 

raw outpuy

 

 

{
 "statusCode": "200",
 "schema": {
 "type": "object",
 "properties": {
 "json": {
 "title": "JSON",
 "type": "string",
 "x-ms-content-hint": "TEXT",
 "x-ms-dynamically-added": true
 }
 },
 "additionalProperties": {}
 },
 "body": {
 "json": [
 {
 "project name": "check floating culvert",
 "project responsible": "ABC",
 "lead engineer": "ABC"
 },
 {
 "project name": "transportation East Coast USA",
 "project responsible": "ABC",
 "lead engineer": "ABC"
 },
 {
 "project name": "Cost optimization",
 "project responsible": "ABC",
 "lead engineer": "ABC"
 },
 {
 "project name": "Lab",
 "project responsible": "ABC",
 "lead engineer": "ABC"
 }
 ]
 }
}

 

 

 

  • AH-30071754-0 Profile Picture
    AH-30071754-0 2 on at
    Action from Power Automate expecting Table but output is string
    Did you find solution?

    Thanks,
    Amar.
  • Rafael_Diaz Profile Picture
    Rafael_Diaz 2 on at
    Re: Action from Power Automate expecting Table but output is string

    I Solved it by stringifying my JSON in the power automate output string(output_to_pva). and then converting it back to JSON in Copilot studio

  • HenryJammes Profile Picture
    HenryJammes on at
    Re: Action from Power Automate expecting Table but output is string

    That's odd @Rafael_Diaz , @VauBee 

    You should be able to return JSON as a string without compose actions from Power Automate, and then do your parsing. When you test, can you check what the value is for the json variable? (in the Variables > Test pane)

  • VauBee Profile Picture
    VauBee 17 on at
    Re: Action from Power Automate expecting Table but output is string

    Hi @Rafael_Diaz ! Looks like you need to convert the list of projects into a single string before passing it to subsequent actions. Maybe this would be a workaround:

    • Use “Parse JSON” to parse the raw output from your HTTP request.
    • Extract the relevant project details (e.g., project name, responsible, lead engineer) from the parsed JSON.
    • Concatenate these details into a single string (e.g., using the “Compose” action).
    • Pass this string to subsequent actions in your flow.

    Assuming you want to create a comma-separated list of project names, the following expression in the “Compose” action shoudl work:

     

    join(outputs('Parse_JSON')?['body']?['json'], ', ')

     

     

    ------------------------------------------------------------------------------------------------------------------------------
    If I have answered your question / helped to solve your problem, please accept as solution and give me a Thumbs up. Thanks! - Remember: you can accept more than one post as a solution.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

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

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard

Featured topics