cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
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 !

4 REPLIES 4
Anonymous
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 ?

Regards,
Robin Lotz

Anonymous
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 🙂

 

 

 

 

Anonymous
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.

Regards,
Robin Lotz

Anonymous
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

Announcements
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)