Change the picture based on the status choice field

(0) Share

Report

Posted on by EMA03356

221

I'd like to change the picture icon in the gallery based on what status it is in. The status field is a choice field.

If(ThisItem.Status.Value="Requested",Icon.AddDocument,If(ThisItem.Status.Value="In Development",Icon.Compose,If(ThisItem.Status.Value="On Hold",Icon.Blocked,If(ThisItem.Status.Value="Published/Implemented",Icon.Publish)

All responses (7)

Answers (2)

EMA03356 221 on at

Like (1)

Report

Re: Change the picture based on the status choice field

Thank you to the both of you. They both worked!
Verified answer

SpongYe 5,580 Super User 2025 Season 1 on at

Like (1)

Report

Re: Change the picture based on the status choice field

Please do as my screenshot tested and its working:

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.
Verified answer

LaurensM 12,510 Super User 2025 Season 1 on at

Like (1)

Report

Re: Change the picture based on the status choice field

Hi @EMA03356,

Did you write the formula in the Icon property of the Icon control? In case 'ThisItem.Status.Value' has the correct value, the correct Icon should be displayed. Can you confirm that the status column has the correct values?

(Make sure ThisItem.Status.Value has the same value as is being displayed in the subtitle label)
EMA03356 221 on at

Like (0)

Report

Re: Change the picture based on the status choice field

I tried this and it accepted the formula but did not change the other icons in the gallery.
EMA03356 221 on at

Like (0)

Report

Re: Change the picture based on the status choice field

I tried this and it accepted the formula but did not change the other icons in the gallery.
LaurensM 12,510 Super User 2025 Season 1 on at

Like (0)

Report
Re: Change the picture based on the status choice field

Hi @EMA03356,

In these cases a Switch function would be preferred over nested If() statements:

Switch( ThisItem.Status.Value, "Requested", Icon.AddDocument, "In Development", Icon.Compose, "On Hold", Icon.Blocked, "Published/Implemented", Icon.Publish )

Additionally, make sure all written values between quotes match the choice value exactly. Pay close attention to spaces or capitalization.

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!
SpongYe 5,580 Super User 2025 Season 1 on at

Like (0)

Report
Re: Change the picture based on the status choice field

@EMA03356
try this
If( ThisItem.Status.Value="Requested", Icon.AddDocument, ThisItem.Status.Value="In Development", Icon.Compose, ThisItem.Status.Value="On Hold", Icon.Blocked, ThisItem.Status.Value="Published/Implemented", Icon.Publish )

------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.