Unanswered

Action from Power Automate expecting Table but output is string

(0) Share

Report

Posted on by Rafael_Diaz

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

here is the output of the Power Automate flow

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

Categories:

Topic creation & management

I have the same question (0)

All responses (4)

Answers (0)

Sort by

VauBee 17 Moderator on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
HenryJammes Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
Rafael_Diaz 2 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
AH-30071754-0 2 on at

Like (0)

Report
Copy link

Link copied!

Did you find solution?

Thanks,
Amar.

Was this reply helpful? Yes No