cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tak103
Frequent Visitor

Getting an error msg after pulling data from Excel

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,

 

Tak103_0-1643828719826.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
jinivthakkar
Super User
Super User

@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.

View solution in original post

3 REPLIES 3
jinivthakkar
Super User
Super User

@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.

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": {
        "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
Super User
Super User

@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.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,600)