Powerapps 'Response' action does not provide proper table collection in PA.

(0) Share

Report

Posted on by martinav

3,340

Not sure what's wrong with my data here. This is the output from a Response Action (Raw). Looks good, right?:

{
 "statusCode": "200",
 "schema": {
 "type": "array",
 "items": {
 "type": "object",
 "properties": {
 "Filename": {
 "type": "string"
 },
 "WONum": {
 "type": "string"
 },
 "FileExists": {
 "type": "integer"
 }
 },
 "required": [
 "Filename",
 "WONum",
 "FileExists"
 ]
 }
 },
 "body": [
 {
 "Filename": "WO 5595-1 97201-97205.pdf",
 "WONum": "5595-1",
 "FileExists": 0
 },
 {
 "Filename": "WO 5595-1 97201-97205.pdf",
 "WONum": "5595-1",
 "FileExists": 1
 }
 ]
}

This is my powerapps call:

ClearCollect(ChkExistResult,AddNewWorkorder_Chk_Exist2.Run(JSON(UploadData_New,JSONFormat.IndentFour),User().FullName));

This is what I get back in PA:

Of course, I expect 'ChkExistResult.WONum' etc.

Putting ChkExistResult in a Gallery gives me one field, chkexistresult - and there is nothing in it.

See a problem? I've done this in several flows. This is broke.

I have the same question (0)

All responses (3)

Answers (0)

abm abm 32,600 Most Valuable Professional on at

Like (0)

Report

Re: Powerapps 'Response' action does not provide proper table collection in PA.

Hi @martinav

ChkExistResult.WONum is an array? So not sure you can access without the index?

Was this reply helpful? Yes No
martinav 3,340 on at

Like (1)

Report

Re: Powerapps 'Response' action does not provide proper table collection in PA.

@abm ,

Thanks for the reply.

Per my ClearCollect() statement, ChkExistResult is the array. I should be able to call for ChkExistResult.WONum, ChkExistResult.Filename, and ChkExistResult.FileExists in my lookup commands, etc.

Can you be more specific on what you mean by 'the index'? This is the raw output from an array variable in flow. Ive done this before. It all looks good to me. No?

JSON schema resolves fine as well.

Was this reply helpful? Yes No
abm abm 32,600 Most Valuable Professional on at

Like (0)

Report

Re: Powerapps 'Response' action does not provide proper table collection in PA.

Hi @martinav

I was thinking about referencing with index to access the values. I understood now but can't able to figure out what's wrong here. You might get better help from PowerApp community forum.

Thanks

Was this reply helpful? Yes No