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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Prase Json error: "Inv...
Power Automate
Unanswered

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,865 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,865 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard