Hey Team I want to Read from A1 TO N*(Last row)
N(last row is dynamic) how to give index in read range for that?
A1:N?
Are u saying
Hey @Kuldeep_Pandey ,
Read the whole data table Initially
Take Data table Row Count
RowCount = DT.RowCount
Your Last Row will be "N"+(RowCount+1).ToString
Then use one more Read Range by mentioning the lastcell Value
Input Excel:
Flow :
Output :
Regards,
In read range activity inside the range pass “A:A”
In the Filter data table place the A column name and you can take the row which contains the value
Hope this might help you.
4 Likes
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.