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?
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?
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.
Thank you for your answer.
But, is it possible to read above a special number or letter ?
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?
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.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!