I am trying to create 7000 items in a sharepoint list from an excel file with the 7000 records. The flow just create 256 and stops. in List rows present in a table settings, Changing pagination to 5000 does not work.
What can i do?
Solved! Go to Solution.
Hi @andygp25
I did created an excel sheet which contains 10,000 records. Below is my flow.
For the Excel connector (List Rows Present in a table) settings I did set threshold as 10,000 and set the Pagination On.
The compose expression I am using under the compose is as follows:
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my bloghi @andygp25 you need to follow this post.
Proud to be a Flownaut!
Hi @andygp25 ,
The action "List rows present in a table" of Excel (Business) connector have the 256 rows limit in microsoft flow currently.
If you would like the limit of action "List rows present in a table" of Excel (Business) connector would be 7000 rows,
I afraid that there is no way to achieve your needs in Microsoft Flow currently.
If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
Best regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @andygp25
I did created an excel sheet which contains 10,000 records. Below is my flow.
For the Excel connector (List Rows Present in a table) settings I did set threshold as 10,000 and set the Pagination On.
The compose expression I am using under the compose is as follows:
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogI have tried the same. I update you soon.
Hi @abm,
The solution is working well. Thanks a lot.
However, I am unable to put the threshold limit to 10000. The maximum is 5000.
Thanks in advance.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
30 | |
29 | |
29 | |
20 | |
11 |