Unanswered

Power Automate JSON Parsing Assistance

(0) Share

Report

Posted on by suby_thakurta

I have a flow that is trying to take Azure DevOps query, store it as JSON and then extract individual json objects one by one. Here is my flow:

MyFlow MyFlow

This flow usually works great but for the following reason this version of the flow is failing:

See the json object that I have from Azure DevOps is a little weird:
[

{

"System.Id": 756,

"System.WorkItemType": "User Story",

"System.State": "Done",

"System.Title": "Sample user story ",

"Custom.UserRequestID": "1594"

}

]

When I try to extract data using item().Id, I get a name mismatch error. When I try item().['System.Id'], I get invalid expression error. If i do, item().system.id, then i get object system not found error.

Can anyone please help?

P.S. : Please do not provide a solution that has apply to each loop. I would like to understand how to handle this syntax with item() expressions. However, triggerBody expressions instead of item as solutions are welcome since they have the same issue in syntax.

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report
Since the JSON has square brackets around it you are dealing with an array, not an object. That's why you normally get an apply to each. But you can use an integer index to get the individual records. So if what you posted above is in the parse JSON this would get you system.id

body('Parse_JSON')[0]?['System.Id']

Was this reply helpful? Yes No
suby_thakurta 6 on at

Like (0)

Report

I am sorry but this solution doesn't work. My objective is to extract individual items from json parse. If the key names did not have System. or custom. in them, item works like magic. So I need to know what is the correct syntax for item() when JSON names are like System.ID or Custom.ID. Hope you understand my predicament.

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

I put the sample you posted in a Parse JSON and the code I posted is what retrieves the ID value. What you posted is an array so you can't access an item without an index.

Was this reply helpful? Yes No
suby_thakurta 6 on at

Like (0)

Report

Can you please share a screenshot of your flow? I am still getting an error. I understand it is an array and that is why I was looking into item(). That's not the issue. It is the syntax which is causing a problem as my key is named as System.Id. If it was just Id, then my solution works. It would be a great favor, if you can share a screenshot of your flow. Thank you!

Was this reply helpful? Yes No
NorthernChuck 156 on at

Like (0)

Report

@suby_thakurta if you are trying to replicate a foreach() loop, the you need to use "Apply to Each" condition.
I'm looking at your screenshot and I'm questioning all the initializes and the parse json in between the Azure DevOps tiles and your select. There's always 1001 to skin-a-cat, but I'd look at doing your select after the DevOps tiles. The UI should auto-insert an "Apply to Each"

Was this reply helpful? Yes No
suby_thakurta 6 on at

Like (0)

Report

I guess I was not clear with the question. My objective is to extract an item from an array that has system.id as the key using item() expression. I want to know the syntax for that. I already am able to build the solution using create CSV table or trigger expressions. And yes, to pull the items from the array, for each will work great. All these are great solutions but I am looking for a syntax as a solution (as I have mentioned in my problem statement) and not suggestions on how to run the flow. But thank you so much for your efforts. I am extremely thankful for your suggestions.

Was this reply helpful? Yes No
NorthernChuck 156 on at

Like (0)

Report

Then @Pstork1 's comments is where you loop back to; you have an array to deal with.
What you are asking for is after the index number. You have to tell the flow which index number inside the array you are dealing with.
In other words, you have to identify 'where' you are in the array, then your object and then you can deal with items. I did the same thing as @Pstork1 and came to the same result, I had to identify where I was in the array, position 0, then I got your data.

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

You can only use the item() notation inside a loop of some kind, like an apply to each loop. When not inside the loop you access the array, that's body('Parse_Json'). And then specify the item you want with an integer index [0]. Then add the selector for the value ?['system.Id']. Here's the flow

Was this reply helpful? Yes No
Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

You can only select an item using an index integer, not a key. Once you have the item you can select the property using the key name. You can also use the key value and the key to filter the array. But you still end up with an array.

Was this reply helpful? Yes No