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.
Solved! Go to 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 )
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 )
Aha! I was close. Thanks for the help - it worked!
User | Count |
---|---|
230 | |
102 | |
97 | |
57 | |
32 |
User | Count |
---|---|
282 | |
112 | |
109 | |
63 | |
63 |