Unanswered

Problem using Boolean field formatted value

(1) Share

Report

Posted on by rgriff50

I’m using Tamarac CRM, a solution built on Dynamics 365. We are trying to automate lead capture. One of my flows will create a lead in Tamarac when it receives a webhook from Active Campaign. This is working great except for one pesky field on the Lead record, Evaluate Fit. In the current Power Platform terminology, this (Managed) column is a Yes/no datatype, which I believe is a Boolean.

When I update the value of this column for a specific row through the MS UI (on the form, or as an input of type Yes/no for a flow), things work fine. But if I set the value of the column for a row in an update row flow step (either by selecting one of the choices or supplying a custom value), it appears to only affect the value and not the formatted value. So I see a situation like this in the output body:

"evaluatefit@OData.Community.Display.V1.FormattedValue": "Yes",

"evaluatefit": false,

How can I keep the FormattedValue and the actual value in sync? Is there an expression I can enter that will affect FormattedValue as well as the actual value?

I’d appreciate any insights…

I have the same question (0)

All responses (4)

Answers (0)

abm abm 32,605 Most Valuable Professional on at

Like (1)

Report

Re: Problem using Boolean field formatted value

Hi @gcoleman

What happens when you update value as true?

Thanks

Was this reply helpful? Yes No
rgriff50 31 on at

Like (1)

Report

Re: Problem using Boolean field formatted value

Hi @abm ,

Thanks very much for responding. Your suggestion produced something unexpected. I used an expression of bool(true) as a custom value for this field and see this now in the output body:
"evaluatefit@OData.Community.Display.V1.FormattedValue": "No",
"evaluatefit": true,

It's as if they have gotten out of sync somehow. I'm loathe to simply change the labels without knowing what went wrong.

Was this reply helpful? Yes No
abm abm 32,605 Most Valuable Professional on at

Like (0)

Report

Re: Problem using Boolean field formatted value

Hi @gcoleman

Thanks for your reply. If you happy with the response please accept the solution as resolved as it will help others when they looking for solutions.

Thanks

Was this reply helpful? Yes No
rgriff50 31 on at

Like (0)

Report

Re: Problem using Boolean field formatted value

Hi @abm ,

Unless I'm missing something, this just confirms that the FormattedValue and the actual value are not in sync no matter whether the actual value is true or false. The solution I'm looking for would explain how/why they are not in sync and how best to get them back into alignment. Thanks.

Was this reply helpful? Yes No