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 Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,927)