You’re offline. This is a read only version of the page.
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?
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.
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?
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.
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (
