Read Range1

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?

Hi @Kuldeep_Pandey

Can you try “A1:A”?

Hope this helps,
Best Regards.

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:
image

Flow :
image

Output :
image

Regards,

Hi @Kuldeep_Pandey

In read range activity inside the range pass “A:A
image

In the Filter data table place the A column name and you can take the row which contains the value
image

Hope this might help you.

4 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.