Counting rows from a csv file

(0) Share

Report

Posted on by frixel

1,089

Hello all,

I try to make a Flow for counting rows from a csv file.

This what i make but i have the error. What goes wrong?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (3)

Report
Copy link

Link copied!

Hi @frixel :

Do you want to get the number of rows in a CSV file?

Firstly,let me explain why you encountered this problem.

The point is that the content of a CSV file is a string.

I think this link will help you a lot:

What Is a CSV File, and How Do I Open It?

Secondly,You can get the number of rows by parsing the csv text.I'v made a test for your reference:

My CSV

My Flow

The Restul:

Best Regards,

Bof

Was this reply helpful? Yes No
frixel 1,089 on at

Like (0)

Report
Copy link

Link copied!

@v-bofeng-msft

Thanks, that really helps me a lot.

Now I had designated a specific file in my flow (get file content) but how do I adjust the flow if it has to be the file that comes(new) in that folder?

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @frixel :

If you just want to get the newly created file under the specified path, you only need to sort the creation time and get the last record.For example:

In addition,this is a question unrelated to the current topic, I would suggest you to consider creating a new thread.

Best Regards,

Bof

Was this reply helpful? Yes No
55552 682 on at

Like (0)

Report
Copy link

Link copied!

Thanks, this worked for me! The only difference was that I had to subtract 2 from the total row count instead of 1. When I created the csv table (from a get rows in SQL table action), the csv table output had the header row, the data rows, then one extra blank row. Not sure what caused the blank row, but in the end, if I subtracted 2 in the final compose statement, the results were correct.
sub(length(outputs('Compose')), 2)

Was this reply helpful? Yes No