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

Picture1.png

I have the same question (0)

All responses (4)

Answers (0)

Pacel1 79 on at

Like (0)

Report

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

I found a solution online: Thanks All

Was this reply helpful? Yes No
Suggested answer

Ellis Karim 11,683 Super User 2025 Season 2 on at

Like (0)

Report
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 11,683 Super User 2025 Season 2 on at

Like (0)

Report

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