Can't extract PartitionKey from Azure Table Storage Entities

(0) Share

Report

Posted on by JamesM

271

I 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:

2018-11-28 16_26_34-Microsoft PowerApps.png

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

v-yuazh-msft on at

Like (0)

Report
Hi @JamesM,

Could you please choose a "Value" dynamic content of the "GetVisitsInWeek" action in the input field of the "Apply to each"?

Please delete the "PartitionKey" dynamic content from the in the input field of the "Apply to each", and choose the Array type value in the input field of the "Apply to each", and then you could refer to screenshot below to add Compose action inside the "Apply to each" to get the "PartitionKey" value:

The expression in the Compose should as below:

items('Apply_to_each')?['PartitionKey']

The flow would run successfully as below:

Best regards,

Alice

Was this reply helpful? Yes No
JamesM 271 on at

Like (0)

Report

Thanks Alice - I’ll give this a try when I’m at work tomorrow. Out of curiosity, how would you propose someone would get both the PartitonKey AND a custom Column value from the table in the flow above? Let’s say I wanted the PartionKey and the Value field within the apply for each loop?

Was this reply helpful? Yes No