web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power Automate List Ta...
Power Automate
Answered

Power Automate List Table Rows to list most recent rows added

(0) ShareShare
ReportReport
Posted on by 32

I am attempting to work on a solution regarding how I can continue to allow updates within the most recent 250-500 entries from my SP -> Excel flow. Currently I am utilizing the below solution to be able to update entries after I get past item 256. Currently with this solution I have found while it does currently resolve my issue it does however 1) require having to continually go back to increase the threshold and 2) takes a longer time for my flows to function because it is scanning through all of the rows of the data.

Solved: Re: 256 rows limit - Power Platform Community (microsoft.com)

 

clemett1_0-1704910244888.png

 

 

What I am trying to find out is if there is a way for the system to instead on read the FIRST 256 entries to instead read the most RECENT 256 entries within the database. I.E. in a dataset of 1,000. When I attempt to update the list rows function will look through item ID 744 – 1000 instead of 1-256 and continue to roll as new entries are being added.

Categories:
I have the same question (0)
  • Verified answer
    v-yueyun-msft Profile Picture
    Microsoft Employee on at

    Hi , @clemett1 

    Can you try to use the order by field :

    vyueyunmsft_0-1704936907640.png

    ColumnName desc

     

    So, it will return the last 256 rows in your Excel table.

     

    If this reply can help you , you can click mark this reply as solution, thanks in advance!


    Best Regards,

    Yueyun Zhang

     

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 632

#2
Haque Profile Picture

Haque 458

#3
Valantis Profile Picture

Valantis 357

Last 30 days Overall leaderboard