Help sending array back to PowerApps via Response

[martinav]

This is not the first time I have done this.  However, this time something is not right.  Seems everything is in order, but the clearcollect() on the PA side does not have anything in it.  However, the output from response is FULL of data.  I have checked it with a First() in a compose, and the array looks to be in order.  What gives?

See the excerpt.  The flow runs fine.  All green.  I just get nothing on the PA side.  The collection contains a "rowNumber" field, but no data at all.

Response output looks like this:

{"statusCode":"200","schema":{"type":"object","properties":{"body":{"type":"array","items":{"type":"object","properties":{"rowNumber":{"type":"integer"},"createdAt":{"type":"string"},"modifiedAt":{"type":"string"},"SS_PartNumber":{"type":"string"},"SS_Description":{"type":"string"},"SS_Notes":{"type":"string"},"SS_ModifiedDate":{"type":"string"},"SS_User":{"type":"string"}},"required":["rowNumber","createdAt","modifiedAt","SS_PartNumber","SS_Description","SS_Notes","SS_ModifiedDate","SS_User"]}}}},"body":[{"rowNumber":13,"createdAt":"2019-10-09T14:12:18Z","modifiedAt":"2020-04-28T20:42:36Z","SS_PartNumber":"153030","SS_Description":"BALL-3IN SST","SS_Notes":"","SS_ModifiedDate":"2020-04-28T20:42:36Z","SS_User":"martin@company.com"},{"rowNumber":6,"createdAt":"2020-04-28T20:31:57Z","modifiedAt":"2020-04-28T20:31:57Z","SS_PartNumber":"153015","SS_Description":"VALVE BODY-1IN SST","SS_Notes":"","SS_ModifiedDate":"2020-04-28T20:31:57Z","SS_User":"martin@company.com"},{"rowNumber":4,"createdAt":"2020-04-28T20:31:57Z","modifiedAt":"2020-04-28T20:31:57Z","SS_PartNumber":"153013","SS_Description":"VALVE BODY-2IN SST","SS_Notes":"","SS_ModifiedDate":"2020-04-28T20:31:57Z","SS_User":"martin@company.com"},{"rowNumber":18,"createdAt":"2020-04-28T20:42:36Z","modifiedAt":"2020-04-28T20:42:36Z","SS_PartNumber":"153035","SS_Description":"BALL-1IN CERAMIC","SS_Notes":"","SS_ModifiedDate":"2020-04-28T20:42:36Z","SS_User":"martin@company.com"},{"rowNumber":50,"createdAt":"2017-01-10T14:54:30Z","modifiedAt":"2018-07-03T18:25:56Z","SS_PartNumber":"201021","SS_Description":"JS75H General arrg.","SS_Notes":"","SS_ModifiedDate":"2017-01-10T14:54:30Z","SS_User":"neisler@company.com"},{"rowNumber":9,"createdAt":"2020-04-28T20:31:57Z","modifiedAt":"2020-04-28T20:31:57Z","SS_PartNumber":"153022","SS_Description":"BODY RETAINER-2IN CS","SS_Notes":"","SS_ModifiedDate":"2020-04-28T20:31:57Z","SS_User":"martin@company.com"},{"rowNumber":42,"createdAt":"2018-03-13T15:25:31Z","modifiedAt":"2020-02-07T20:22:19Z","SS_PartNumber":"153100","SS_Description":"HANDLE","SS_Notes":"","SS_ModifiedDate":"2020-02-07T20:22:19Z","SS_User":"martin@company.com"},{"rowNumber":49,"createdAt":"2017-01-10T14:54:30Z","modifiedAt":"2018-07-03T18:25:56Z","SS_PartNumber":"201020","SS_Description":"JS75L General Arrg.","SS_Notes":"","SS_ModifiedDate":"2017-01-10T14:54:30Z","SS_User":"neisler@company.com"},{"rowNumber":41,"createdAt":"2018-03-13T15:25:31Z","modifiedAt":"2020-04-28T20:47:27Z","SS_PartNumber":"153091","SS_Description":"THRUST WASHER-1IN","SS_Notes":"","SS_ModifiedDate":"2020-04-28T20:47:27Z","SS_User":"martin@company.com"},{"rowNumber":63,"createdAt":"2017-01-10T14:54:30Z","modifiedAt":"2018-07-03T18:25:56Z","SS_PartNumber":"201036","SS_Description":"JS75HS304 General Arrg.","SS_Notes":"","SS_ModifiedDate":"2017-01-10T14:54:30Z","SS_User":"neisler@company.com"},{"rowNumber":100,"createdAt":"2017-01-10T14:54:30Z","modifiedAt":"2018-07-03T18:25:56Z","SS_PartNumber":"202012","SS_Description":"JS75, JS75H, JS165H 
.
.
.

[v-bacao-msft]

Hi @martinav ,

If you use first() function to get the first item from the body of Select, you will get an object instead of an array. We could see an object in the output of Compose.

Please check this blog and see if it helps:

https://powerapps.microsoft.com/en-us/blog/return-an-array-from-flow-to-powerapps-response-method/

Best Regards,

[martinav]

@v-bacao-msft ,

Thanks for the reply.

The First() command was just a test to see if what I was getting was truly an array.  I am not using the output of that.  I'm using the same output that fed the First() into Response.  

I did tweak my schema a bit.  THat was wrong at the time I posted it.  

All of that is what I had done before in another flow.  Does not the output of response look perfect?  I still get nothing in PA except and empty 

Response output looks like this.  WHats wrong with it?

[
  {
    "rowNumber": 13,
    "createdAt": "2019-10-09T14:12:18Z",
    "modifiedAt": "2020-04-28T20:42:36Z",
    "SS_PartNumber": "153030",
    "SS_Description": "BALL-3IN SST",
    "SS_Notes": "",
    "SS_ModifiedDate": "2020-04-28T20:42:36Z",
    "SS_User": "martin@company.com"
  },
  {
    "rowNumber": 6,
    "createdAt": "2020-04-28T20:31:57Z",
    "modifiedAt": "2020-04-28T20:31:57Z",
    "SS_PartNumber": "153015",
    "SS_Description": "VALVE BODY-1IN SST",
    "SS_Notes": "",
    "SS_ModifiedDate": "2020-04-28T20:31:57Z",
    "SS_User": "martin@company.com"
  },
  {
    "rowNumber": 4,
    "createdAt": "2020-04-28T20:31:57Z",
    "modifiedAt": "2020-04-28T20:31:57Z",
    "SS_PartNumber": "153013",
    "SS_Description": "VALVE BODY-2IN SST",
    "SS_Notes": "",
    "SS_ModifiedDate": "2020-04-28T20:31:57Z",
    "SS_User": "martin@company.com"
  }
]

Schema:

{
  "type": "array",
  "items": {
    "type": "object",
    "properties": {
      "rowNumber": {
        "type": "integer"
      },
      "createdAt": {
        "type": "string"
      },
      "modifiedAt": {
        "type": "string"
      },
      "SS_PartNumber": {
        "type": "string"
      },
      "SS_Description": {
        "type": "string"
      },
      "SS_Notes": {
        "type": "string"
      },
      "SS_ModifiedDate": {
        "type": "string"
      },
      "SS_User": {
        "type": "string"
      }
    },
    "required": [
      "rowNumber",
      "createdAt",
      "modifiedAt",
      "SS_PartNumber",
      "SS_Description",
      "SS_Notes",
      "SS_ModifiedDate",
      "SS_User"
    ]
  }
}

[martinav]

Just to be sure of things, I deleted the flow from my PA, then re-added it.  It looks like the headers are coming through, but there is still no data.  

[martinav]

Let me reframe my issue.  I have two flows.  Both are doing basically the same thing.  I build an array, then send it to PA via a Response action.  One of them works great, and has been working for 2 years.  It looks like this:

1)  This is the WORKING flow.

Schema:

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "ID": {
                "type": "integer"
            },
            "Title": {
                "type": "string"
            },
            "MD_PartNumber": {
                "type": "string"
            },
            "MD_LatestRevNumber": {
                "type": "string"
            },
            "MD_Project": {
                "type": "string"
            },
            "MD_PDM_Link": {
                "type": "string"
            },
            "MD_LinkToDrawing": {
                "type": "string"
            },
            "MD_IsActive": {
                "type": "boolean"
            },
            "MD_Data_Flagged": {
                "type": "boolean"
            },
            "MD_Latest_SW_DocumentID": {
                "type": "integer"
            },
            "MD_DrawingRevDate_Text": {
                "type": "string"
            },
            "MD_EngrgRelDate_Text": {
                "type": "string"
            }
        },
        "required": [
            "ID",
            "Title",
            "MD_PartNumber",
            "MD_LatestRevNumber",
            "MD_Project",
            "MD_PDM_Link",
            "MD_LinkToDrawing",
            "MD_IsActive",
            "MD_Data_Flagged",
            "MD_Latest_SW_DocumentID",
            "MD_DrawingRevDate_Text",
            "MD_EngrgRelDate_Text"
        ]
    }
}

