Unanswered

Insert a different icon into a gallery, dependant upon Status

(0) Share

Report

Posted on by nshaw75

438

I am creating a Permit status App and am wanting to Insert a different Icon into the gallery dependant upon the Status value in the SharePoint list. Ie If Complete, a Green Tick, If the Permit is live it would be a Red Cross and something else to indicate the permit is planned but not yet under way.

I have been thinking about using a formula about changing the visibility of each icon, dependant upon the value. But I am not really sure where to start.

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (2)

DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report
Hi @nshaw75

Use Switch:
Throw any icon into the gallery and in the Icon property of the icon:

Switch( ThisItem.Status, //name of your status column "live", Icon.CancelBadge, "complete", Icon.CheckBadge, Icon.CalendarBlank )

And because you mentioned colours, put this in the Color property of the icon:

Switch( ThisItem.Status, //name of your status column "live", Color.DarkRed, "complete", Color.DarkGreen, Color.DarkBlue )

You could go a step further and put this in the Tooltip property of the icon:
ThisItem.Status //name of your status column

Result:

Was this reply helpful? Yes No
nshaw75 438 on at

Like (0)

Report
Hi @DJ_Jamba , many thanks for the help. I have copied the formula as above, changing the text
name of your status column
to " Status " and the error details are saying I am missing an Operator between the Operands. I also added, in the same syntax as the formula above, the Planned item.
Icon.CancelBadge,
"Complete",
Icon.CheckBadge,
"Planned",
Icon.CalendarBlank
)

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (1)

Report

Show me the code you've entered please

Was this reply helpful? Yes No
nshaw75 438 on at

Like (0)

Report

Hi i have just cut this straight from the formula bar

Switch(
ThisItem.Status, //status
"Live",
Icon.CancelBadge,
"Complete",
Icon.CheckBadge,
"Planned",
Icon.CalendarBlank
)

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (1)

Report

Is Status the name of your column in SharePoint or is it status?

Was this reply helpful? Yes No
nshaw75 438 on at

Like (0)

Report

Ah Yes the column is Status. Although I have changed this, the error is reporting that the function is expecting a record. This is no doubt due to the column being a choice column

Was this reply helpful? Yes No
Verified answer

DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (1)

Report
Try:
Switch( ThisItem.Status.Value, "Live", Icon.CancelBadge, "Complete", Icon.CheckBadge, "Planned", Icon.CalendarBlank )

Was this reply helpful? Yes No
nshaw75 438 on at

Like (1)

Report

Fantastic, Thank you very much for your help. 😃

Was this reply helpful? Yes No
DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (1)

Report

You're welcome!
d(-_-)b

Was this reply helpful? Yes No
nshaw75 438 on at

Like (0)

Report

@DJ_Jamba , Thanks again for the help. As you mentioned early on in the thread you can add colours to the formula, can this be done as well as changing the icon?
I have tried to insert the following, to change the Live icon to red and it hasn't worked.

Switch(
ThisItem.Status.Value,
"Live",
Color.DarkRed,
Icon.CancelBadge,
"Complete",
Icon.CheckBadge,
"Planned",
Icon.CalendarBlank
)

Was this reply helpful? Yes No