I have the following JSON data i'm receiving from a Response in a PowerApp. I ultimately only want the "Result" array that actually has data in it. No matter what I try, the result data keeps ending up in a table within my collection. I've tried appending .value).Result to my .Run but I don't seem to be able to expand the table data in the "Result" column, or ideally make it not be in a table. I also want to ideally ignore any "Result" entries which have no data if possible.
ClearCollect(updates,MyPowerAppNameHere.Run(selectedname,selectedid).value).Result
{
"value": [
{
"Status": "1",
"MoreResult": false,
"Result": []
},
{
"Status": "1",
"MoreResult": false,
"Result": [
{
"Title": "Microsoft Visual C++ 2015-2019 Redistributable 14.24.28127.4 (x64)",
"UpdateId": "d093f283-506e-4e20-ae95-041d4dde07a2",
"KBArticleIDs": "KBVC-14.24.281x64",
"SecurityBulletinIDs": "VC-14.24.281x64",
"Categories": "SCUP Updates,Updates",
"Device": "FS01"
},
{
"Title": "Microsoft Visual C++ 2015-2019 Redistributable 14.24.28127.4 (x86)",
"UpdateId": "96cb6bab-388a-4a8b-a196-d92f32ea9875",
"KBArticleIDs": "KBVC-14.24.281x86",
"SecurityBulletinIDs": "VC-14.24.281x86",
"Categories": "SCUP Updates,Updates",
"Device": "FS01"
},
{
"Title": "Security Intelligence Update for Windows Defender Antivirus - KB2267602 (Version 1.307.2007.0)",
"UpdateId": "a263f04d-2fee-4eea-80e8-62447e3068bd",
"KBArticleIDs": "KB2267602",
"SecurityBulletinIDs": "",
"Categories": "Definition Updates,Microsoft Defender Antivirus",
"Device": "FS01"
},
{
"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": "FS01"
},
{
"Title": "Microsoft 365 Apps Update - Semi-Annual Enterprise Channel Version 2002 for x86 based Edition (Build 12527.21416)",
"UpdateId": "0bf51538-6c96-4f2b-a3f3-2ecd81f6acdf",
"KBArticleIDs": "KB3104046",
"SecurityBulletinIDs": "",
"Categories": "Office 365 Client,Updates",
"Device": "FS01"
},
{
"Title": "Microsoft Edge-Stable Channel Version 87 Update for x64 based Editions (Build 87.0.664.57)",
"UpdateId": "7ab77342-27e3-4515-bdc1-1d4282426b13",
"KBArticleIDs": "",
"SecurityBulletinIDs": "",
"Categories": "Microsoft Edge,Updates",
"Device": "FS01"
}
]
},
{
"Status": "1",
"MoreResult": false,
"Result": []
}
]
}
Thanks in advance
85
Share
Report
All responses (
Answers (
