I'm having issues bringing the result of Power Query and Response from Flow into PowerApps.
In general I followed the same steps I've seen other's use with a PowerApps Trigger, SQL Query or Stored Procedure, and a Request Response. But where others have used the SQL Query or Stored Procedure, I am using Power Query.
I am seeing data in the Power Query and in the Response, but I am having issues with getting the results into PowerApps.
From what I can tell my Response schema is properly configured as per the data. But in PowerApps when I run the Flow, my collection doesn't populate with data, it did populate the column headers though.
Here is a sample of the Response Output:
{
"resultType": "JsonValue",
"value": [
{
"Index": 6811,
"Product_Location_Id": 1735,
"Item No_": "580-219",
"Unit of Measure Code": "EA",
"Item Category Code": "19-19",
"Product Group Code": "SQUARE",
"QTY": 2,
"Product_Description": "O-RING, SQUARE",
"Product_ProductLine_Id": "145"
},
{
"Index": 6814,
"Product_Location_Id": 1735,
"Item No_": "580-224",
"Unit of Measure Code": "EA",
"Item Category Code": "19-19",
"Product Group Code": "SQUARE",
"QTY": 5,
"Product_Description": "O-RING, SQUARE",
"Product_ProductLine_Id": "145"
}
]
}And the Schema:
{
"type": "array",
"items": {
"type": "object",
"properties": {
"Index": {
"type": "integer"
},
"Product_Location_Id": {
"type": "integer"
},
"Item No_": {
"type": "string"
},
"Unit of Measure Code": {
"type": "string"
},
"Item Category Code": {
"type": "string"
},
"Product Group Code": {
"type": "string"
},
"QTY": {
"type": "integer"
},
"Product_Description": {
"type": "string"
},
"Product_ProductLine_Id": {
"type": "string"
}
}
}
}And my PowerApps Run Flow code:
ClearCollect(PowerQueryResults,'PowerApp->TransformdatausingPowerQuery'.Run())
Any help is much appreciated.
