Answered

The 'from' property value in the 'select' action inputs is of type 'String'. The value must be an array.

(0) Share

Report

Posted on by David Brandman

294

Using a 'Transform data using Power Query' to get and manipulate data from SQL. I then run 'Parse JSON'. That all works, but it appears the data format coming out of the Parse JSON is not what the next step ('Select') requires, as I am getting:

The 'from' property value in the 'select' action inputs is of type 'String'. The value must be an array.

This is happening in the 'Select' action.

The Parse JSON Schema is:

"type": "object",

"properties": {

"resultType": {

"type": "string"

"value": {

"type": "array",

"items": {

"type": "object",

"properties": {

"FULLNAME": {

"type": "string"

"Transaction Date": {

"type": [

"string",

"null"

]

"Client": {

"type": "string"

"Project": {

"type": "string"

"Phase": {

"type": "string"

"Description": {

"type": "string"

"Hours": {

"type": "number"

"Amount to Pay": {

"type": "number"

}

"evaluationUsage": {}

}

The Body of the Parse JSON is:

The Select action returns:

Not sure how to correct. Any help would be greatly appreciated. Thanks!

All responses (11)

Answers (1)

comsys 73 on at

Like (0)

Report

Re: The 'from' property value in the 'select' action inputs is of type 'String'. The value must be an array.

What solved this for me was this syntax json(body('HTTP_-_Get_Content_Blob')) in place of just getting the Body. Note this will vary on what your Http Body Action Name is this one was named "HTTP - Get Content Blob"
I add this as the answer was not specific enough in my case.
Mikegrc1970 2 on at

Like (0)

Report

Re: The 'from' property value in the 'select' action inputs is of type 'String'. The value must be an array.

Hi I'm having the same error, Im new using this app
this what i get

{
"Row": [
{
"UPC": "008811015055",
"UPC.urlencoded": "%3B%23008811015055%3B%23",
"UPC.singleurlencoded": "008811015055",
"UPC.COUNT.group": "2",
"UPC.newgroup": "1",
"UPC.groupindex": "1_",
"QtyOredered.SUM": "11",
"QtyOredered.SUM.agg": "7"
},
{
"UPC": "008811015056",
"UPC.urlencoded": "%3B%23008811015056%3B%23",
"UPC.singleurlencoded": "008811015056",
"UPC.COUNT.group": "1",
"UPC.newgroup": "1",
"UPC.groupindex": "2_",
"QtyOredered.SUM": "11",
"QtyOredered.SUM.agg": "4"
}
],
"FirstRow": 1,
"FolderPermissions": "0x7ffffffffffbffff",
"LastRow": 2,
"RowLimit": 30,
"FilterLink": "?",
"ForceNoHierarchy": "1",
"HierarchyHasIndention": "",
"CurrentFolderPrincipalCount": "0",
"CurrentFolderSpItemUrl": ""
}
Pstork1 67,060 Most Valuable Professional on at

Like (0)

Report

Re: The 'from' property value in the 'select' action inputs is of type 'String'. The value must be an array.

Please post this as a new question. You'll get more responses and others will be able to find the answer more easily later.
MD10239 2 on at

Like (0)

Report

Re: The 'from' property value in the 'select' action inputs is of type 'String'. The value must be an array.

its not clear ca you please elaborate
Pstork1 67,060 Most Valuable Professional on at

Like (0)

Report

Re: The 'from' property value in the 'select' action inputs is of type 'String'. The value must be an array.

It looks to me like the error occurs if you hit an item with no comments (null). In that case you have to test for that scenario and do something different if there are no comments.
mguzmanBSC_2023 27 on at

Like (0)

Report

Re: The 'from' property value in the 'select' action inputs is of type 'String'. The value must be an array.

Hi @Pstork1 ,

Per @sachk1 response, I'm getting the same error.
The 'from' property value in the 'select' action inputs is of type 'Null'. The value must be an array.

I'm trying to retrieve comments with @mentions to display name, comment and date from this article. Here is my flow. What step am I missing?

I appreciate any assistance.

Thanks!
sachk1 258 on at

Like (0)

Report

Re: The 'from' property value in the 'select' action inputs is of type 'String'. The value must be an array.

I have face the same issue.
whats the mistake done?

@Pstork1
Pstork1 67,060 Most Valuable Professional on at

Like (1)

Report

Re: The 'from' property value in the 'select' action inputs is of type 'String'. The value must be an array.

Please post this as a new question. You'll get more responses and other people will be able to find the answer if they have similar questions. After re-posting send me a link and I'll take a look and try to help.
Community Power Pla... on at

Like (0)

Report

Re: The 'from' property value in the 'select' action inputs is of type 'String'. The value must be an array.

Hello @Pstork1 ! maybe you can help me with my code as I suspect it is happening something similar. The message that appears in my case is:
The 'from' property value in the 'select' action inputs is of type 'Null'. The value must be an array.

And this is my code:
ACTION 1
{
    "kind": "ApiConnection",
    "splitOn": "@triggerBody()['rows']",
    "inputs": {
        "schema": {
            "type": "object",
            "properties": {
                "rows": {
                    "type": "array",
                    "items": {
                        "type": "object",
                        "properties": {
                            "entity": {
                                "type": "object",
                                "properties": {
                                    "Power BI values": {
                                        "title": "Tabla de Power BI",
                                        "type": "array",
                                        "items": {
                                            "type": "object",
                                            "properties": {
                                                "LOGIN": {
                                                    "title": "Tabla de Power BI LOGIN",
                                                    "type": "string"
                                                }
                                            },
                                            "required": []
                                        }
                                    }
                                },
                                "required": [
                                    "Power BI values"
                                ]
                            }
                        },
                        "required": [
                            "entity"
                        ]
                    }
                }
            },
            "required": [
                "rows"
            ]
        },
        "host": {
            "connection": {
                "name": "@parameters('$connections')['shared_powerbi']['connectionId']"
            }
        },
        "operationId": "PowerBiButtonClicked",
        "parameters": {
            "inputsPowerBiData": "{}",
            "pbi_source": "powerAutomate"
        }
    },
    "metadata": {
        "operationMetadataId": "cd9e23f6-6b1c-4a37-ac2a-452498873285"
    }
}

ACTION 2 (IT IS THE ONE FAILING):
{
    "inputs": {
        "from": "@triggerBody()?['entity']?['Power BI values']",
        "select": {
            "AA": "@item()?['LOGIN']"
        }
    },
    "metadata": {
        "operationMetadataId": "e99b8e2c-9c66-4016-b089-10401875672f"
    }
}

Thank you so much for your help!!
David Brandman 294 on at

Like (0)

Report

Re: The 'from' property value in the 'select' action inputs is of type 'String'. The value must be an array.

That did it! Thanks SOOOO much! Brilliant.