- 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.
Recent Posts
See AllMicrosoft 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
I have a SharePoint document library called aj, and inside of it, three folders (Test1, Test2 & Test3). I am going to build a flow to check whether a folder exists in aj. If the folder exists, then I
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