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

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.

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

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