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.
How to read only the column with text inside and run the next workflow based on how many rows in that particular column
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