cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Search Help for parralled Sharepoint create ITEM

Hello,

 

currently, I'm struggle a bit with the performance of sharepoint create item and big excelsheets. My users are uploading an excel sheet with x rows into my sharepoint where I'm catching the sheet with the excel connector "Get Tables" and afterwards "List rows present in a table". As next the data should be written into a sharepoint list.  As example 1500 rows takes in our environment around 1 Hours and that it's way to long.  

 

I'm searching now a way how I can split my result of ""List rows present in a table" into different seperate results, which I can load with additional paralleles branches of create item into my sharepoint.

 

Someone have any idee ?

 

Unbenannt.PNG

 

 
 
6 REPLIES 6
Highlighted
Dual Super User III
Dual Super User III

Re: Search Help for parralled Sharepoint create ITEM

Hi!

Did you explore this option?

https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Degree-of-Parallelism-in-Power-Aut...

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Frequent Visitor

Re: Search Help for parralled Sharepoint create ITEM

Yes, I have already set the value to max (50).

Highlighted
Frequent Visitor

Re: Search Help for parralled Sharepoint create ITEM

Ok it looks not so cool but working as expected. 

 

I'm executing "List rows present in table" now two times. First time to get the value of my unknown rows. The secound time I use the top count to catch my limit date. I'm doing max rows minus max rows and then I add my variable with a limit integer. With my variable I can set a hardcoded value for a fix data value. Maybe I find a way to make it more dynamic

 

 

 

Top count experession = 

add(variables('vTopCountTableExcel'),sub(int(length(body('List_rows_present_in_a_table_3')?['value'])),int(length(body('List_rows_present_in_a_table_3')?['value']))))

 

Unbenannt.PNG

Highlighted
Frequent Visitor

Re: Search Help for parralled Sharepoint create ITEM

Do someone knows if sharepoint online blocks multiple creation action or create Items blocks itself ? i created now different create item "imports" which catching different rows from my loaded excelsheet. But i'm not able to get as lower 10 min for an import

 

Unbenannt.PNG

Highlighted
Dual Super User III
Dual Super User III

Re: Search Help for parralled Sharepoint create ITEM

@Fanatic 

I believe the limit you are facing is either the Sharepoint API throughput...

https://docs.microsoft.com/en-us/connectors/sharepointonline/#limits

...or any other limit related to Power Automate (Actions executions per 5 minutes, Actions concurrent outgoing calls...)

https://docs.microsoft.com/en-us/power-automate/limits-and-config

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Frequent Visitor

Re: Search Help for parralled Sharepoint create ITEM

mm..  I saw some people switched to http request for get items etc. I have not enough experience with it . Is it possible to use it for Import to ? to compare any Speed ?

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Users online (4,801)