• Ajith Madathil

Filtering Excel Rows with Power Automate

Updated: Apr 1, 2020

Below is my Excel sheet ProdDetails.

Retrieving all of the rows

To manipulate this data in Power Automate, first we will retrieve all of the rows:

This action will returns all the rows from excel sheet.

  • The maximum size of an Excel file that is supported by the Excel Online (Business) connector is 25 MB.

  • The maximum size of an Excel file that is supported by the Excel Online (OneDrive) connector is 5 MB.

Filtering the data

Next, we will look at filtering the data. To do this we will use the Filter Query property.

This returns three rows where matched Id is equal to 101.

If the filter value is a string or alphanumeric then you need to put single quotes around it.

See below where I am going to filter for Id A500

Supported filter functions are: eq, ne, contains, startswith & endswith

To order the data use the syntax:

[Column name] desc/asc

Eg: Price order by desc. See below.

Top Count

This returns the top/maximum number of records that should be returned.

Skip Count

This is used for number of records that should be ignored. Skip is generally used for pagination which is used for retrieving large amount of data.

Thank you for reading.

2,333 views1 comment

Recent Posts

See All

Microsoft Power Automate (aka Microsoft Flow) provides lots of action steps out of the box. My favourite one is Compose. What does it do? What is the Compose action? The Compose action is like a stati

In this blog post I will access NASA's Astronomy Picture of the Day (APOD) API using Power Automate. The plan is to retrieve the picture of the day using the API and store it in a SharePoint document

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.