Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Prase Json error: "Invalid type. Expected String but got Null.",

(1) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi, I'd like to create a flow to find specific issue, this is my step:

1. Find issues by keyword: output is a object such as:

szheng_0-1716887926707.png

2. compose this output

3. parse this issue, because I want to get one specific issue by some condition

but when I parse this issue, I got a error

[ { "message": "Invalid type. Expected Object but got Null.", "lineNumber": 0, "linePosition": 0, "path": "items[1].assignee", "schemaId": "#/properties/items/items/properties/assignee", "errorType": "type", "childErrors": [] }, { "message": "Invalid type. Expected Object but got Null.", "lineNumber": 0, "linePosition": 0, "path": "items[2].assignee", "schemaId": "#/properties/items/items/properties/assignee", "errorType": "type", "childErrors": [] }, { "message": "Invalid type. Expected String but got Null.", "lineNumber": 0, "linePosition": 0, "path": "items[3].labels[0].description", "schemaId": "#/properties/items/items/properties/labels/items/properties/description", "errorType": "type", "childErrors": [] }, { "message": "Invalid type. Expected Object but got Null.", "lineNumber": 0, "linePosition": 0, "path": "items[3].assignee", "schemaId": "#/properties/items/items/properties/assignee", "errorType": "type", "childErrors": [] }, { "message": "Invalid type. Expected String but got Null.", "lineNumber": 0, "linePosition": 0, "path": "items[4].labels[0].description", "schemaId": "#/properties/items/items/properties/labels/items/properties/description", "errorType": "type", "childErrors": [] }, { "message": "Invalid type. Expected Object but got Null.", "lineNumber": 0, "linePosition": 0, "path": "items[4].assignee", "schemaId": "#/properties/items/items/properties/assignee", "errorType": "type", "childErrors": [] }, { "message": "Invalid type. Expected Object but got Null.", "lineNumber": 0, "linePosition": 0, "path": "items[5].assignee", "schemaId": "#/properties/items/items/properties/assignee", "errorType": "type", "childErrors": [] }, { "message": "Invalid type. Expected String but got Null.", "lineNumber": 0, "linePosition": 0, "path": "items[6].labels[0].description", "schemaId": "#/properties/items/items/properties/labels/items/properties/description", "errorType": "type", "childErrors": [] }, { "message": "Invalid type. Expected Object but got Null.", "lineNumber": 0, "linePosition": 0, "path": "items[6].assignee", "schemaId": "#/properties/items/items/properties/assignee", "errorType": "type", "childErrors": [] }, { "message": "Invalid type. Expected Object but got Null.", "lineNumber": 0, "linePosition": 0, "path": "items[7].assignee", "schemaId":  ]

How can I solve this? 

By the way, is there any way to find a specific issue? because so much issues be found if by key words. Thanks very much.

szheng_1-1716888344975.png

 

  • Verified answer
    abm abm Profile Picture
    32,464 Most Valuable Professional on at
    Re: Prase Json error: "Invalid type. Expected String but got Null.",

    Hi @szheng 

     

    In your parse json step look for array, object data types and extend with null similar like I explained in my video. The reason for this error is because you don't have all the data to validate. Some are optional. Extending the data types values to null should override this issue.

     

    Thanks

  • szheng Profile Picture
    Microsoft Employee on at
    Re: Prase Json error: "Invalid type. Expected String but got Null.",

    Hi @abm Thanks, it's so help, May I ask for another question? 

    When I add a control because I want to judge the value of "state", I get another error message:

    szheng_0-1716963958587.png

    this is my flow:

    szheng_2-1716964964523.png

    this is a result of parse this issue

    szheng_1-1716964458775.png

     

  • abm abm Profile Picture
    32,464 Most Valuable Professional on at
    Re: Prase Json error: "Invalid type. Expected String but got Null.",

    Hi @szheng 

     

    I have explained this behaviour in my tutorial video.

     

    Power Automate - Parse JSON Action Tips (youtube.com)

     

    If you need any further help in this please let me know.

     

    Thanks

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow