Unanswered

Order array (JSON) by field value (date)

(0) Share

Report

Posted on by ncd

Hi there, I am trying to order by "start_time" a JSON object with the following structure:

{
 "Events": [
 {
 "id": "1",
 "start_time": "2023-11-26T03:00:00Z" 
 },
 {
 "id": "2",
 "start_time": "2023-11-26T02:00:00Z" 
 }
 ]
}

I've tried doing it with PA Desktop's Javascript scripting but cannot wrap my head around it (cannot use basic JS syntax like "const", cannot return the entire array with WScript.echo() , ...)

Any idea of how to do this? I am fine with either PA Desktop or PA Cloud solutions, whatever is more performant and easy to implement.

Cheers.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Rhiassuring 8,692 Moderator on at

Like (0)

Report
Copy link

Link copied!

sort(variables('objYourObjectHere')?['Events'],'Start_Time')

Need to call out where the arrays are (in "Events" object), and then what value you want to sort by.

If you want it reversed, you can wrap it in reverse().

Was this reply helpful? Yes No
yoko2020 495 on at

Like (0)

Report
Copy link

Link copied!
Powershell in PAD

# Your JSON string $jsonString = '{ "Events": [ { "id": "1", "start_time": "2023-11-26T03:00:00Z" }, { "id": "2", "start_time": "2023-11-26T02:00:00Z" } ] }' # Convert JSON string to PowerShell object $jsonObject = ConvertFrom-Json $jsonString # Sort the "Events" array based on the "start_time" property $sortedEvents = $jsonObject.Events | Sort-Object start_time # Update the sorted array back to the original object $jsonObject.Events = $sortedEvents # Convert the updated object back to JSON string $sortedJsonString = $jsonObject | ConvertTo-Json -Depth 100 # Display the sorted JSON string Write-Host $sortedJsonString

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Use Convert JSON to custom object if it's not converted yet. Then use Sort list and sort %JsonAsCustomObject['Events']%.

Under Advanced options, enable the "Sort list by items' properties" toggle and provide the specific property you want to sort by - in your case "start_time".

-------------------------------------------------------------------------

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.

Was this reply helpful? Yes No