cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Makiyo
New Member

Specify the range to read Excel with Power Automate Desktop

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?

12.jpg

 

 

4 REPLIES 4
VJR
Super User
Super User

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

 

VJR_0-1634699113564.png

 

 

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

 

VJR_1-1634699195750.png

 

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).

 

VJR_2-1634699296954.png

 

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

And then check that message in PAD.

 

VJR_3-1634699394351.png

 

Makiyo
New Member

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?

13.jpg

VJR
Super User
Super User

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
New Member

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.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

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.

Users online (3,320)