web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Change Icon Based upon...

Power Apps

Answered

Change Icon Based upon Critera From two SP Lists

(0) Share

Report

Report

Posted on by jamescosten

643

I Would like to an icon which changes based upon the Gallery selection and wether or not it matches anothe SP list.

The gallery Works Order Number to look up against the Qaulity Alerts SP list Colum Job Number, If found then Cahnge Icon Else Leave as is.

I Know im doing something obviously wrong. Both SP Columns are Text fields.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

Nicbo 145 on at

Like (0)

Report
Copy link

Link copied!
Hi,
You can use lookup here instead, so somthinge like this:
If(LookUp(YourSpSite, 'Job Number' = Gallery12.Selected.'Works Order No', true), Icon.CancelBadge, Icon.CheckBadge)

Hope it helps

Was this reply helpful? Yes No
jamescosten 643 on at

Like (0)

Report
Copy link

Link copied!

Thank you Nicbo, Works exactly as required. I just wanted to add an addiontal functionality.

But the Icon remains black? Any ideas?

Was this reply helpful? Yes No
Nicbo 145 on at

Like (0)

Report
Copy link

Link copied!
Nice to hear!
You're almost there, in the if-statement you do a control, in this case if the icon is icon.Cancel the color should be red, otherwise another color, so you dont have to repeat the icon = again. So in the Color propery of the icon it should look something like this:

If(Icon5_2.Icon = Icon.Cancel, Color.Red, Color.Green)

Hope it helps!

Was this reply helpful? Yes No

Join the conversation