Count rows in a CSV table

[bchager6]

Hello,

I created a Flow within a Power BI report that populates a .csv table based on projects selected in the Power BI report, then it sends the .csv in an email.

I would like to count the number of rows in the .csv table and create a condition to send only if the number of rows selected are less than 5. 

Can anyone guide me on how to arrive at the row count in the .csv table that's created? From there, I can apply a condition.

[abm · Accepted solution]

Hi @bchager6 

I can see you already using an array for creating the CSV file. You could try the length() expression, pass the parameter as the array.

If that doesn't work follow the below steps.

Above under the EnterKey variable press the keyboard enterkey as the default value.

Above expression I used is as follows:

length(split(body('Create_CSV_table'),variables('EnterKey')))

This length will give you the contents with header. If you want to get the contents row count only then use the sub() expression to subtract 1 from the total lines.

Thanks

[bchager6]

This worked. Thank you!