Looking for advice on how to implement a conditional formatting based on several factors. I'm still working on my Raw Materials Inspection app:
We have 2 factors to consider: Probation and Time.
If a supplier is "On Probation" their parts should be Inspected every time and the result in the purple box would be YES.
The second factor is time. A part may need to be inspected every XX days (the Frequency of Inspection). If the Last Inspected date + Frequency-in-Days is <=Today() then the part is due for inspection and the result would be YES in the green box above.
I had both of these scenarios covered in the following text formula (note: INSP-NOW represents the Probation status):
If((Today() >= DateAdd(ThisItem.'LAST-INSP',Value(ThisItem.'FREQ-IN-DAYS')))," INSPECTION DUE ", (ThisItem.'INSP-NOW'.Value="YES")," INSPECTION DUE "," ")
Now someone has introduced the proverbial monkey wrench into my conditional statement -- If the Frequency is set to zero, then the time test should be ignored (that is, if FREQ =0, only check if the supplier in on Probation).
PowerApps IF statement uses a format of
IF(test1,result1, [test2, result2,...,] default)
so do the logical test stop once a true is encountered -- that is, if test1 is true does the If statement ever process test2?
Do I use the Switch statement here instead?