web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Prase Json error: "Inv...
Power Automate
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

 

Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    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

  • szheng Profile Picture
    Microsoft Employee on at

    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

     

  • Verified answer
    abm abm Profile Picture
    32,985 Most Valuable Professional on at

    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

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 376

#2
Valantis Profile Picture

Valantis 361

#3
David_MA Profile Picture

David_MA 294 Super User 2026 Season 1

Last 30 days Overall leaderboard