Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Change Icon Based upon Critera From two SP Lists

(0) ShareShare
ReportReport
Posted on by 629

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

 

jamescosten_0-1699974779243.png

 

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:
  • Nicbo Profile Picture
    Nicbo 145 on at
    Re: Change Icon Based upon Critera From two SP Lists

    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!

  • jamescosten Profile Picture
    jamescosten 629 on at
    Re: Change Icon Based upon Critera From two SP Lists

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

     

    jamescosten_0-1699976102018.png

    But the Icon remains black? Any ideas?

  • Verified answer
    Nicbo Profile Picture
    Nicbo 145 on at
    Re: Change Icon Based upon Critera From two SP Lists

    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 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard