Average from SharePoint list column

(0) Share

Report

Posted on by da1vea

185

Hi all,

I have a column in a SharePoint list as per below (it is just a simple text column)

Depending on the number of entries, I would like to display the average in my app. I have tried the following:

1. Text(Average('Departed Users'.Duration), "[$-en-US]0.00")

2. Average('Departed Users'.Duration)

3. Average(
 Filter(
 'Departed Users',
 ),
 Duration
)

Any ideas where I am going wrong?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (0)

Report
Hi @da1vea ,

Please try this

Average('Departed Users',Duration)

Best Regards,

Wearsky

Was this reply helpful? Yes No
da1vea 185 on at

Like (0)

Report

@v-xiaochen-msft Champion! Thank you

Was this reply helpful? Yes No