Unanswered

How to find number of rows in Excel table AND add plus one

(0) Share

Report

Posted on by Goromi

Hello Community,

I am creating a Flow which works with an Excel table. The unique identifier of the rows is an index number and there is a do-until within a script. My goal is to have the script run until the last row of the table. Everything is working well, except the total number of rows.

I know the formula to find the number of rows within the table, but since the index starts with 2, the script always skips the last item, meaning I need to add +1 to the below formula somehow.

Expression used: length(body('ColumnName')?['value'])

Could you please advise how to 'add plus one' to this expression?

Thank you!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

sumurthy Microsoft Employee on at

Like (0)

Report
You can us getRowCount() API to get correct row count of a table

function main(workbook: ExcelScript.Workbook) { let sheet = workbook.getWorksheet("Sheet7"); let rowCount = sheet.getTables()[0].getRowCount(); //Doesn't count header or exapnsion row console.log(rowCount) }

Was this reply helpful? Yes No
Verified answer

Goromi 11 on at

Like (0)

Report

In the meantime I have found a much simpler solution. I used the following expression:
add(1,length(body('ColumnName')?['value']))

Thank you @sumurthy for your help

Was this reply helpful? Yes No