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

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Sharepoint modified item trigger large list

(0) ShareShare
ReportReport
Posted on by 86

Hello guys!


I'm trying to trigger a Flow on Item Modification on a List of 7.000 items. It fails with the message that list has too many items within it's view mode. The same error when filtering more than 5.000 items to display.

 

Is it possible to filter this list to show only the few last items to trigger this Flow?

 

Thanks!

Categories:
I have the same question (0)
  • Verified answer
    v-monli-msft Profile Picture
    on at
    Re: Sharepoint modified item trigger large list

    Hi Schneider,

     

    SharePoint has the 5000 items in a list limitation, and that is the reason why you cannot got it work in Flow. but modern lists are one of the steps along the way to lifting that query limitation. We don’t have a timeline to share yet, but it is actively being worked on.

     

    Regards,

    Mona Li

  • Schneider Profile Picture
    86 on at
    Re: Sharepoint modified item trigger large list

    Thanks! I had to remove all item from this list (created to send mail via SendGrid with From, To, Subject, Body... columns) so when an item is modified/created it sends the e-mail then afterwards deletes the current item so no items can be found on the list, therefore no problems with 5k query limits.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 614 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 401 Moderator

#3
chiaraalina Profile Picture

chiaraalina 282

Last 30 days Overall leaderboard