web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Engage with the Community / Implementing Visual Dr...
Engage with the Community
Suggested Answer

Implementing Visual Drug Test Flags and Search in the Player Gallery

(0) ShareShare
ReportReport
Posted on by AK-13121043-0 36
Hi guys,
 
I have attached a screenshot of a field scout canvas app that I am building.
 
I want to write (1) a Power FX formula that visually flag any player who failed a drug test by using conditional formatting. My Dataverse Player table has a field called “Drug Test result” (a choice field indicating the test outcome- Pass, Fail, inconclusive ). (2) A formula that flagged players are not editable

Thanks in anticipation
 
YK
Screenshot 2026-01-23 180516.png
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    Michael E. Gernaey 53,963 Moderator on at
     
    It depends on what you want to change, the color? the Icon itself? etc.
     
    It's pretty straight forward though
     
    Pick your Property(
    BorderColor
    or
    fill
    or DisplayMode or whatever
     
    Then decide if you want to track by value or by select / text
     
    ThisItem.'Name Of Column' = 'Choice Name'.TextValue 
     
    wrap that in an If so you can set the value true/false Color.X etc.
     

    If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

    Thank you!
    Sincerely, Michael Gernaey

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Engage with the Community

#1
furqan-ashraf Profile Picture

furqan-ashraf 14

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 9 Super User 2026 Season 1

#2
Kalathiya Profile Picture

Kalathiya 9 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Welcome to the Community Check In & Claim your PPCC Digital Swag
Welcome to the Engage with the Community forum

Product updates

Microsoft Power Platform Community release plans