Help needed with advanced function!

[bubs]

Hello,

I am currently working on an app Where I display three values in a drop down list: Expectation Not Met, Expectation Met, Expectation exceeded. I need to be able to display the text but be able to add the values 1,3,5 to the text so I can average out the scores. 

Does anyone know a method to be able to assign a number value to text or how to properly find averages from a dropdown?

Anything will help. Thanks!

[Pstork1]

Build your dropdown values as a collection using the following:

ClearCollect(dropdownvalues,{Name:"Expectation Not Met",score:1},{ Name:"Expectation Met", score:3},{Name:"Expectation exceeded",score:5})

Bind the dropdown to that collection and set the Value property to Name.  Now you can access the value associated with the name using dropdown1.selected.score

[v-yuxima-msft · Accepted solution]

Hi @bubs 

You can test with @Pstork1 's method, and there is another choice is you can use Table function.

Example:

Dropdown.Items=Table({Name:"Expectation Not Met",score:1}, { Name:"Expectation Met", score:3},{Name:"Expectation exceeded",score:5})

(Then  you can use the DataTable or other controls can check your formula expression)

More information:

function-table

Hope this could be helpful.

Best Regards.

Yumia