Hi all,
I'm using a Response to get data in a Flow and create a collection in my PowerApp.
Hi all,
I'm using a Response to send results back to a PowerApp. The way it's returned right now, the collection shows the "Value" columns, and there's a column called "Result" which has a table of the values I need in each.
The challenge is, the response has multiple values which have an empty "Result" and one "Result" which has my data I want in it. Unfortunately, it's tough to say if it will be the first "Result" or the 2nd, or etc. So I can't use "First", but I don't know of a way to say "Whichever Result array member has data in it, use that". I've tried unsuccessfully getting the Flow to only return the "Result" which has data in it using Filter Array where length of Result is > 0. My lack of experience is likely to blame for this :). So i'm now trying to put the responsibility on my PowerApp to only display the Result array member that has data, though I do feel like fixing it in my Flow is probably the right answer.
{
"value": [
{
"Status": "1",
"MoreResult": false,
"Result": [
{
"Title": "Notepad++ 7.9.1 (x64)",
"UpdateId": "120c2643-20f7-4b2c-9389-9f3ef32e9343",
"KBArticleIDs": "KBPMPC-2020-11-02",
"SecurityBulletinIDs": "PMPC-2020-11-02",
"Categories": "SCUP Updates,Updates",
"Device": "SUP1"
},
{
"Title": "Microsoft Edge-Stable Channel Version 87 Update for x64 based Editions (Build 87.0.664.60)",
"UpdateId": "d250733d-32c4-480b-9f9e-59daa328b0c3",
"KBArticleIDs": "",
"SecurityBulletinIDs": "",
"Categories": "Microsoft Edge,Updates",
"Device": "SUP1"
},
{
"Title": "Security Intelligence Update for Microsoft Defender Antivirus - KB2267602 (Version 1.329.291.0)",
"UpdateId": "c737e307-723d-4cfd-adf8-c554ab6d7f4a",
"KBArticleIDs": "KB2267602",
"SecurityBulletinIDs": "",
"Categories": "Definition Updates,Microsoft Defender Antivirus",
"Device": "SUP1"
}
]
},
{
"Status": "1",
"MoreResult": false,
"Result": []
},
{
"Status": "1",
"MoreResult": false,
"Result": []
},
{
"Status": "1",
"MoreResult": false,
"Result": []
},
{
"Status": "1",
"MoreResult": false,
"Result": []
},
{
"Status": "1",
"MoreResult": false,
"Result": []
},
{
"Status": "1",
"MoreResult": false,
"Result": []
},
{
"Status": "1",
"MoreResult": false,
"Result": []
}
]
}
Thanks
