When I try to evaluate a column condition of a collection to change the color of a circle, it doesn't work ...
Any idea how to refer to the collection?
Thanks in advance
Solved! Go to Solution.
I think it´s little more complicated, it´s a circle in a calendar.
The circle is visible according to the date column in the collection, (DateAdd(_firstDayInView,ThisItem.Value,Days) in DaysFinal.StartDate1) This code works OK..
But I need to paint with a color X the circle according to the item, and that is the problem...
This code paints all the days in Red: LookUp(DaysFinal,Item1="Vacations",Red)
if there is an item with another value (eg: "work") , it does not paint it of another color...
You could solve this by doing the following:
In your collection you have the date. Based on this date you can do a lookup, problem is that you need to concatenate the date yourself.
Switch( LookUp( colEvents, Concatenate( Text( Day( DateAdd( _firstDayInView, ThisItem.Value, Days ) ) ), "/", Text(Month(_firstDayOfMonth)), "/", Text(Year(_firstDayOfMonth)) ) = Text(colDate) ).Item1, "Vacation", RGBA(56,96,178,0.2), "Work", RGBA(56,96,178,0.5 ), "Weekend", RGBA(56,96,178, 1), RGBA(56,96,178,0.6 ) )
I would also do a switch instead of an If, this way you make it more Future proof.
Excuse me for my lack of knowledge!
Your code Is not working as expected. Maybe I´m doing something wrong, I only changed the source and colDate variable ....
See the image.
Maybe using a Gallery as reference, but not luck, it says "Expected ColorValue"...
If(Title1.Text="Work",RGBA (138,43,226,1),RGBA (0,255,255,1)))
Thanks a lot for your help anyway.
Just had a quick look at your collection data and your data notation is different than mine ( I'm from Belgium).
So you will need to change to order of the Concatenate so that the format will be the same as in your collection.
Can you try this?
Hopefully this will solve your problem
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.