Unanswered

Get every single item from chunk array

(0) Share

Report

Posted on by ramadhanira

Hi,

I need to get all single items from chunk array and add a row into table Excel using apply to each, how to achieve this?

2023-12-14 22_14_23-Window.png

Categories:

General topics

All responses (8)

Answers (0)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ramadhanira

so this single array would be a single row ?

just to confirm ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
mkilp91 41 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm a bit confused by the question. Do you mean that you need all items in each array as one item to put into an Excel row, or are you trying to eliminate duplicate values?
ramadhanira 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes correct @Nived_Nambiar
ramadhanira 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes correct @mkilp91
ramadhanira 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Here is my flow, get items from SharePoint chunked 22 items then add into row dynamics table Excel
mkilp91 41 on at

Like
a
(0)

Report
Copy link

Link copied!

@ramadhanira I think I have a better understanding of what you are trying to do. The first 22 items would be row 1 in Excel. The next 22 items would be row 2, and so on.

Another question, are you wanting each value in the chunk to exist in its own cell in the row (22 columns), or are you wanting one cell to contain all 22 items (one column)? The approach for achieving this would vary depending on the desired result.
ramadhanira 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mkilp91,
No, I want 1 item each on 1 row until 22 item.
mkilp91 41 on at

Like
a
(0)

Report
Copy link

Link copied!

@ramadhanira Because we are dealing with an array of array items, I am getting confused on your specific goal for this flow. Are you considering a chunk of 22 values to be an "item" or are you considering a single "HC0XXXX" value to be an item?

Here are some screenshots that may help me better understand what you are trying to accomplish:

Assuming this is true:

Are you wanting the rows to look like Option A - row 2 (chunk 1) or Option B - row 4 (chunk 2):

Or are you wanting it to look like option C - each item of a chunk on a new row: