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 !
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 ?
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 🙂
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.
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications