• Ajith Madathil

Retrieving a row from an Excel table using Power Automate

Updated: Apr 1

The Power Automate action Get a row retrieves a single row from an Excel table.

Here I am using a valid key value (P2) which exists in my excel sheet.

Flow found a single row. Below is the output.

When I use a key that is a string, Power Automate returns an error.

If I try using an invalid key value (P23333).

This results in a 404 error.

Duplicate rows

Below I have an excel sheet that contains three rows with Id 101!

When I try to retrieve them:

Power Automate returns the first matched row. Below is the output:


Action step Get a row retrieves a single row from an Excel table.

For duplicated row keys, it returns a single first matched row.

There is no need to use single quotes for string values.

If there is no match Power Automate will fail and return a 404 error.

If you want to handle the exception, then you could Configure run after setting ‘has failed’ in your next step.

Blog Categories





Power Automate Essentials

How can I help you?

I am happy to help at any time.  You can contact me via the official PowerAutomate community forum.  Tag me (@abm) on any post you make there if you would like to me take a look at it.

I am always available for both corporate training or 1-2-1 training for individuals. 

© 2023 by Walkaway. Proudly created with Wix.com

  • Twitter Black Round
This site was designed with the
website builder. Create your website today.
Start Now