Answered

Left function error

(0) Share

Report

Posted on by MIA27

I am trying to set image in the gallery based on condition, But not working, No error no image on display

please guide what is the error making:

Switch(
 Left(ThisItem.Model,1),
 "B",
 Bulldozer,
 "E",
 Excavator
)

All responses (10)

Answers (1)

MIA27 on at

Like (0)

Report

Re: Left function error

Finally it worked
Switch(Left(ThisItem.Model,1),"D",Bulldozer,"E",Excavator)

It was my mistake, the result I was putting with Left, it should be seperate,

Thank you for all efffort and advise which gave me learning for future use
MIA27 on at

Like (0)

Report

Re: Left function error

Not worked, so frustrating, such a simple formula, not working.

When I apply with if for testing purpose, the left function works
If(Left(ThisItem.Model,1) = "D",Bulldozer,"E",Excavator)

Once changed to switch function with same left, does not work
Switch(Left(ThisItem.Model,1) = "D",Bulldozer,"E",Excavator)

Funny situation, left bring the same value, in both situation, but not work in switch.
Any idea, need to use .value or .text

Please guide
Verified answer

LaurensM 12,510 Super User 2025 Season 1 on at

Like (1)

Report
Re: Left function error

Hi @MIA27,

I forgot to prefix ModelFirstChar with ThisItem. My apologies.

Switch( //Changed here ThisItem.ModelFirstChar, "B", Bulldozer, "E", Excavator )

Should the change above still result in no images - you may want to add this AddColumns when collecting the data instead:

ClearCollect( AddColumns( DataSource, "ModelFirstChar", Left(Model, 1) ) )

I hope this helps!
MIA27 on at

Like (0)

Report
Re: Left function error

I applied the code as below, but getting formula error as shown in the below image

//Gallery items property AddColumns( colAllList, //replace with your datasource or Filter statement "ModelFirstChar", Left(Model, 1) ) //Image property of the Image control Switch( ModelFirstChar, "B", Bulldozer, "E", Excavator )

Please guide the correction
LaurensM 12,510 Super User 2025 Season 1 on at

Like (1)

Report
Re: Left function error

Hi @MIA27,

I suspect that this may be caused due to explicit column selection. A workaround would be defining the required columns via ShowColumns() in your gallery items property.

In your case you could add an additional column containing the Left value:

//Gallery items property AddColumns( Datasource, //replace with your datasource or Filter statement "ModelFirstChar", Left(Model, 1) ) //Image property of the Image control Switch( ModelFirstChar, "B", Bulldozer, "E", Excavator )

I hope this helps!
MIA27 on at

Like (0)

Report

Re: Left function error

Also please note to test I put the below and it works
Switch(
ThisItem.Model,
"D155A",
Bulldozer,
"PC400",
Excavator
)

But this is not the requirement, as there are several models and can categorised by the first letter, therefore I was trying the left function.
This proves that mistake is in Left function writing method.

Pls guide
MIA27 on at

Like (0)

Report

Re: Left function error

It is not lower case, and does not have space at the start.
MIA27 on at

Like (0)

Report

Re: Left function error

Data source - Table in Teams
Data Type of Model is Text
Yes, the file name is correct. Because I test in another gallery, in another situation where Left was not been used.
LaurensM 12,510 Super User 2025 Season 1 on at

Like (1)

Report
Re: Left function error

Hi @MIA27,

The function looks ok - using this approach however is case sensitive. Could it be possible that the Model starts with a lower case instead of an upper case?

Switch( //Lower avoids case sensitivity by defaulting it to lower case Left(Lower(ThisItem.Model),1), "b", Bulldozer, "e", Excavator )

(Make sure Model never starts with a space, otherwise you may need to use the Trim() function as well)

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!
Ami K 15,665 Super User 2024 Season 1 on at

Like (1)

Report
Re: Left function error

@MIA27 -

What is your data source? (SharePoint, SQL, Dataverse etc)

What is the data type for Model? Is that an actual field in your data source?

Are you certain that your image file names in your code exactly match the image file names in the Media Pane? I see you have correctly excluded the image extension (png, jpeg etc).