cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Can't extract PartitionKey from Azure Table Storage Entities

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

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Can't extract PartitionKey from Azure Table Storage Entities

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:

Capture.PNG

 

The expression in the Compose should as below:

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

The flow would run successfully as below:

Capture.PNG

 

Best regards,

Alice

Highlighted
Helper V
Helper V

Re: Can't extract PartitionKey from Azure Table Storage Entities

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?

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (5,488)