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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

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

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,743 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,079 Most Valuable Professional

Leaderboard