Power Automate

remove first row of csv

(2) Share

Report

Posted on by nick9one1

353

Hi, I have a relatively simple flow that create a CSV file. But I need to remove the header row, how can I do this?

thank you

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Kalathiya 2,151 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @nick9one1,

Please try below:

Please add below code Create CSV Action From Property:

skip(body('Parse_JSON'), 1)

It will just skip 1st row.

Please let me know if you are facing any issue.

---------------------------------------------------------------------------------

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

2 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Assisted by AI

nick9one1 353 on at

Like (0)

Report
Copy link

Link copied!
unfortunately that only seems to skip the first character?

I've managed to do it like this (Gemini's answer)

Method 1: The "Split, Skip, Join" Method (Recommended)

This method is the most reliable because it breaks the process down logically: Split the text into an array, Skip the first item, and Join it back together.

You can do this in a single "Compose" action using one complex expression, or break it into steps. Here is the single-expression approach:

The Expression:

join(skip(split(outputs('Get_file_content')?['body'], decodeUriComponent('%0A')), 1), decodeUriComponent('%0A'))

Breakdown of the steps:

Get your file content: Ensure you have the file content (e.g., from "Get file content").

Add a "Compose" action.

Insert this expression into the input (replace outputs('Get_file_content')?['body'] with your actual dynamic content):

split(..., decodeUriComponent('%0A')): This turns your text into a list of rows by splitting it at every "New Line" character (%0A).

skip(..., 1): This removes the first item (row 0) from that list.

join(..., decodeUriComponent('%0A')): This puts the remaining rows back together into a single string, separated by new lines.

Was this reply helpful? Yes No
Suggested answer

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi

Like @nick9one1 and @kalathiya mentioned some good solutions. Here is another way to do as well.

The above expressions decodeUriComponent is for adding new line for each rows we collected

decodeUriComponent('%0A')

The finally outside the loop

This method works as well. Bear in mind that it uses a loop to retrieve the data, which may cause some performance issues. However, this depends on how many records you are retrieving from your data source.

Thanks

Was this reply helpful? Yes No