cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highwaywoman
Helper I
Helper I

Average of all items SP column - PowerApps formula?

Hello! Happy Monday. 

 

I have a ton of date columns in my SharePoint list. I have the find the average between each pair of dates. Number two requirement is the one i can not figure out for the LIFE of me.

 

The requirements:

1. Find the difference between the dates individually.

I do so using this formula referencing the form on the screen. Works great.

DateDiff(DataCardValue30,DataCardValue33 ,Days)

 

2. Find the average of the all the days.

For example using the image. I have a column information requested and Information Received. The formula above is used to note the date difference was a total of 1 day on the right using information from datacards from the Form on the left.

 

Now I need to find the average for all my list items. Say one item took 1 day, one item took 5 days, one item took 3 days etc. I need to find the average of all items. These items are in a SharePoint list, but they are also in a Gallery on my power app. I am willing to di it via SharePoint or via power app formula.

 

example1.PNG

 

 

I thank you in advance. I always mark the solution to my questions! Promise 🙂 

Madeline

 

5 REPLIES 5
RandyHayes
Super User
Super User

@Highwaywoman 

Is this the same Items property formula as your prior post, or do you have a different one?  If so, what is it at this point?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!
Highwaywoman
Helper I
Helper I

HI again @RandyHayes !!

Different app so different list/gallery. I think dates just confuse me!

Do you have any idea about how to get that column average from the list? Within or outside of my power app? Im trying to compare it to an excel formula but i just can't get my head around it. 

RandyHayes
Super User
Super User

@Highwaywoman 

Yes, what is the Items property formula and what are the column names you are comparing?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Good morning, @RandyHayes  the item is a selection based off the gallery on the left. so hope to be pulling my averages from those items 🙂

example3.PNG

Highwaywoman
Helper I
Helper I

Update in case anyone has read this or is having the same issue. 
I made a calc column in my SP list for the date difference (its a text column though..)
then in power apps I use this to add the column for all items then divide by the number of gallery items: 

 

Sum(Gallery2.AllItems, ThisRecord.DateDiff) / CountRows(Gallery2.AllItems)

I still would rather do this all in power apps...need help still -___- I want this to be a measure of time rather than just text (Days) like...Days Hours Minutes. Will keep working and update here.

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (3,923)