Answered

How to count number of cells in first row of csv file

(0) Share

Report

Posted on by Christo1

How to count number of cells in first row of csv file using power automate?

Scenario will be like

When an CSV file is created on one drive count no of cells in first row of csv file

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Christo1

Try this :

Result is

I have intitially split the CSV by a return line (literally a single return - i.e. press your return key on keyboard in a compose). This I choose the first line as object 0 and split by a comma. Then I take the length.

This is worth reading https://www.damobird365.com/how-to-parse-a-csv-to-json-array-flow
depending on where you CSV comes from, the encodig of the return line might not be as straightforward as a return line on a keyboard.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Was this reply helpful? Yes No
Christo1 27 on at

Like (1)

Report
Copy link

Link copied!

Thank you so much @DamoBird365

Its working now

Was this reply helpful? Yes No