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

Re: Trying to calculate a field with several choices.

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

Re: Trying to calculate a field with several choices.

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

Re: Trying to calculate a field with several choices.

      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

Re: Trying to calculate a field with several choices.

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
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (4,731)