web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to get the average...

Power Apps

Answered

How to get the average from a SharePoint Choice Column?

(0) Share

Report

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 Img

All responses (2)

Answers Img

Answers (1)

Verified answer

madlad 2,637 Moderator on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

Thanks very much!!

Was this reply helpful? Yes No

Join the conversation