cancel
Showing results for
Did you mean:
Resolver I

## Average calculation for all SP list items column

Hi all,

Is there a method to calculate the entire column of an SP List (formatted as hh:mm:ss) and find the average time? The list qty is currently at 500 items but is growing.

I’ve tried various methods with either they are coming up with an error or I get a blank value. I’m not sure if this is down to the limitations of the formulas I’ve tried or if I’m just getting them wrong.

I have also tried including a gallery for the formula to look at but again Income up empty.

1 ACCEPTED SOLUTION

Accepted Solutions
Most Valuable Professional

Hi @MiniMe_83 ,

Firstly, this is not Delegable, so the maximum you will be able to do this with is 2,000 items (although you can use a filter to get this down if possible)

``````With(
{
wTime:
SPList,
"Seconds",
Value(
Left(
YourTimeField,
2
)
) * 3600 +
Value(
Mid(
YourTimeField,
3,
2
)
) * 60 +
Value(
Right(
YourTimeField,
2
)
)
)
},
Average(
wTime,
Seconds
) / 3600
)``````

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Most Valuable Professional

Hi @MiniMe_83 ,

Firstly, this is not Delegable, so the maximum you will be able to do this with is 2,000 items (although you can use a filter to get this down if possible)

``````With(
{
wTime:
SPList,
"Seconds",
Value(
Left(
YourTimeField,
2
)
) * 3600 +
Value(
Mid(
YourTimeField,
3,
2
)
) * 60 +
Value(
Right(
YourTimeField,
2
)
)
)
},
Average(
wTime,
Seconds
) / 3600
)``````

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Announcements

#### April 4th Copilot Studio Coffee Chat | Recording Now Available

Did you miss the Copilot Studio Coffee Chat on April 4th? This exciting and informative session with Dewain Robinson and Gary Pretty is now available to watch in our Community Galleries!   This AMA discussed how Copilot Studio is using the conversational AI-powered technology to aid and assist in the building of chatbots. Dewain is a Principal Program Manager with Copilot Studio. Gary is a Principal Program Manager with Copilot Studio and Conversational AI. Both of them had great insights to share with the community and answered some very interesting questions!     As part of our ongoing Coffee Chat AMA series, this engaging session gives the Community the unique opportunity to learn more about the latest Power Platform Copilot plans, where we’ll focus, and gain insight into upcoming features. We’re looking forward to hearing from the community at the next AMA, so hang on to your questions!   Watch the recording in the Gallery today: April 4th Copilot Studio Coffee Chat AMA

#### Exclusive LIVE Community Event: Power Apps Copilot Coffee Chat with Copilot Studio Product Team

We have closed kudos on this post at this time. Thank you to everyone who kudo'ed their RSVP--your invitations are coming soon!  Miss the window to RSVP? Don't worry--you can catch the recording of the meeting this week in the Community.  Details coming soon!   *****   It's time for the SECOND Power Apps Copilot Coffee Chat featuring the Copilot Studio product team, which will be held LIVE on April 3, 2024 at 9:30 AM Pacific Daylight Time (PDT).     This is an incredible opportunity to connect with members of the Copilot Studio product team and ask them anything about Copilot Studio. We'll share our special guests with you shortly--but we want to encourage to mark your calendars now because you will not want to miss the conversation.   This live event will give you the unique opportunity to learn more about Copilot Studio plans, where we’ll focus, and get insight into upcoming features. We’re looking forward to hearing from the community, so bring your questions!   TO GET ACCESS TO THIS EXCLUSIVE AMA: Kudo this post to reserve your spot! Reserve your spot now by kudoing this post.  Reservations will be prioritized on when your kudo for the post comes through, so don't wait! Click that "kudo button" today.   Invitations will be sent on April 2nd.Users posting Kudos after April 2nd. at 9AM PDT may not receive an invitation but will be able to view the session online after conclusion of the event. Give your "kudo" today and mark your calendars for April 3rd, 2024 at 9:30 AM PDT and join us for an engaging and informative session!