Hi All,
I have what seems like a rather simple question, but I'm struggling with how to go about it (perhaps a case of overthinking).
In my Cloud Flow, I'm using the SharePoint Get Items action to select files from a SharePoint list and copy them to a different list.
As part of the Flow, I wanted to take the List Name value from the Get Items inputs and set it to a variable to be used later on (specifically, in an email that's sent out at the tail end).
If I select "Peek Code" for the Get Items action, I can see what appears to be a fairly basic JSON schema of data wherein the SharePoint List Name value is nested under inputs --> parameters and corresponds to the "table" value ("My SharePoint List Name").
Is there a way to parse this data and then store the "table" value in a variable as opposed to parsing the entire array of items that the Get Items action is returning?
{
"inputs": {
"host": {
"connectionName": "shared_sharepointonline",
"operationId": "GetItems",
"apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline"
},
"parameters": {
"dataset": "https://mydomain.sharepoint.com/teams/codg/",
"table": "My SharePoint List Name,
"$filter": "Originally_Created lt '@{addDays(utcNow(), -210)}'"
},
"authentication": {
"type": "Raw",
"value": "@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"
}
},
"runtimeConfiguration": {
"paginationPolicy": {
"minimumItemCount": 680
}
},
"metadata": {
"operationMetadataId": "4b21e18d-328c-479a-8fda-629f1996b0fd"
}
}
