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

(0) Share

Report

Posted on by Max77

264

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?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

v-yueyun-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No
Max77 264 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No
Max77 264 on at

Like (0)

Report
@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.

Was this reply helpful? Yes No
Max77 264 on at

Like (0)

Report
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.

Was this reply helpful? Yes No