Get list of properties from custom object

(0) Share

Report

Posted on by tfitzger

I am building a flow that has a custom object with, let's say, the following data in json:

{
"foo": "a",
"bar": "b",
"baz": 100
}

This json comes from a Web API and may change depending on what is being sent. I wanted to know if there is a way to extract the list of properties to loop over. I.E, in this case I would have a list of Text ["foo", "bar", "baz"]

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Henrik_M 2,021 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
I'm not sure if there is a way to extract the property names from the object, put I guess you could use a regex "hack" to grab them from the JSON string. Try pasting this into your desktop flow:

SET JSON TO $'''{ \"foo\": \"a\", \"bar\": \"b\", \"baz\": 100 }''' Text.ParseText.RegexParse Text: JSON TextToFind: $'''(?<=\").+?(?=\":)''' StartingPosition: 0 IgnoreCase: False Matches=> Matches

Was this reply helpful? Yes No
tfitzger 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, @Henrik_M . I have something like that already in place, but I was curious if there was something less hacky. Ah well.

Was this reply helpful? Yes No
anp882 10 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried the following in a condition and an object assigned to a variable
This:
variables('YourVariable')?['YourProperty'] is equal to null
was not evaluating to true, even when property didn't exist. But this:
empty(variables('YourVariable')?['YourProperty']) is equal to true
was working fine.

Was this reply helpful? Yes No