Getting an error msg after pulling data from Excel

[Tak103]

I have an Excel spreadsheet that based on user's selection to pull the data (table) from different tabs. All the data in the tabs are define as tables. It was able to pull the first tab and then Filter Array without any issues but when I want to get the data from the second tab, I got the below msg on the Filter Array: "The 'from' property value in the 'query' action inputs is of type 'Null'. The value must be an array".  I checked the Excel and the column and rows are define as tables (just like the first tab). So not sure what the issue is. Appreciate some guidance.  Thanks,

[jinivthakkar]

@Tak103 as the error suggests, some value is null, please check the output of previous step and find which value is null. It expects a array but your value is null hence the issue.

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[Tak103]

Hi:

I did check the results in pulling the data from the Excel table and did not see any null in the fields. Pasted the entire output if this will help.  Thanks again

{

    "statusCode": 200,

    "headers": {

        "Pragma": "no-cache",

        "Vary": "Accept-Encoding",

        "x-ms-request-id": "f476423b-5e78-4ffe-a73c-d2654fd73279;9063f2a7-dd89-4ac3-b7b4-937e0c148523;72d3ee2a-d899-49ea-8a09-03ad9286225e;df7afa4d-6074-40c5-a54a-ec71796ffe73",

        "OData-Version": "4.0",

        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",

        "X-Content-Type-Options": "nosniff",

        "X-Frame-Options": "DENY",

        "Timing-Allow-Origin": "*",

        "x-ms-apihub-cached-response": "true",

        "x-ms-apihub-obo": "true",

        "Cache-Control": "no-store, no-cache",

        "Date": "Thu, 03 Feb 2022 13:31:57 GMT",

        "Content-Type": "application/json; odata.metadata=minimal; odata.streaming=true",

        "Expires": "-1",

        "Content-Length": "2043"

    },

    "body": {

        "@odata.context": "https://excelonline-wus.azconn-wus.p.azurewebsites.net/$metadata#drives('b%2134uj2S5tgEiYp8Rh901cRRV...",

        "value": [

            {

                "@odata.etag": "",

                "ItemInternalId": "d3750cd3-8b33-46b8-a048-e68ae4ffb7d6",

                "Question": "Insurance 1",

                "Answer": "Answer 1"

            },

            {

                "@odata.etag": "",

                "ItemInternalId": "e5053240-58ab-4653-aadd-50169a1d963e",

                "Question": "Insurance 2",

                "Answer": "Answer 2"

            },

            {

                "@odata.etag": "",

                "ItemInternalId": "46f7bf16-0c1e-4594-b418-68468e5008da",

                "Question": "Insurance 3",

                "Answer": "Answer 3"

            },

            {

                "@odata.etag": "",

                "ItemInternalId": "f1c776cd-43da-455b-a6ce-e011a5f91dc2",

                "Question": "Insurance 4",

                "Answer": "Answer 4"

            },

            {

                "@odata.etag": "",

                "ItemInternalId": "29b2e3ef-35ba-4fae-be21-6a9ba2eadf51",

                "Question": "Insurance 5",

                "Answer": "Answer 5"

            },

            {

                "@odata.etag": "",

                "ItemInternalId": "0e6d82d0-ab51-4271-8f80-182d3c190090",

                "Question": "Insurance 6",

                "Answer": "Answer 6"

            },

            {

                "@odata.etag": "",

                "ItemInternalId": "ef601654-9064-4c3d-8d91-c997ff186cf7",

                "Question": "Insurance 7",

                "Answer": "Answer 7"

            },

            {

                "@odata.etag": "",

                "ItemInternalId": "9463c24d-607c-47a1-a2fd-9cee69f6f93d",

                "Question": "Insurance 8",

                "Answer": "Answer 8"

            },

            {

                "@odata.etag": "",

                "ItemInternalId": "c1ccf81b-2a64-4a9b-9a18-7635c3843f98",

                "Question": "Insurance 9",

                "Answer": "Answer 9"

            },

            {

                "@odata.etag": "",

                "ItemInternalId": "173b1b4c-784f-4fda-aa2a-31ef3cad02ae",

                "Question": "Insurance 10",

                "Answer": "Answer 10"

            },

            {

                "@odata.etag": "",

                "ItemInternalId": "bcdde8aa-a593-42f1-a880-cf00e64bfa3d",

                "Question": "Insurance 11",

                "Answer": "Answer 11"

            },

            {

                "@odata.etag": "",

                "ItemInternalId": "0e05245c-a2c7-4bf4-8f89-25f6b1809c9b",

                "Question": "Insurance 12",

                "Answer": "Answer 12"

            },

            {

                "@odata.etag": "",

                "ItemInternalId": "816cf17b-5ad8-44e1-8da6-c0b3d36d5bb7",

                "Question": "Insurance 13",

                "Answer": "Answer 13"

            }

        ]

    }

}

[jinivthakkar · Accepted solution]

@Tak103 in filter from - pass value from the above json and it should work

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.