Hi @WarrenBelz please assist, it's a continuation from
https://powerusers.microsoft.com/t5/Building-Power-Apps/If-amp-Or-condition-help/m-p/922578#M292656
BrowseGallery > TemplateFill, I have the following codes written as shown below.
With(
{
dDate1: DateDiff(
Today(),
ThisItem.FO_OUT,
Months
),
dDate2: DateDiff(
Today(),
ThisItem.KMC_OUT,
Months
),
dDate3: DateDiff(
Today(),
ThisItem.SNP_OUT,
Months
),
dDate4: DateDiff(
Today(),
ThisItem.SRP_OUT,
Months
),
dDate5: DateDiff(
Today(),
ThisItem.SUT_OUT,
Months
),
dDate6: DateDiff(
Today(),
ThisItem.SLNG_OUT,
Months
),
dDate7: DateDiff(
Today(),
ThisItem.TMUC_OUT,
Months
),
dDate8: DateDiff(
Today(),
ThisItem.TSPR_OUT,
Months
)
},
If(
dDate1 < 1 || dDate2 < 1 || dDate3 < 1 || dDate4 < 1 || dDate5 < 1 || dDate6 < 1 || dDate7 < 1 || dDate8 < 1,
Red,
dDate1 < 3 || dDate2 < 3 || dDate3 < 3 || dDate4 < 3 || dDate5 < 3 || dDate6 < 3 || dDate7 < 3 || dDate8 < 3,
Yellow,
White
)
)
The image attached below are my BrowseGallery and they are just names.
The image attached below are just the DetailForms indicating the expiry date. They react with the colour red, yellow and white based on the code found above.
Let us pay more attention to the code shown below as summarized from the original code,
If(
dDate1 < 1 || dDate2 < 1 || dDate3 < 1 || dDate4 < 1 || dDate5 < 1 || dDate6 < 1 || dDate7 < 1 || dDate8 < 1,
Red,
To summarized, as long as any dDate expires, the BrowseGallery must show red. Same can be said with yellow provided there's no red, then the BrowseGallery must show yellow.
Now refer to the two image, BrowseGallery under the name "Mohammad Shazarul Bin Ishak".
It should have shown red instead it is yellow.
Where did I went wrong?
