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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.