Unanswered

Delete the first 2 rows of a .csv file

(0) Share

Report

Posted on by ThomasH

170

Hello, i have in sharepoint a .csv file which have two empty Rows in first, i want to delete this Rows with Power Automate, how can i do that?

Thank you

Categories:

General topics

I have the same question (0)

All responses (13)

Answers (0)

v-jefferni on at

Like (1)

Report

Hi @ThomasH ,

Could you please first parse the csv file in Power Automate flow and share the result with a screenshot, telling us what it looks like?

If you can have the csv table converted to an array in the flow, then you can simply filter this array with the condition that a column is not blank and then get the entries that are not blank.

Best regards,

Was this reply helpful? Yes No
ThomasH 170 on at

Like (0)

Report

I shout create a Connection, what i have to do on this page?

Was this reply helpful? Yes No
ThomasH 170 on at

Like (0)

Report

Hi @v-jefferni with whitch Action i can parse the .csv in Sharepoint?

Was this reply helpful? Yes No
ThomasH 170 on at

Like (0)

Report

Hi @AlexEncodian , how i have to "create File" after "Delete Rows"?

I tried this way

So it dosn't work.

Thank you

Was this reply helpful? Yes No
AlexEncodian 4,409 Moderator on at

Like (0)

Report

@ThomasH

Which action is failing and what is the error message

Was this reply helpful? Yes No
ThomasH 170 on at

Like (0)

Report

@AlexEncodian Hi, my Problem is, i wan't to have the Data in Columns, when i use a .txt as export and convert this with encodian to a .csv in the last Columns i put me la lot of commas.

Whe i import a .csv an delete the first t rows and save it as. csv, then i have no Columns, the content is only in the firts column.

Was this reply helpful? Yes No
ThomasH 170 on at

Like (0)

Report

@AlexEncodian
Hello, sorry for the confusion. I tried a lot to solve the problem, including using the source file as .txt or .xlsx. If I have an .xlsx as the source file where I want to delete the first two lines, it now works if I solve it like in the screenshot.

However, it is then an .xlsx file and I need it as a .csv, which I then tried to achieve with the Encodian Excel Converter by attaching it to the flow as shown in the picture, but it works Flow then runs infinitely and doesn't stop with an error.

The current request is the .xlsx which I am now attaching here to clean up the top two lines and convert them to .csv, but somehow I can't get it solved. Thanks for the help

The Excel in the appendix is shortened; the original has around 160,000 lines

Test1.xlsx

Was this reply helpful? Yes No
DryMouse555 31 on at

Like (0)

Report

Hi, that solution worked for me. But, in my case, I am getting one empty row at the end of csv file. The row count can be increased in the future and everytime, when I export the csv from the sources, I get this empty line. So, I can't mention the row numbers as they may change in the future.
Is there a way to remove empty row at the bottom by default?

Was this reply helpful? Yes No
ThomasH 170 on at

Like (0)

Report

@AlexEncodian Hi, you mean this so?

Was this reply helpful? Yes No
AlexEncodian 4,409 Moderator on at

Like (1)

Report

@ThomasH

In the Convert excel action, looks like you are using a file path. You need to use the filename with the extension only.

Was this reply helpful? Yes No