Answered

'Create item' sharepoint limit

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
craigmk1987 82 on at

Like (1)

Report

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

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
craigmk1987 82 on at

Like (2)

Report

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

Was this reply helpful? Yes No
craigmk1987 82 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No