Specify the range to read Excel with Power Automate Desktop

(0) Share

Report

Posted on by 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?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Sort by

VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Makiyo 6 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Makiyo 6 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No