Unanswered

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!

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (1)

Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (3)

Report

I suspect you are setting the From to Body. You should also have access to Value in the dynamic content. Value is the array, Body is an object that has the array as a property.

Was this reply helpful? Yes No
David Brandman 294 on at

Like (0)

Report

That did it! Thanks SOOOO much! Brilliant.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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!!

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

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.

Was this reply helpful? Yes No
sachk1 258 on at

Like (0)

Report

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

@Pstork1

Was this reply helpful? Yes No
mguzmanBSC_2023 27 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
MD10239 2 on at

Like (0)

Report

its not clear ca you please elaborate

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Mikegrc1970 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No