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