Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@expiscornovus
Last active October 7, 2021 09:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save expiscornovus/4cc9f915a84faebb4dd473fba176449d to your computer and use it in GitHub Desktop.
Save expiscornovus/4cc9f915a84faebb4dd473fba176449d to your computer and use it in GitHub Desktop.
Get Count Aggregate List View
{
"inputs": {
"host": {
"connectionName": "shared_sharepointonline",
"operationId": "HttpRequest",
"apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline"
},
"parameters": {
"dataset": "https://contoso.sharepoint.com/sites/testsite",
"parameters/method": "POST",
"parameters/uri": "_api/web/lists/getbytitle('@{variables('ListName')}')/RenderListDataAsStream?View=@{variables('ViewID')}",
"parameters/headers": {
"Accept": "application/json;odata=nometadata",
"Content-Type": "application/json;odata=nometadata"
},
"parameters/body": "{\n\"parameters\": {\n \"RenderOptions\":5707271,\n \"OverrideViewXml\":\"<View><Query><GroupBy Collapse=\\\"FALSE\\\"><FieldRef Name=\\\"Course\\\"/></GroupBy></Query></View>\",\n \"AddRequiredFields\":true\n }\n}"
},
"authentication": {
"type": "Raw",
"value": "@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment