Filtering Excel Rows with Power Automate

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.