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

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

 

 

 

 

Highlighted
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

Highlighted
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
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,971)