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.
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!