cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Memorable Member
Memorable Member

How can I use Pagination setting in my flow with SharePoint - Get items action ?

I want to use Pagination setting in my flow with SharePoint - Get items action.

How can I use this setting after turn on Pagination.

1.png

 

 

 

My test environment.

1. SharePoint list which have 5,400 items.

 

My test scenario.

1. Trigger: Schedule - 1 day.

2. Action: SharePoint - Get items.

  Order by = ID

  Top count = 5

  Setting - Pagination = On,

  Setting - Limit = 3

3. Apply to each: value

  3-1, Action: Microsoft Team - post a message

    Message = Expression - item().ID

 

Regards,

Yoshihiro Kawabata

 

7 REPLIES 7
Community Support
Community Support

Hi Yoshihiro,

 

According to this blog about “More action settings and four new connectors”, we know that Pagination enables you to handle more records than are returned in a single call from a service.
https://flow.microsoft.com/en-us/blog/four-connector-action-settings/

 

According to your scenario, I created a simple flow to test the Settings for the action “get items”.


I configured the Top count and Setting-Limit with different value, then I found that if the limit value is smaller than the Top count, then the number of returned items would be Top count.


While if the limit value is larger than the top count, it will hit the limit that I defined in the flow.

 

Have you run the flow on your side? Do you get the same result with me?

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yamao-msft

 

thank you for your reply, and re-pro.

 

I want to figure out 'Top count', 'Setting - Limit', and Each Triggers/Actions.

 

My scenarios:

1. What does the flow need to Pagenation ?

2. What is best flow to copy 5,400 items in SharePoint List to other List ?

3. What is best flow to send messages from 5,000 items in SharePoint List to Microsoft Teams ?

 

For these scenarios, 

I test by Pagenation = On, 'Top Count' = 5, 'Setting - Limit' = 3.

 

My Image flow from 'Setting - Limit' and 'Pagenation' word.

   1st, Action 'SharePoint List - Get Rows' seems to output 3 items, from 1 to 3

   That because , 'Top Count' = 5, and 'Setting - Limit' = 3.

   and

   2nd, Action 'SharePoint List - Get Rows' seems to output 2 items, from 4 to 5.

   That because, same.

 

Or another image from 'Setting - Limit' and 'Pagenation' word.

   'Pagenation' works Triggers, not Actions.

   Each Trigger output smaller than 'Setting - Limit' items for each run.

   For example, For Trigger output total 5 items, and 'Setting - Limit' = 3.

   The flow run 2 times.

   1st run, Trigger output 3 items from 1 to 3.

   2nd run, Trigger output 2 items from 4 to 5.

  But, 'Pagenation' can set in Action 'SharePoint - Get Items'.

 

So, I need to Pagenation example flow.

 

Regards,

Yoshihiro Kawabata

 

 

Hi @yoshihirok

Were you able of copying large list to another sharepoint list? I have the same scenario and my flow is limited to copy 100 items.

 

Thanks in advance!

Hi @yayala

 

Yes, I have 100s, 1000s items in my SharePoint list.

Or, A Trigger  got over 100s items each arrived like very hot twitter keyword

 

And, I hope get over 100s items to do something

 

Regards,

Yoshihiro Kawabata

Thanks @yoshihirok!

I enabled the pagination and my flow works.

But what is the maximum limit that we can give for pagination. I know in SP online there cannot be more than 5K items per view. But I can store more than 1 Lakh records in list. If I give limit as 1Lakh will it be working?

Frequent Visitor

This video should be helpful for those of you trying to use Power Automate for looping through a large number of records: https://youtu.be/5NtzcfmSGes

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (9,009)