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 the on demand sessions that are available now!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Features releasing from October 2020 through March 2021
Check out the Power Platform Community Highlights