Announcements
I know how to use this in Excel but not in PowerApps.
In the attachment, if Score A = Score B AND sRed = True, give me FullNameA.
if Score A = Score B AND sBlue = True, give me FullNameB.
The name of the datasource is Results.
Help!
Hi @hughrmarks
Supposing that you want to show FullNameA or FullNameB on a label in a card/form, the syntax you would use would look like this:
If(And(ScoreA=ScoreB, sRed=True), FullNameA, If(And(ScoreA=ScoreB, sBlue=True), FullNameB, "" ) )
Thank you. That makes perfect sense but don't I need to reference the table (Results) in my function since that is the data source I am querying?
Assuming that you're working with a card on a form, you would define your data source and the record that you want to work against at the form level. In the example screenshot that's shown here, you would set the DataSource property to 'Results'.If you're not using a form, you would need to call the UpdateContext and Lookup functions to retrieve your record into a variable, and to then apply your If statement against the properties of the variable.
I had to make a few tweaks but it worked. Thanks!
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 476
WarrenBelz 365 Most Valuable Professional
Vish WR 339
