Share
Report
271I have a flow which extracts some data from an Azure Table Storage object. The data obtained is as follows:
[
{
"odata.etag": "W/\"datetime'2018-11-28T03%3A46%3A01.2938236Z'\"",
"PartitionKey": "James Matson",
"RowKey": "VisitsInWeek",
"Timestamp": "2018-11-28T03:46:01.2938236Z",
"Value": "2"
}
]I'm interested in looping through each record and working with the Value, and the PartitionKey. I can get the Value okay, but if I set my For Each Apply to body('GetVisitsInAWeek')['PartitionKey'] I get the error:
InvalidTemplate. Unable to process template language expressions for action 'Apply_to_each' at line '1' and column '2526': 'The template language expression 'body('GetVisitsInWeek')['PartitionKey']' cannot be evaluated because property 'PartitionKey' doesn't exist, available properties are 'odata.metadata, value'. Please see https://aka.ms/logicexpressions for usage details.'.
I'm not sure how to get the PartitionKey, and furthermore, how to do a For Each Apply loop and work with both the Value AND the PartitionKey within the same loop.
Here is my flow:
All responses (
Answers (
