Switch Function

[rvdhorst]

I would like to use the Switch function instead of the If function.
The fill must be filled if a color matches. I thought something like that.

If(LookUp(col_PlannerkeukenCombi,CombiID=ThisItem.CombiID,Switch(ThisItem.CombiID,Color,"Rood",Red,"Blue",blue)))

If that works is like this:

If(LookUp(col_PlannerkeukenCombi,CombiID=ThisItem.CombiID,Kleur="Rood"),Red,
If(LookUp(col_PlannerkeukenCombi,CombiID=ThisItem.CombiID,Kleur="Geel"),Yellow, White
))

Thanx

[ASHetap]

I had the same issue that you had but i also could not find anything regarding a switch function so i had to do with if statements sadly.

[rho1967]

I was already afraid of that.

Thanks for the reply

[v-bofeng-msft · Accepted solution]

Hi @rvdhorst ,

Maybe you could try:

Switch(
  LookUp(col_PlannerkeukenCombi,CombiID=ThisItem.CombiID).Kleur,
  "Rood",
  Red,
  "Geel",
  Yellow,
  White
)

Best Regards,

Bof

[rho1967]

Great,

That works. 

I have also this one. Can it also be done with Switch?
If(LookUp(col_PlannerkeukenCombi,CombiID=LookUp(Filter('Keuken Cycles',Status='Status (Keuken Cycles)'.Actief),Datum=Cyclus_DatePicker_Begin_1.SelectedDate,CombiID),Kleur="Rood"),Red,

If(LookUp(col_PlannerkeukenCombi,CombiID=LookUp(Filter('Keuken Cycles',Status='Status (Keuken Cycles)'.Actief),Datum=Cyclus_DatePicker_Begin_1.SelectedDate,CombiID),Kleur="Geel"),Yellow, Black
))

[v-bofeng-msft · Accepted solution]

Hi @rvdhorst :
You could try:

Switch(
  LookUp(
    col_PlannerkeukenCombi,
    CombiID=LookUp(
              Filter(
                 'Keuken Cycles',
                  Status='Status (Keuken Cycles)'.Actief
             ),Datum=Cyclus_DatePicker_Begin_1.SelectedDate).CombiID
    ).Kleur,
   "Rood",
    Red,
    "Geel",
    Yellow,
    Black
)

Best Regards,

Bof

[rvdhorst]

Thanx all,