Answered

How to insert an image/icon in gallery based on conditions

(1) Share

Report

Posted on by water-guy-5

101

Hello, I am attempting to add a few images to my gallery based on the value in one of my columns, 'Status'.

Ideally, I have 3 images I want to include based on the 3 entries for 'Status' such as "Paid", Status is Blank, and "Written Off".
However, I tried to find an easier solution by just using the icons already offered by Power Apps.

Status is not one of the SP columns included in my gallery. Is that the problem? Is it the syntax?

Any help is appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

abrae005 161 on at

Like (1)

Report
Try
If(ThisItem.Status.Selected.Value = "Paid", CheckBadge); If(ThisItem.Status.Selected.Value = "Written Off", CancelBadge)

Really, you could probably do this as a nested If statement - you didn't mention what icon you wanted for the 3rd option, so I just chose "Trash", but obviously, choose your own icons 🙂 ... Or just leave blank to have none
If(ThisItem.Status.Selected.Value = "Paid", CheckBadge, If(ThisItem.Status.Selected.Value = "Written Off, CancelBadge, Trash))

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like (0)

Report
@water-guy-5 wrote:
Status is not one of the SP columns included in my gallery. Is that the problem? Is it the syntax?

@water-guy-5 I think the problem might be both.

So you can try something like this (below is a pseudo formula - please replace values with what makes sense for you below)

If(ThisItem.SomeColumn = "Paid",CheckBadge,If(ThisItem.SomeColumn = "Written Off",CancelBadge,DefaultBadge))

or

If(IsBlank(ThisItem.SomeColumn),BlankBadge, If(ThisItem.SomeColumn = "Paid",CheckBadge,If(ThisItem.SomeColumn = "Written Off",CancelBadge,DefaultBadge)))

Check if above helps.

Was this reply helpful? Yes No