cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bjdshp
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? 

 

https://powerusers.microsoft.com/t5/General-Discussion/Compare-ThisItem-vs-Column/td-p/4378 

 

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: https://powerusers.microsoft.com/t5/General-Discussion/transform-view-of-data-table/m-p/211544#M6752...)

 

image.png

2 REPLIES 2
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
bjdshp
Level: Powered On

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

Correct, that is a summary of my goal.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

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

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

SixthImage

Power Summit Australia 2019

August 20-23rd 2019

Users Online
Currently online: 188 members 4,475 guests
Please welcome our newest community members: