The above sample using Find() doesn't work. Neither does Search().
Any other ideas?
Solved! Go to Solution.
So say if the only two formats allowed are whole number or with one decimal place, you could use something like:
If(Value(Match(Label28.Text, (Digit & "\." & Digit)).FullMatch)>3 || Value(Match(Label28.Text, "\d+").FullMatch)>3, Red, Gray)
Here is a demo:
You can easily factor in other formats if needed, like 2 decimal places or even 3 by adding more OR conditions.
Let me know if this helps.
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!