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 new user group experience and if you are a leader please create your group
Next call is happening on April 21st at 8a PST.
May the fourth be with you, join us online!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.