Remove First 8 Rows of an Array

(0) Share

Report

Posted on by HD-04081521-0

All,

How do I remove the first 8 rows of the below Array?

(Note i cant use HTML table and select the rows, because there are multiple excel files which all have slightly different rows, expect these first 8 which are all the same)

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Pacel1 79 on at

Like (0)

Report
Copy link

Link copied!

Its not exactly deleting rows, this data is represented as json.

you should be able to take specific columns using Select action.

Second way is to use Parse Json action, and adjustments in json schema, to meet Your needs

If you found my response helpful, feel free to mark it as the solution or give it a thumbs-up!

Was this reply helpful? Yes No
Suggested answer

HD-04081521-0 12 on at

Like (1)

Report
Copy link

Link copied!

I found a solution online: Thanks All

Was this reply helpful? Yes No
Suggested answer

Ellis Karim 12,024 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Another option is to use a Select action:

The expressions I used are:

range(8, sub(length(body('Filter_array')),8)) body('Filter_array')[item()]

Ellis

Ellis Karim's Blog – IT doesn't have to be complicated!

Was this reply helpful? Yes No
Ellis Karim 12,024 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Looking properly at the image I seem to have mis read the question. The best approach will be to remove properties

Was this reply helpful? Yes No