Sorting an array by date (sharepoint history version)

(0) Share

Report

Posted on by WorkingRicardo

853

So I filtered a Sharepoint list item history version and the selected two fields I needed:
{
"Created": item()?['Created'],
"Estado": item()?['Estado']
}

From that I get this:

[
  {
    "Created": "2025-02-26T08:05:14",
    "Estado": "Processed"
  },
  {
    "Created": "2025-02-24T15:44:09",
    "Estado": "Processed"
  },
  {
    "Created": "2025-02-21T09:04:09",
    "Estado": "Processed"
  }
]

So basically to find out when a Status "Estado" has changed. I can see it changed to Processed on 2025-02-21T09:04:09, but have no I dea how to tell Power Automate to just then filter just that older one. After the Sharepoint list item was edited two more times, but no change on "Estado", I don't need that info, just WHEN the change was made from X to "Processed".

How would I acheive this? Ty in advance!

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Chriddle 8,504 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!
Sort by 'Created', then take the first item:

first( sort( outputs('Compose'), 'Created' ) )

Was this reply helpful? Yes No