Using choice fields in a formula column (Dataverse for Teams)

(0) Share

Report

Posted on by MelissaReed

292

What is the syntax for referencing a Choice field within a formula?

I'm trying to reference a choice field value -- MeasureProgressFrequency as part of the formula in a separate column in the same table.

If I reference a text field column (like FirstName) in this formula, even concatenate several together it works fine.

The holdup is the Choice field.

But I can't figure out the syntax this needed to reference the record's MeasureProgressFrequency selected value within a formula column in the same table (illustrated above)

Tacking on ".Value" doesn't help.
Tacking on ".Selected" doesn't help
I tried 'MeasureProgressFrequency (OKRS)'), and tacking.Value onto that.

I could write the formula on the Power Apps side, but I want it stored at the table level so it's available to Power BI.

Anyone else run into (and hopefully solved) this?!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @MelissaReed ,

Unfortunately, this preview column doesn't support this data type now.

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/formula-columns#data-types

Hope it saves your time.

Best Regards,

Wearsky

Was this reply helpful? Yes No
MelissaReed 292 on at

Like (0)

Report
Copy link

Link copied!

Thanks @v-xiaochen-msft
I did see that page but meant the value type, not the table column type. My pick list is a list of Text values.
But Choice fields are not supported at all. That probably also explains why I'm having trouble referencing that Selected.Value in a formula on the App side as well. I can display it, just not combine it with anything else. Or even store it to a variable. Maddening! I guess I'll have to go to Plan B -- calculate it in a flow and store it back to the record. Thanks for your help!

Was this reply helpful? Yes No
Owen Wetherow 71 on at

Like (0)

Report
Copy link

Link copied!
I know that this may not be totally satisfying but you can you use JavaScript to access the value of a choice field

In this case I wanted to calculate 'Residual exposure' = 'Residual likelihood' x 'Residual impact'

function CalculateResidualExposure(executionContext) {

var formContext = executionContext.getFormContext();
var rlike = formContext.getAttribute("papm_residuallikelihood").getValue();
var rimpact = formContext.getAttribute("papm_residualimpact").getValue();

formContext.getAttribute("papm_residualexposurevalue").setValue(rlike*rimpact)

}

I had to create an event on both 'Residual likelihood' and 'Residual impact'. This set the value of 'Residual exposure value'
Make sure to pass Execution Context

I really wish I was able to use the field values in the fx

Was this reply helpful? Yes No