Skip to main content

Notifications

Community site session details
Power Automate - Building Flows
Answered

Message appears"Invalid type. Expected Object but got Array" using Parse JSON

Like (0) ShareShare
ReportReport
Posted on 5 Sep 2023 21:50:03 by 75

Hi all ; hi @trice602 , sorry to ping you here, I decided to find another way to do this flow. To put it again in context. Originally, this flow was working correctly. The main function was that in a group chat in Teams and when someone writes "OPP-XXXXXXXXXX" the flow will lookup details in excel and return specific data about that specific OPP. 

 

Text inputs such as:

I want to view OPP-XXXXXXXXXX

Need update on OPP-XXXXXXXXXX

 

So the flow will look up the word "OPP" and then get the rest 10 digits, then proceed to look that number in excel and return the message in Teams.

 

this is my flow:

 

Robotech12_0-1693950144009.png

 

Robotech12_2-1693950253145.png

 

Robotech12_4-1693950282083.png

I am getting Error in the ParseJson part it says the error is :

 

{
    "errors": [
        {
            "message": "Invalid type. Expected Object but got Array.",
            "lineNumber": 0,
            "linePosition": 0,
            "path": "",
            "schemaId": "#",
            "errorType": "type",
            "childErrors": []
        }
    ]
}

 

Robotech12_5-1693950426126.png

 

Not sure where to change or extra step to do? Thank you in advance.

  • Robotech12 Profile Picture
    75 on 06 Sep 2023 at 19:27:22
    Re: Message appears"Invalid type. Expected Object but got Array" using Parse JSON

    Hi, I just updated, it is working now, all good ! thank you !

  • Verified answer
    SudeepGhatakNZ Profile Picture
    14,318 Most Valuable Professional on 06 Sep 2023 at 02:56:02
    Re: Message appears"Invalid type. Expected Object but got Array" using Parse JSON

    @Robotech12 ,

     

    Your PARSE JSON schema is incorrect.

    You first node should be an array if you want to parse items returned by the Filter.

    SudeepGhatakNZ_0-1693968923382.png

    Regenerate the JSON schema or share the output of your Filter array and I will create a schema for you.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Building Flows

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 196 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 171 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 165

Overall leaderboard
Loading started
Loading started