Hi!
I'm wondering how to get the nth value from this array. In my situation, I would need to parse through all three below but not sure how to retrieve these values (effectively). I'm piggy backing from this post I made (same concept).
Thank you!
"ToughnessTemperature": [
{
"Key": "DropWeightTearTesting",
"Value": null
},
{
"Key": "ImpactCharpyTesting",
"Value": null
},
{
"Key": null,
"Value": null
}
]
Solved! Go to Solution.
From:
outputs('JSON')['ToughnessTemperature']
Map:
concat
(
'"',
item()['Key'],
'": "',
item()['Value'],
'"'
)
The JSON you posted isn't valid and needs to have { and } prepended and appended for these expressions to work. Produces:
{
"DropWeightTearTesting": "",
"ImpactCharpyTesting": "",
"": ""
}
Not this again! 🤮
@Paulie78 Yes, unfortunately😕. But, good news, this is the last array I need help with. The rest I can handle (hopefully).
I’d do it for you but I’m not near a computer - why not copy the method from the previous post?
@Paulie78 Trust me, I've tried. I tweaked and tweaked the expression but I keep getting an error. I tried over 15 different expressions with no luck...hence why I am back😅
@Paulie78 I think I got it. It might be:
outputs('JSON')['ToughnessTemperature'][1]['Value']
Tying it out now!
From:
outputs('JSON')['ToughnessTemperature']
Map:
concat
(
'"',
item()['Key'],
'": "',
item()['Value'],
'"'
)
The JSON you posted isn't valid and needs to have { and } prepended and appended for these expressions to work. Produces:
{
"DropWeightTearTesting": "",
"ImpactCharpyTesting": "",
"": ""
}
The way you are trying it will also work, arguably simpler and easier. Wouldn't have worked for the one you posted yesterday, but this one it should.
@Paulie78 Yup, it surely did work! Thank you! Hopefully I won't be back anytime soon lol
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
69 | |
27 | |
22 | |
16 | |
13 |
User | Count |
---|---|
132 | |
43 | |
42 | |
34 | |
31 |