The issue with your JSON is that the "energies" object is not an array of objects, but a single object with several named properties that have their values. The dates there are names for the values, and not values of their own. If your object looked like this, you could iterate through it:
{
"id": "b125e62f-3cf0-4a9c-a841-a56107426902",
"started": "2024-01-14T14:17:28.063",
"energy": 21.476,
"energies": [
{
"Date":"2024-01-14T14:17:28+00:00",
"Value": 0
},
{
"Date":"2024-01-14T22:00:00+00:00",
"Value": 2.3739999999997963
},
{
"Date":"2024-01-14T23:00:00+00:00",
"Value": 3.4030000000002474
},
{
"Date":"2024-01-15T00:00:00+00:00",
"Value": 3.4179999999996653
},
{
"Date":"2024-01-15T01:00:00+00:00",
"Value": 3.438000000000102
},
{
"Date":"2024-01-15T02:00:00+00:00",
"Value": 3.2760000000002947
},
{
"Date":"2024-01-15T03:00:00+00:00",
"Value": 3.4329999999999927
},
{
"Date":"2024-01-15T04:00:00+00:00",
"Value": 1.625
},
{
"Date":"2024-01-15T05:00:00+00:00",
"Value": 0.4130000000000109
},
{
"Date":"2024-01-16T05:34:07+00:00",
"Value": 0.09600000000000364
}
],
"ended": "2024-01-16T05:34:07.233"
}
This is what an array of objects looks like in JSON. And that would be iterable. But what you have is different.
As such, use the approach I suggested earlier - use Parse text with regular expressions enabled and the regex I suggested. Like this:
(this assumes %JSON% is where your JSON blob is stored - use appropriate variable naming for what is already in your flow here).
The important things here are:
- Paste the regex pattern I suggested in the previous reply into the "Text to find" field
- Enable the "Is regular expression" toggle
- Disable the "First occurrence only" toggle to return all matches
This will result in all of those dates being returned in a list in %Matches%.
You can then build a loop that iterates through them, like a For each loop. You would store the current date into %CurrentItem% within the loop. And you can then get the value from your object (after you convert the JSON to a custom object) as %Object['energies'][CurrentItem]%.
You can either add those to a separate list, or insert them to a table, or whatever you want to do with it.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
