I am trying to create the flow as shown below, but during the "Select" step, I do not have the option for 'value' in dynamic content, and only have the 'body/value' option.
My "Get Items" is as shown below:
Code View (removing the filter does not change anything as far as the 'value'):
{
"type": "OpenApiConnection",
"inputs": {
"parameters": {
"dataset": "https://XXXXXXXXXX.sharepoint.com/sites/Quality",
"table": "XXXXXXXX-YYYY-XXXX-ZZZZ-XXXXXXXXXX",
"$filter": "Received ge '@{formatDateTime(startOfMonth(getPastTime(12,'Month')),'MM-dd-yyyy')}' and Received lt '@{addToTime(startOfMonth(utcNow()),1,'Month')}'"
},
"host": {
"apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline",
"connection": "shared_sharepointonline",
"operationId": "GetItems"
}
},
"runAfter": {}
}
My dynamic view only give me this option:
While this flow does give me a CSV file, it is not correct.
Any hints as to why I do not have the 'value' option, or how to pull the array values would be appreciated. Thank you.
