How to get the average from a SharePoint Choice Column?

(0) Share

Report

Posted on by s_tanswell84 Microsoft Employee

Hi! I have a SharePoint List ("Feedback List") which has a Choice Column ("Rating") where the user can choose a score. The options are 1, 2, 3, 4, or 5.

I want to show the average score in my PowerApp in a Text Label. I am struggling to find the right formula.

Can anyone help?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

madlad 2,637 Moderator on at

Like (0)

Report
Hi!

here you want to use the average function.

Try something like the following:

Average('Feedback List', Rating.Value)

^This is the simplest way, but isn't delegable. If you will have more than 2000 records, you may need a different function here.

Since it's a lookup column, you need to use .Value to get the value of the record.

Hope this helps!

Was this reply helpful? Yes No
s_tanswell84 Microsoft Employee on at

Like (0)

Report

Thanks very much!!

Was this reply helpful? Yes No