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'
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?
hi @Jcook ,
Actually I did your recommendation on the "Apply to each 2", yet the time execution is need 2-7 minutes.
Below is my time execution :