Action 'Parse_JSON' failed

[Sathyashree]

It says SCHEMA VALIDATION FAILED.

I have used the following query:

Content:
{
"type": "array",
"items": {
"type": "object",
"properties": {
"Region": {
"type": ["string", "null"]
},
"Retailer": {
"type": ["string", "null"]
},
"Global Location ID": {
"type": ["string", "null"]
},
"Total Revenue": {
"type": ["number", "string", "null"]
}
}
}
}

Schema:

{

  "type": "array",

  "items": {

    "type": "object",

    "properties": {

      "Region": {

        "type": [

          "string",

          "null"

        ]

      },

      "Retailer": {

        "type": [

          "string",

          "null"

        ]

      },

      "Global Location ID": {

        "type": [

          "string",

          "null"

        ]

      },

      "Total Revenue": {

        "type": [

          "string",

          "number",

          "null"

        ]

      }

    }

  }

}

I'm getting the error that Action 'Parse_JSON' failed and displays this error in the output:

[

  {

    "message": "Invalid type. Expected Array but got Object.",

    "lineNumber": 0,

    "linePosition": 0,

    "path": "",

    "schemaId": "#",

    "errorType": "type",

    "childErrors": []

  }

]

[muralidharan]

@Sathyashree 

How you generated the JSON schema ? 

Have you tried "Generate from Sample" option in Parse JSON action ?

[Sathyashree]

Hi Murali Sir,
@muralidharan 

I got the error rectified, but I only get 3 columns out of the 4 columns as of now. I want an additional column "Total Revenue" as well from the data. How should I go about it? 

I mean, as I used ClearCollect to extract the data from the main table, it only extracts whatever columns I had mentioned inside the filter. What should I do to include the columns from the main table, apart from the columns I had used in the filter condition?

[muralidharan]

@Sathyashree 

Are you sending the data from Power Apps to Power Automate for JSON parse?

You can alter the JSON schema on the Parse JSON action, or you can use simply json () in the Power Automate expressions.

Power Automate Fundamentals # 27: Usage of JSON Fu... - Power Platform Community (microsoft.com) 

There is ParseJSON feature in Poer Apps but it is in experimental stage.  - ParseJSON function in Power Apps (experimental) - Power Platform | Microsoft Docs

[Sathyashree]

@muralidharan 

Hi Sir,

Yes Sir, I'm connecting data directly from PowerApps. I have used this FORMULA on the "Export data" icon.

ClearCollect
(
Collection_Show_Data,
Search
(
Filter
(
TableName,
Region=ComboBox_Region.Selected.Result || IsBlank(ComboBox_Region.Selected.Result),
Retailer=ComboBox_Retailer.Selected.Result || IsBlank(ComboBox_Retailer.Selected.Result)
),
ABC_XYZ_Input.Text, "ABC_x0020_XYZ_x0020_ID"
)
);

Data_Export_Flow.Run
(
JSON
(
Collection_Show_Data,
JSONFormat.IncludeBinaryData
)
)

To which, Power flow ONLY collects those 3 columns mentioned within the filter[

ABC_x0020_XYZ_x0020_ID	Region	Retailer
12345	Region1	Retailer1

 Whereas I want the "Total revenue" also

TableName contains "Total Revenue" column, but I couldn't extract that column when I used the Collection to extract filtered data upon using the filters on the 3 columns -> [ABC_XYZ_ID, Region, Retailer].

[muralidharan]

@Sathyashree 

You're filtering records from TableName and this has only 3 columns, name, region and retailer? 

[Sathyashree]

Hi Sir,

@muralidharan 

TableName has multiple other columns apart from ID, Region, Retailer, among which Total Revenue is also one. I could pull that "Total Revenue" into the Gallery. 

This is the formula I used to pull the data onto the gallery:
Search
(
Filter
(
TableName,
Region=ComboBox_Region.Selected.Result || IsBlank(ComboBox_Region.Selected.Result),
Retailer=ComboBox_Retailer.Selected.Result || IsBlank(ComboBox_Retailer.Selected.Result)
),
ABC_XYZ_Input.Text, "ABC_x0020_XYZ_x0020_ID"
)

It gets populated on my interface:

But it DOESN'T get populated in my Excel that I had exported into OneDrive using the PowerFlow. Well, even the inputs to the PowerFlow has only three columns -> ID, Region and Retailer. It doesn't read any other columns from the TableName. I had pulled the data into a COLLECTION using the filter conditions to capture the subset of rows satisfying the filter conditions. But the COLLECTION data I had referenced to Parse the JSON captures only those filter columns, and NOT the rest of the columns apart from the filter columns, though the populated data satisfies the filter conditions.

Summary: The COLLECTION returns the subset of rows by applying the filter conditions, and ONLY those data columns mentioned within the FILTERS gets populated when I filtered the data from the ComboBox used to interact with the User(Here : ID, Region, Retailer) from the main TableName. It doesn't return the rest of the columns(Total Revenue, etc).

[muralidharan]

@Sathyashree 

Can you please confirm what are the columns are available in Collection_Show_Data collection ?

Thanks,

Murali

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.