web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Comparing numbers

Power Apps

Unanswered

Comparing numbers

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

I'm brand new to this, I'm looking to help create a solution that would quickly compare a list of numbers and highlight any numbers that are outside of (+ X, -X) which would need to be adjusted for each list. I know there are simple formulas in excel but would like to couple this with other tools in power apps. Any suggestions on where to start?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

On button's OnSelect property you can use (minCount and maxCount are minimum and maximum allowable limit)
If(Value(TextInput1.Text) > maxCount || Value(TextInput1.Text) < minCount, Notify("The number is not in the range"), SubmitForm(Form1))

Was this reply helpful? Yes No
rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hi @Anonymous in addition to the solution given by @NandiniBhagya20 please find the following:

Power Fx (the language you code in power apps) have a full set of operators and identifiers and can be found at Operators and Identifiers in Microsoft Power Fx - Power Platform | Microsoft Docs

Consider the following:

You have a list with numbers, let's call the list a SharePoint List myList and this list has a column evalNumber.

Steps to highlight numbers outside of range.

add a textinput and call it txtLowerLimit. set its Format to Number

add a textinput and call it txUpperLimit. set its Format to Number

add a gallery and to it add a label

label Text = Thisitem.evalNumber //display the number in the list

label Color = If(ThisItem.'Is in Range',Green,Red) //if the number is in range its green else it displays red

set the gallery Items = AddColumns(myList, "Is in Range", And(evalNumber < Value(txtUpperLimit.Text), evalNumber > Value(txtLowerLimit.Text)))

Result

Code in example:

Gallery Items =

AddColumns( ForAll( Sequence(5), { evalNumber: RandBetween( -10, 10 ) } ), "Is in Range", And( evalNumber < Value(txtUpperLimit.Text), evalNumber > Value(txtLowerLimit.Text) ) )

Hope it helps,

R

Was this reply helpful? Yes No

Join the conversation