Unanswered

Collect only Part of Nested Array

(1) Share

Report

Posted on by Rex2025

I have an array that I ClearCollect into a collection of Items, then a nested table for "Days", and then a nested table for "activities."

In the 2nd nested array of "Days", I need to only keep the first item in the array.

So for example, in the first item of days, under day #2, I want to keep only the 1st item category 837.

Before:

[
 {
 "OriginDate": "2024-07-08", 
 "Identifier": 21523, 
 "days": [
 {
 "dayNumber": 1, 
 "activities": [
 {
 "category": 123,
 "sport": true
 }, 
 {
 "category": 435,
 "sport": false
 }
 ]
 }, 
 {
 "dayNumber": 2, 
 "activities": [
 {
 "category": 837,
 "sport": false
 }, 
 {
 "category": 827,
 "sport": true
 }
 ]
 }
 ]
 }, 
 {
 "OriginDate": "2024-07-09", 
 "Identifier": 21523, 
 "days": [
 {
 "dayNumber": 1, 
 "activities": [
 {
 "category": 123,
 "sport": true
 }, 
 {
 "category": 435,
 "sport": false
 }
 ]
 }, 
 {
 "dayNumber": 2, 
 "activities": [
 {
 "category": 837,
 "sport": false
 }, 
 {
 "category": 827,
 "sport": true
 }
 ]
 }
 ]
 }
 ]

Desired After:

[
 {
 "OriginDate": "2024-07-08", 
 "Identifier": 21523, 
 "days": [
 {
 "dayNumber": 1, 
 "activities": [
 {
 "category": 123,
 "sport": true
 }, 
 {
 "category": 435,
 "sport": false
 }
 ]
 }, 
 {
 "dayNumber": 2, 
 "activities": [
 {
 "category": 837,
 "sport": false
 }
 ]
 }
 ]
 }, 
 {
 "OriginDate": "2024-07-09", 
 "Identifier": 21523, 
 "days": [
 {
 "dayNumber": 1, 
 "activities": [
 {
 "category": 123,
 "sport": true
 }, 
 {
 "category": 435,
 "sport": false
 }
 ]
 }, 
 {
 "dayNumber": 2, 
 "activities": [
 {
 "category": 837,
 "sport": false
 }
 ]
 }
 ]
 }
 ]

Any idea how I can do this?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Michael E. Gernaey 53,963 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Rex2025

How do you determine which things you want to keep? In your example, you kept both in day 1?

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Rex2025 on at

Like
a
(1)

Report
Copy link

Link copied!
So the array goes (indents for nests)
Item
First level
Second level item
second level item
Possibly more… a “n” number
first level
Second level item
possibly more
item #2
It repeats that JSON format.

At the first level I want all the items from the first second level, but only the first item from Index, 2 of the second level.

So, if it is:
Item 1
Day 1
Cat
dog
sheep
Day 2
Lizard
Horse
lion

I want everything from Day 1, but only Lizard from Day 2.

Was this reply helpful? Yes No
Michael E. Gernaey 53,963 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Rex2025

Nice share thank you.

So you'll have Many Items, all with Day 1 and Day 2. Ok just curious, are there other patterns like this. where Day3 or Day4-7 matter? I just want to either give you the fastest without caring because it won't change, or a strategy to do different patterns before I start.

Thanks!

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Rex2025 on at

Like
a
(1)

Report
Copy link

Link copied!

My power automate flow that I built is only returning Days 1 & 2, so that is what I will always get.

But where I’ve struggled in the flow is limiting Day 2 to just 1 item.

If you have a solution in power automate, my current strategy has been a Select function, then

take(item()?[‘day’], 2)

That still returns all items though in Day 2.

Was this reply helpful? Yes No
Michael E. Gernaey 53,963 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Rex2025

I promise I will give you a solution later today, its 130 am and going to bed. But yes can easily give you that when i get back.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
Rex2025 on at

Like
a
(1)

Report
Copy link

Link copied!

Hey! No worries & no rush. I appreciate any and all help I can get!

Was this reply helpful? Yes No
Rex2025 on at

Like
a
(1)

Report
Copy link

Link copied!
I wanted to throw in an actual sample of my data to help.

In the dutyPeriodNumber 2, I want to only keep the first item under "legs" while retaining the array format.

[ { "sequenceOriginDate": "2024-07-16", "sequenceNumber": 28441, "sequenceStartDateTime": { "localTime": "2024-07-16T04:10:00", "gmt": "2024-07-16T09:10:00" }, "sequenceEndDateTime": { "localTime": "2024-07-18T16:28:00", "gmt": "2024-07-18T21:28:00" }, "dutyPeriods": [ { "dutyPeriodNumber": 1, "odMinutes": 577, "numberOfLegs": 2, "legs": [ { "legNumber": 361, "legIndex": 1, "blockTime": 215, "groundTime": 120 }, { "legNumber": 1622, "legIndex": 2, "blockTime": 167, "groundTime": 0 } ] }, { "dutyPeriodNumber": 2, "odMinutes": 376, "numberOfLegs": 2, "legs": [ { "legNumber": 2827, "legIndex": 3, "blockTime": 97, "groundTime": 80 }, { "legNumber": 2043, "legIndex": 4, "blockTime": 124, "groundTime": 0 } ] } ] } ]

Was this reply helpful? Yes No