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:
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.
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
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:
this is my flow:
this is a result of parse this issue
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
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional