Simple formula but I can't figure it out

[hughrmarks]

Okay, I have the names of two tennis players in two text boxes - Name1 and Name2.   Next to each I have dropdowns for each of their scores - Score1 and Score2.   All I'm looking to do is automatically put the name of the winner in a third text box based on the higher of the two scores.

I thought the formula was:

If( Score1.Selected.Value > Score2.Selected.Value, Name1.Text, Name2.Text)

...but it didn't work.

It would be great if there was a list of Excel formulas translated to PowerApps formulas.

[bdodu · Accepted solution]

You are comparing text values instead of numbers, perhaps your intention is to compare numeric fields. Score1.Selected.Value is a text value, you can transform it to numeric like this:

Value( Score1.Selected.Value )

[hughrmarks]

Aha!  I was close.   Thanks for the help - it worked!