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.
This returns the top/maximum number of records that should be returned.
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.