Showing results for 
Search instead for 
Did you mean: 
Not applicable

Trying to calculate a field with several choices.

Hello everyone !

I'm new on PowerApps, and i trying to calculate a field with some list choices.


My example :


I try to give a notation (cf attachment 1) with a bareme.


I create so a form in powerapps, with 3 choices for every question (cf attachment 2).


Have you an idea ?


Thank you very much !

Not applicable

Hi InfoMp,


I dont understand your issue, can you be more specific, what do you want as result ? A calculated total note, which is the addition of each selected field with their note as value ?

Robin Lotz

Not applicable

Hello RobinLotz !


It is exactly this !


In my form, i got 3 answer by question like this : Ancienneté (means serniority)

> 10 years    - 3 points

5 - 10 years  - 2 points

< 5 years      - 1 points


I need to make a calculated total note with every selected field.


Thank you RobinLotz 🙂





Not applicable

      Well if i want to do those kind of thing i would use a collection with 3 columns (theme , critere, note) like that they are related.
Fill this collection with your values,then create X (x = number of theme) Dropdown.
Set items as:  Filter(collection; theme = " your dropdown theme " ).critere.
Then in a field text "total_note" for exemple you set as default :    Value(First(Filter(collection ; critere = Dropdown1.Selected.Value))) + Value(First(Filter(collection ; critere = Dropdown2.Selected.Value)))  + ...

total_note.text = Your note.

Robin Lotz

Not applicable

Ok, i will retard this today or tomorrow, but i dont really how i Can create à collection on powerapps, i will try to find this.

Thanks you again !

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,934)