Group by array item

[WebPortal]

This is my array:

[
  {
    "@odata.etag": "W/\"JzEtVGFzadfdsfyAgQEBAQEBAQEBAQEBAQEBARCc=\"",
    "planId": "johCFoq4sdsdasnEyhOcbgjLkzN5YAFYWU",
 .....
  }
]

I've managed to get the unique values of the "userId", and got this array:

[
  "25e6bf64-416e-45c2-8350-9f747027d3c5",
  "9c950320-9981-45a3-b31e-2cd31d69d51a"
]

I'd like to end with an array that groups per "userid":

• "title"
• "dueDateTime"

So, per each user, the title of the tasks and due dates.

I have no clue how to do this with Power Automate, checking the docs didn't help that much...

[WebPortal]

@Paulie78 

thanks, I'll give it a try.

[WebPortal]

@Paulie78 
I renamed the file extension to .json, but Power Automate is telling me it needs a zip extension, so I added the json file to a zip folder but it is returning the error:

Something went wrong. Please try again later.

[Paulie78 · Accepted solution]

@WebPortal here is the export again as a zip:

https://www.tachytelic.net/wp-content/uploads/GroupByArrayITem_20201120170450.zip

[WebPortal]

Fantastic, I'll try to understand it and apply to my case.

Thank you so much for you help!

[WebPortal]

I think I got it - FINALLY!

Thank you!

[Paulie78]

Well done! 🙂