Data output from Response looks like this:

{

"statusCode":"200",

"schema":{"type":"array","items":{"type":"object","properties":

{"ID":{"type":"integer"},
"Title":{"type":"string"},
"MD_PartNumber":{"type":"string"},
"MD_LatestRevNumber":{"type":"string"},
"MD_Project":{"type":"string"},
"MD_PDM_Link":{"type":"string"},
"MD_LinkToDrawing":{"type":"string"},
"MD_IsActive":{"type":"boolean"},
"MD_Data_Flagged":{"type":"boolean"},
"MD_Latest_SW_DocumentID":{"type":"integer"},
"MD_DrawingRevDate_Text":{"type":"string"},
"MD_EngrgRelDate_Text":{"type":"string"}},

"required":

["ID","Title","MD_PartNumber","MD_LatestRevNumber","MD_Project","MD_PDM_Link","MD_LinkToDrawing","MD_IsActive","MD_Data_Flagged","MD_Latest_SW_DocumentID","MD_DrawingRevDate_Text","MD_EngrgRelDate_Text"]}},

"body":

[

{"ID":8027,
"Title":"3/8-16 NYLON INSERT LOCK NUT - NTE, GRADE 5, ZINC PLATED",
"MD_PartNumber":"213018",
"MD_LatestRevNumber":"1",
"MD_Project":"OEM HARDWARE",
"MD_PDM_Link":"conisio://Kelso Drawing Vault/explore?projectid=34&documentid=5323&objecttype=1","MD_LinkToDrawing":"https://kelso365.sharepoint.com/sites/KelsoEngineering/Drawing_Vault/213018-Rev-01.pdf",
"MD_IsActive":true,
"MD_Data_Flagged":false,
"MD_Latest_SW_DocumentID":5323.0,
"MD_DrawingRevDate_Text":"2018-03-21",
"MD_EngrgRelDate_Text":null

},

and so on...

 The data pushes into PA perfectly.  

So, I emulate this method with another data set:

2)  This one does NOT work:

Response Schema:

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "rowNumber": {
                "type": "integer"
            },
            "createdAt": {
                "type": "string"
            },
            "modifiedAt": {
                "type": "string"
            },
            "SS_PartNumber": {
                "type": "string"
            },
            "SS_Description": {
                "type": "string"
            },
            "SS_Notes": {
                "type": "string"
            },
            "SS_ModifiedDate": {
                "type": "string"
            },
            "SS_User": {
                "type": "string"
            }
        },
        "required": [
            "rowNumber",
            "createdAt",
            "modifiedAt",
            "SS_PartNumber",
            "SS_Description",
            "SS_Notes",
            "SS_ModifiedDate",
            "SS_User"
        ]
    }
}

