Power Platform Community Forum Thread Details

Hello!

I'm currently working on a scheduling app, but I've ran into an issue with all formulas not working the same.

About the backend:

I have 48 columns for each hour and half hour respectfully, all columns are a lookup to another table - The same table.

If the columns value isn't blank i want it to be colored in with the selected color when adding the job/task.

Example:

I have made a task that lasts the entire day, all the columns are filled with the same data to the same table and contains the exact same values.

For the field 00 i have this formula:

If(ThisItem.'00_00'.OrderID <> Blank(),
Switch(ThisItem.'00_00'.KrasaGrafikam,
Choice_Color.Red,RGBA(227,75,75,1),
Choice_Color.Blue,RGBA(54,199,245,1),
Choice_Color.Green,RGBA(104,241,71,1),
Choice_Color.Orange,RGBA(241,170,58,1),
Choice_Color.Yellow,RGBA(251,253,104,1))
,Color.Transparent)

And for the field 03 i have this formula:

If(ThisItem.'03_00'.OrderID <> Blank(),
Switch(ThisItem.'03_00'.KrasaGrafikam,
Choice_Color.Red,RGBA(227,75,75,1),
Choice_Color.Blue,RGBA(54,199,245,1),
Choice_Color.Green,RGBA(104,241,71,1),
Choice_Color.Orange,RGBA(241,170,58,1),
Choice_Color.Yellow,RGBA(251,253,104,1))
,Color.Transparent)

But for some reason it thinks the value in the lookup field is blank, I know this because I tried to add another switch case with Blank(), Color.Purple and it turned purple, but i checked the value on the table and its not blank and contains the same data as columns 00.