Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / OData Filter in Get Ro...
Power Automate - Building Flows
Answered

OData Filter in Get Rows from Excel

(0) ShareShare
ReportReport
Posted on by HansenvomDeich 182

Hey,

 

i need some help before i get the pure hate to that power automate stuff.

Since 2 Hours, i try to Filter an "Get Rows from excel" Flow.

I Really wanna do that without the Filter Compose, but i read i have to do that.

So my Variabel From is 682 and the To is 692. 
The Excel has 2000 Entrys but i wanna only get that Range from 682 to 692.

I Read 2 Odata Filter in the Excel Flow is not working at the moment.
But the Compose Filter, does not work with that query.

Do you have any Tips?

 

HansenvomDeich_1-1704645302985.png

 



Thank you in advance.


 

  • HansenvomDeich Profile Picture
    HansenvomDeich 182 on at
    Re: OData Filter in Get Rows from Excel

    Hey @creativeopinion ,

    thanks. 

    I will breath the tut in.  

  • Verified answer
    creativeopinion Profile Picture
    creativeopinion 10,439 Super User 2025 Season 1 on at
    Re: OData Filter in Get Rows from Excel

    @HansenvomDeich You need to utilize both the Top Count and Skip Count fields.

    Skip Count:

    This field determines how many rows should be skipped before starting to retrieve rows. Since you want to start at row 682, you should set the Skip Count to 681. This is because the count starts from 0. So, skipping 681 rows will bring you to the start of the 682nd row.

     

    Top Count:

    This field specifies how many rows should be retrieved after skipping. Since you want to retrieve rows from 682 to 692, you need to retrieve 11 rows (692 - 682 + 1 = 11). Therefore, set the Top Count to 11.

     

    creativeopinion_0-1704646816571.png

     

     
    In this tutorial I cover:
    ✅ How to create an Automated Cloud Flow
    ✅ How to dynamically select a Table in the List Rows Present in a Table Action
    ✅ How to use the Parse JSON action
    ✅ How to use the When a file is created (properties only) trigger
    ✅ How to avoid the Apply to Each Action
    ✅ How to Create an Item in SharePoint from Excel Data
     
    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution ✅.
    Consider giving me a 👍 if you liked my response!

    👉 Watch my tutorials on YouTube
    👉 Tips and Tricks on TikTok

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans