Sets Year: Set(thisYear,Text(Today(),"[$-en-US]yyyy"));
Sets Month: Set(thisMonth,Text(Today(),"[$-en-US]mm"))
I can't seem to figure out the combination of Sort/Filter/Lookup needed to display the [compX_num] in the label. Any leads would be SO much appreciated. I'm about 3 days into trying different things!
If you would like to filter the record together with Year and half, then the Lookup formula should be written in this way:
Lookup(ListName, and(cost_center=ThisItem.cost_center, thisYear=ThisItem.year, thisHalf=ThisItem.half)).comp1_num
For the Fill property, could you please explain a bit for the
"evaluated this year, half, and month" condition?
Basically, the color change mostly depends on the If condition.
The logic for the fill property should be:
If (ConditionMet, color1, color2)
For example, for this Year color:
If (thisYear=ThisItem.year, color.azure, color.white)
Thank you for looking further into this. The "year", "half", and "month" fields were of the Sharepoint Calculated-type. This was causing problems. Once I replaced them with Single Line of Text columns and handled the variables in the app, I was able to get the Lookups to work.
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!