Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Get item has 500 limit

(0) ShareShare
ReportReport
Posted on by

Hi

 

I have a flow that works on a recurrence (every day) and will get items from a list of nearly 900 before filtering and sending an email based on a certain detail in the list. However the get items function will only work for the first 500 list items So it is ignoring nearly half of my data.

 

Is there any way I can fix this? If not when will you be able to make a change to this?

 

Thanks,

Phoebe

Categories:
  • Re: Get item has 500 limit

    Thank you.

     

    That was exactly what I needed. Feel a bit daft for not noticing, but now I will set it to a large enough number that it should always work.

     

    Thanks again,

    PIC

  • Verified answer
    v-yamao-msft Profile Picture
    v-yamao-msft on at
    Re: Get item has 500 limit

    Hi PIC,

     

    By default, the Maximum Get Count of the action “SharePoint>Get items” will only return back 256 items. In order to get more items, please try to set the “Maximum Get Count” underneath the advanced option to a larger value.

    1.png

     

    Please try if this works for you.

     

    Best regards,
    Mabel Mao

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard

Featured topics