Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

How to achieve great performance to calculate Total column in the get item sharepoint list

(0) ShareShare
ReportReport
Posted on by 5

I want to calculate certain column based on group of data from sharepoint list, then the result would be array that collecting a group of data with total column. Moreover I've created the flow to achieve this with variety of time on the executions start from 2mins until 7mins (with same data) which are low performance for me.

 

Below are my flow :

1. Select 2 -> this is for throwing away unnecessary column

2. Apply to each 2 -> based on 'UniqueName' that contain data we want to group

3. Filter by Series -> to group the data based on 'UniqueName'

4. Calculate Total Downtime -> to calculate the column based on 'Filter by Series'

Capture.PNG

 

Below are the time execution of the flow :

 

 Is there any way to sum of the certain column in the sharepoint list to be faster in the execution?

  • Heli2911 Profile Picture
    Heli2911 5 on at
    Re: How to achieve great performance to calculate Total column in the get item sharepoint list

    hi @Jcook ,

     

    Actually I did your recommendation on the "Apply to each 2", yet the time execution is need 2-7 minutes.

    Capture.PNG

     

  • Jcook Profile Picture
    Jcook 7,770 on at
    Re: How to achieve great performance to calculate Total column in the get item sharepoint list
    Hello @Heli2911

    Can you enable concurrency on your loops.

    This can be done by clicking the 3 dots on your apply to each loop.
    Than click settings,
    Now turn concurrency on,
    And set it’s value to 50.

    Do this for every apply to each loop.
  • Heli2911 Profile Picture
    Heli2911 5 on at
    Re: How to achieve great performance to calculate Total column in the get item sharepoint list

    Below is my time execution :

    Capture.PNG

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard