Remove first 3 rows from a txt

(0) Share

Report

Posted on by rogerlopez21

Hello!
I have a txt file sent by email, I want to delete/skip the first 3 rows/lines:

I want to keep the headers:

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report
Hi @rogerlopez21

Here is the sample flow.

1. Create an automated flow & choose "When a new email arrives" as the trigger. You could apply filter on sender, to, cc, subject etc. based on the need. Here I have applied filter on subject for demo purpose:

2. Next, add "Get attachment" action to get the content of the email attachment. Pass message id and attachment id dynamically from the previous action. The action will be automatically wrapped inside 'Apply to each' after passing the input parameters:

Finally, inside Apply to each block add compose action to get the final text with first 3 lines skipped. We will use expression to skip the first 3 lines. Expression needs to be added in the expression box as shown below:

join(skip(split(base64ToString(outputs('Get_Attachment_(V2)')?['body/contentBytes']),decodeUriComponent('%0D%0A')),3),decodeUriComponent('%0D%0A'))

The output of compose action will give the required text. You can create a new file by passing the output of compose action or share it in the email.

Input text file:

Output of compose action:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Ellis Karim 11,681 Super User 2025 Season 2 on at

Like (1)

Report
Hi @rogerlopez21 ,

It seems like that the file is a csv text file. You could try the following:

The Apply to each loop is used to handle 1 or more text file attachments:

The Compose actions transform the file in steps:

Here are the expressions used in the Compose actions:

Compose: base64ToString(item()?['contentBytes']) Compose: 2: split(outputs('Compose'),decodeUriComponent('%0D%0A')) Compose 3: skip(outputs('Compose_2'),3) Compose 4: join(outputs('Compose_3'), decodeUriComponent('%0D%0A'))

Finally create the new file:

You could later merge the all the expressions into a single expression and use that as the File Content in the Create File action:

join(skip(split(base64ToString(item()?['contentBytes']), decodeUriComponent('%0D%0A')),3),decodeUriComponent('%0D%0A'))

See also: Solved: Re: Looping through Get File Content - Power Platform Community (microsoft.com)
Ellis
____________________________________
If I have answered your question, please mark the post as ☑️ Solved.
If you like my response, please give it a Thumbs Up.
My Blog Site

Was this reply helpful? Yes No
rogerlopez21 13 on at

Like (0)

Report

It worked, thanks you for your feedback!

Was this reply helpful? Yes No