How to get Yes/No value and put it to my variable?

[Max77]

Hello, guys!

Canvas App-> Dataverse Table-> Edit Form

I use Data Cards to edit a record.

I need to set field value with a button. Field DataType is "Yes/No"

I mean:

Button1.Click - It sets Yes to the Field. Button2.Click - it sets No.

But I didn't find the way how to get Choice value and set it to my variable correctly.

I believe there is a way something like this:

  Set(varYes, [@YesNo].Yes);

Of course it works this way

 Set(VarYes: First(Choices('QC (Work Orders)')).Value);

 Set(VarNo: Last(Choices('QC (Work Orders)')).Value);

Where 'QC (Work Orders)' is field QC in table Work Orders.

But it is not a correct solution of the issue.

Do you know how to get Yes/No value?

[v-yueyun-msft]

Hi , @Max77 

According to your description, do you mean you want to use a button to get the true and false.

If this , you can try to use :

Set(varFalg,!varFalg)

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you.

Best Regards,

Yueyun Zhang

[Max77]

@v-yueyun-msft , I'll try to simplify my question.

Here you can see DataCard and its property Update.

I need to put static Value in the Property

someting like this

true, false, 0, 1 don't work with this property.

Record doesn't work either

But this way works. No error. So I need the corrrect method to get Yes or No value.

[v-yueyun-msft]

Hi , @Max77 

I test it in my side . We can just use the "First( Choices('YesOrNo (YesNoTables)'))"  to update the Yes and No column, we can not use the custom record here .

Here , i create a toggle to control Yes and No:

And for the DataCard-Update, we can not use the record here , we need to use the default code :

And if you want to use the toggle to control Yes and No in this Combo box , we can use this code in the Combo Box - DefaultSelectedItems:

[If(Toggle1.Value=true , First( Choices('YesOrNo (YesNoTables)')) , Last( Choices('YesOrNo (YesNoTables)')) )]

And also we can use the SubmitForm(Form) action to update the datasource.

Best Regards,

Yueyun Zhang

[Max77]

@v-yueyun-msft 

[If(Toggle1.Value=true , First( Choices('YesOrNo (YesNoTables)')) , Last( Choices('YesOrNo (YesNoTables)')) )]

It's the same solution as I used

First(Choices('QC (Work Orders)')).Value

But I can't uderstand why your solution works without 

.Value

Anyway, It's not stable solution. 

Look, this is in design mode

and this is in Product mode (after I published my canvas page and started the app)

So the first Record isnt a Constanta.

Our company registered in Canada and i work remoutely from Ukraine.

PS: I spent all the day for this simple task and can't find a solution. What does Microsoft think? Perhaps PowerApps is intended for kids and I'm trying to build a serious application based on it.

[Max77]

As I understand there is no way to get these values correctly.

UpdateContext(
    {
        BoolVar1: First(Choices('YesOrNo (YesNoTables)')).Value,
        BoolVar2: Last(Choices('YesOrNo (YesNoTables)')).Value
    }
);
If(
    Text(BoolVar1) = "Yes",
    Set(
        ConstYes,
        BoolVar1
    ),
    Set(
        ConstNo,
        BoolVar1
    )
);
If(
    Text(BoolVar2) = "Yes",
    Set(
        ConstYes,
        BoolVar2
    ),
    Set(
        ConstNo,
        BoolVar2
    )
);

of course this works only for English.