Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Problem using Boolean field formatted value

(1) ShareShare
ReportReport
Posted on by 31

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…

  • rgriff50 Profile Picture
    rgriff50 31 on at
    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.

  • abm abm Profile Picture
    abm abm 32,265 on at
    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

  • rgriff50 Profile Picture
    rgriff50 31 on at
    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.Presentation1.jpg

     

  • abm abm Profile Picture
    abm abm 32,265 on at
    Re: Problem using Boolean field formatted value

    Hi @gcoleman 

     

    What happens when you update value as true?

     

    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.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard