How to read only the column with text inside and run the next workflow based on how many rows in that particular column

Help Studio
, ,
1

My current workflow is reading the fixed range and the workflow runs well. However I would like to change the fixed range to a flexible one, for example today I have 10 rows in column A and I don’t want to change the range as it is troublesome to edit it everyday. If I set the range as “A:A”, the workflow will keep running even after the 10th item.

2

The outcome that I expect is to run the workflow based on number of rows in the column

3

Use this - Read Range with Range = “” i.e, get the whole Excel as DataTable

Then get the count of the non empty cells of column A as below -

Count = DT.AsEnumerable.Where(function(row) not String.IsNullOrWhiteSpace(row(0).ToString.Trim)).Count

Using the Count to write your logic