I have created a gallery displaying personal data of employees. I would like two things to happen:
1. When the "Age" box is <=20 years old, it turns red.
The only code that works for me is:
If(ThisItem.Age = "20", red,white)
Obviously this code only captures those aged 20. Replacing the "=" with <= does not work. Any suggestions?
I want to use the count feature to count how many personnel are under 20.
I tried CountIf(List,Age <="20") but this did not work. Any suggestions?
Go to Solution.
If your age value is text type you could try If(Value(ThisItem.Age)>=20, Red, White) and
CountIf(List, Value(Age) <=20)
View solution in original post
It works! Thank you very much
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!