Hi Power Apps Community,
I would like to multiply two numbers together, BUT the value resulted from the multiplication should not exceed a certain amount. For example, I have a variable for the max amount which is 10.
So if I say 2 * 2 = 4, then the value returned should be 4.
However, if I say 4 * 4 = 12 (which exceeds the max of 10), then the value returned should be the max amount of 10.
I would really appreciate any assistance.
Thank you in advance.
Solved! Go to Solution.
Consider this:
If(
Value(TextInput2.Text) * Value(TextInput1.Text) > 10,
10,
Value(TextInput2.Text) * Value(TextInput1.Text)
)
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Consider this:
If(
Value(TextInput2.Text) * Value(TextInput1.Text) > 10,
10,
Value(TextInput2.Text) * Value(TextInput1.Text)
)
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Hi @Data_Enthusiast ,
Use IF() function:
If (value1*value2 > MaxAllowedValue, MaxAllowedValue, value1*value2)
4*4=12 (what am I missing ?)
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
258 | |
126 | |
85 | |
85 | |
68 |