Specify the range to read Excel with Power Automate Desktop

[Makiyo]

When reading Excel with Power Automate Desktop, it can read up to the blank,

but what about reading up to the line above that contains a certain character?

For example,

In the Excel below, I would like to read the table from the 2nd row of column A to the 6th row of column M, so is it possible to read the rows above "# N/A" in column A?

[VJR]

Hi @Makiyo 

Not sure if there is a direct way in Power Automate Desktop.

Consider using the IFERROR formula in your Excel

Before using IFERROR

After using IFERROR to make the #N/A cell as blank

This will still show a blank row in PAD datatable

But while looping through the table you can skip that row if it is blank (or delete that row).

PS: In the IFERROR you can also give a meaningful message instead of blank.

And then check that message in PAD.

[Makiyo]

Thank you for your answer.

But, is it possible to read above a special number or letter ?

For example, 

In the Excel below, is it possible to read from the 2nd row of column A to column M the rows above '雑費' in column A if I cannot sure, which row '雑費' is on?

[VJR]

Use the "Find and replace cells" action. Select "find" in the dropdown.

Search for the required word.

It will return you the row number where it was found.

Then use that row number for returning the desired range of cells.

[Makiyo]

Thank you so much.

It worked out that way.
I set to get the cell with a certain character, and read above the -1 row where that cell is.