Unanswered

If/Then Statement using Dataverse Yes/No Choice Column shows formula not in scope.

(0) Share

Report

Posted on by CE-16101943-0

With a form data card I am trying to write a simple if/then statement to change the color of the card based on the value of a (Yes/No) Choice field (In_Spec) in the record.

Within the fill property:

If(ThisItem.In_Spec,

RGBA(0,255,0,.5),

RGBA(255,0,0,.5))

The error I get is:

Can someone explain the correct way to use a Dataverse table (yes/no) choice column in a record so it can be used to evaluate an If/Then statement in a power apps canvas app.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Anchov 1,986 on at

Like (0)

Report
To evaluate a Yes/No column in Dataverse, you need to specify the Yes and No values by selecting the appropriate options from the "Choice Set." This is typically in the format of '[Name of Yes/No Column] ([Name of Table])].[Selected Choice]'. Here's an example:

If(ThisItem.Active = 'Active (Dog Breeds and Characteristics)'.Yes, "Active", Blank())

For you it will be something like:

If(ThisItem.In_Spec = 'In_Spec (yourtablename)'.Yes, RGBA(0,255,0,.5), RGBA(255,0,0,.5))

Hint: The intellisense in the formula bar should help you fill in and validate the choice set by starting to type your column name.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers!
Rick Hurt

Was this reply helpful? Yes No
CE-16101943-0 81 on at

Like (0)

Report

You are correct that works. When working with Forms & Datacards inside Power Apps there is one more step that I found is necessary. The data card for the choice column must be included in the form. You can make it invisible, but it has to be there. This may be a bug, but the logic @Anchov explained will only work if the evaluated choice column's datacard is included in the form.

Was this reply helpful? Yes No