Answered

array of keys() and array values() expression for object

(0) Share

Report

Posted on by rockyfjord

Why the hell doesn't this exist already? I'm trying to write a boilerplate Power Automate flow that I can use for all Microsoft forms - not just one. I don't want to parse a JSON object and manually place dynamic content. I want to get an array of keys with the expression keys(body('Parse JSON')) -> ["a", "o", "g"]

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @rockyfjord
Now in Power Automate , it do not have the function to extract the keys and values for a json object .
But we can use the xml() and xpath() function to help to extract the keys and values.
And for the steps you can refer to :
ForEach Property in #MicrosoftFlow JSON. With XPath? #microblog — John Liu .NET

And you can also refer to the similar case as here :
Solved: Getting JSON keys in flow - Power Platform Community (microsoft.com)
Modify the Array Values During Runtime - Power Platform Community (microsoft.com)

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Chriddle 8,672 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
You can do this with xPath.

But you have to take care of XML's character encoding

(see https://powerusers.microsoft.com/t5/Building-Flows/extracting-data-from-json-with-changing-key-based-on-date/m-p/2467376/highlight/true#M275757)

From:

xpath( xml(json(concat('{"Root":', outputs('Compose'),'}'))), '/Root/*' )

Map:

xpath( item(), 'name(/*)' )

2 people found this reply helpful.

Was this reply helpful? Yes No
rockyfjord 4 on at

Like (0)

Report
Copy link

Link copied!

Thanks all. This is the working solution I came across, but I was hoping for something a bit more intuitive. A Python Azure function that performs all of the necessary SharePoint replacements is probably what I'll end up rolling with.
SharePoint Column Display Names

Was this reply helpful? Yes No