Switch not working

[RobGas]

Hello!

I've run into an issue where it seems that my lookup seems to be blank even tho there is data inside dataverse.

The formula im using for field 00:

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)

The formula im using for field 03:

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)

Both fields contain the exact same information because they are lookup values to the same table and record.

What i dont understand is why does it think that the value of KrasaGrafikam is blank, because when i add another switch case to test Blank(),Color.Purple it turns the field purple, but ive double checked everything and i cant figure it out, any help would be greatly appreciated

[Amik]

@RobGas - you're missing a false condition if the record does return blank:

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
    ),
    Color.Transparent
)

[RobGas]

Hey! Thanks for your response, but that doesn't solve the issue since the problem is that it acts as if it were blank, but the value is in fact not blank.

Picture from dataverse:

You can see in the picture that the both 03_30 and 04_00 contains same lookup record.

I added the formula for the transparent and you can see it does trigger the blank condition

Now i put a display for it to show in text field the KrasaGrafikam

ThisItem.'03_30'.KrasaGrafikam

What i don't understand is how one of the values can be blank if both of them are the same record.

[Akshansh-Sharma]

Hi @RobGas ,

Can you please confirm this point in your formula you are usign 03_00 

The formula im using for field 03:

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)

While in the Screenshot which you shared the column is 03_30 which contains the lookup record and i can't see 03_00 anywhere in that screenshot so can you please tell me if that's what was expected? if not can you please use 03_30 in your formula and try it again

--------------------------------------------------------------------------------------------------------------------

Please click Accept as solution if my post helped you solve your issue. If the content was useful in other ways, please consider giving it Thumbs Up 😉

LinkedIn- https://www.linkedin.com/in/akshansharma/

[Amik]

@RobGas - sorry it is difficult understanding what those images are supposed to tell me, and unfortunately I do not understand your response.

Before I drop off this post, if you apply the below to Label control, does it return blank?

ThisItem.'00_00'.OrderID