And, the output from Response:

{

"statusCode":"200",

"schema":{"type":"array","items":{"type":"object","properties":

{"rowNumber":{"type":"integer"},
"createdAt":{"type":"string"},
"modifiedAt":{"type":"string"},
"SS_PartNumber":{"type":"string"},
"SS_Description":{"type":"string"},
"SS_Notes":{"type":"string"},
"SS_ModifiedDate":{"type":"string"},
"SS_User":{"type":"string"}},

"required":

["rowNumber","createdAt","modifiedAt","SS_PartNumber","SS_Description","SS_Notes","SS_ModifiedDate","SS_User"]}},

"body":

[
{"rowNumber":13,"createdAt":"2019-10-09T14:12:18Z",
"modifiedAt":"2020-04-28T20:42:36Z",
"SS_PartNumber":"153030",
"SS_Description":"BALL-3IN SST",
"SS_Notes":"",
"SS_ModifiedDate":"2020-04-28T20:42:36Z",
"SS_User":"martin@company.com"

},

And so on....

All I get in PA are the header names.  NO data.  Same methods for both.   Same data structrue for buth.  Same method to get the data into powerapps in both.  However, I have no reason why it does not work for the second case.  I have beat on it for hours.  I NEED RESOLUTION!!

What I have tried:

1) I tried deleting the flow from the PA, and adding it back in.  I have done this MANY times.  

2) I have tried limiting the dataset to just a few items.  No change in result.

3) I tried calling the working flow into this PA, and it worked.  However, its not the data I need, but it does show the app is not corrupted.

4) I have done a "Save As" on the flow and gave it a different name.  I imported that into my PA.  Same null data result.  Headers only.

[martinav]

Hailp!

[v-bacao-msft]

Hi @martinav ,

Since Flow can successfully execute and return 200, it seems that there is no problem with the configuration of Flow. From the screenshot you shared, I don't see any errors.

Please consider whether there are any configurations in PowerApps that do not meet the expectations, please refer to this blog or compare your previous successful cases.

https://powerapps.microsoft.com/en-us/blog/return-an-array-from-flow-to-powerapps-response-method/

I'm afraid I am not able to give a suitable solution for the time being.😥

Best Regards,

[martinav]

@v-bacao-msft ,

I ruled out power apps earlier when I mentioned I used my "working" flow into the same app.  That one returned data.  This one does not.  There has to be something wrong in the data.  There are even WAY more records returned in the other flow.  That was never an issue, regarding number of records.

[martinav · Accepted solution]

This yielded nothing.  I have simplified and reposted.

https://powerusers.microsoft.com/t5/Building-Flows/Why-does-this-Response-Action-send-no-data-back-t...