• Ajith Madathil

Filtering Excel Rows with Power Automate

Updated: Apr 1


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.

124 views

Recent Posts

See All

The Compose action

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

Blog Categories
 

Beginner

Intermediate

 

Advanced

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
.com
website builder. Create your website today.
Start Now