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:



Power Apps Staff Mr-Dang-MSFT
Power Apps 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


Power Apps Super User Class of 2020

Check it out!


New Badges

Check it out!


Power Apps Community User Group Member Badge

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


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (5,153)