Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Highlight form field if different than previous form by X%.

You may recognize a continuation on a this app we are building.  We are collecting daily readings for 200+ values in a large flat file.  I would like a method to highlight the value the operator enters if it varies from the previous daily ready by some percentage, say 10%.  


I have found this reference, but it would require for me to write this on all 200+ fields and edit the referenced column name.  Is there a way I can perform this for all fields by referencing the fields data field name dynamically so I can use the same code on each field? 


Alternatively, I would be good with creating a new collection of only the columns with values that are significantly different than the prior reading using forall.  I would then just display the table with a preference of a vertical orientation (see other post:



PowerApps Staff Mr-Dang-MSFT
PowerApps Staff

Re: Highlight form field if different than previous form by X%.

It sounds like you want to apply conditional formatting to each value. 

  • You want to compare a given reading to the previous day's reading and color it if it varies by a certain amount.
  • You want to reuse a formula for conditional formatting since you have >200 values to configure
  • You would be open to creating a new collection
Level: Powered On

Re: Highlight form field if different than previous form by X%.

Correct, that is a summary of my goal.

Helpful resources


Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.


Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Power Platform World Tour

Coming to a city near you


PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 201 members 3,151 guests
Please welcome our newest community members: