'Create item' sharepoint limit

[craigmk1987]

Hello, 

Is it possible to overcome an apply to each limit of 100 items when using a sharepoint connector? I see that "get items" has the option under pagination to increase the number of items. 

What am I trying to do? I'm trying to query the graph explorer and request time off reasons between a defined time (e.g. 2021) and populate that to a sharepoint list. 

The graph query works fine and extracts the information I'd like, which I am parsing through a json connector...the bit that I'm stumbling upon is that when I try to create an individual list item, I am reaching a 100 item limit. 

The flow looks like:

Any assistance or direction to another method would be much appreciated

[abm]

Hi @craigmk1987 

Can you set the limit to 100 records in your HTTP request and implement a recursive call back to same HTTP until all the records are retrieved? Do may need to look the Do Until loop action step to achieve this.

Thanks

[craigmk1987]

Thank you for your reply. 

I'm not sure that you can set up a limit on the http request I was using:

I'm not familiar with using the "do until loop". Are you able to point me in the right position

[abm]

Hi @craigmk1987 

You can't set the limit under the settings.

To retrieve using Do Until please see 

How to get more than 5000 items from SharePoint Online in Flow - Alex Tofan's blog

In your case you need to use the HTTP action step and increment the pagination records under the loop.

Thanks

[craigmk1987]

Thank you, I've had a brief look and will see if i can find what I'm looking for here 🙂

[craigmk1987]

Hello Abm, I've looked at the loop until function that you suggested (thank you again!). 

I have managed to get my http request to create more than one item, but I'm not getting duplicate entries of the same thing (agh!). I'm sure the solution is probably quite simple, but I wondered if you had any suggestions.

This is how my flow now looks:

123

[abm · Accepted solution]

Hi @craigmk1987 

Not sure what you meant by not getting duplicate entries. I was expecting the http action inside the Do until loop and in each iteration you need to change the number of record parameters each time, so that you can retrieve all the records 1 to 100, 101 to 200 and so on. Also for this your HTTP API should support pagination.

Thanks