Dataverse Choice Column (Yes/No) with Toggle control in Power App

Like (0) Share

Report

Posted on 21 Dec 2023 15:24:57 by trstrean

181

Hello all,

I am struggling with a relatively simple thing that works perfectly with SharePoint choice column:

I have Choice Column (Yes/No) in Dataverse
Toggle control added in form to replace the combo box

However, I can't seem to figure out how to configure the toggle button to replace the default combo box within the form (strange that Power Apps wouldn't recognize that it is a toggle button in Dataverse to begin with). The Dataverse column is titled Archived, and I can't get the toggle button to correctly show what is selected (Yes/No) within the Dataverse table, and I also can't get the submit form to update Dataverse based on what is selected on the toggle button.

I tried configuring the update function of the datacard to: If(tglArchived.Value, 'Archived (Action_Plans)'.Yes, 'Archived (Action_Plans)'.No) so I don't get an error in the datacard, but when I hit the submit form, dataverse doesn't change.

I set the default for the toggle to ThisItem.Archived. I also tried various other approaches with no luck.

I left the combo box in place so I could monitor:

As you can see, nothing updates.

Any advise on this? I literally spent hours on this and I couldn't figure it out.

Thanks a lot!

Categories:

Microsoft Dataverse

I have the same question (0)

All responses (4)

Answers (2)

Suggested answer

PakWarrior 17 on 02 Sep 2025 at 04:17:26

Like (0)

Report

Dataverse Choice Column (Yes/No) with Toggle control in Power App

For Classic Toggle -

Toggle: Default: ThisItem.Test2 = 'Test2 (TestTables)'.Yes

For Modern Toggle -

Toggle: Checked: ThisItem.Test2 = 'Test2 (TestTables)'.Yes

Datacard: Update: If(DataCardValue2.Checked, 'Test2 (TestTables)'.Yes, 'Test2 (TestTables)'.No)

Was this reply helpful? Yes No
trstrean 181 on 22 Dec 2023 at 13:02:26

Like (1)

Report

Re: Dataverse Choice Column (Yes/No) with Toggle control in Power App

You were both right. After it was confirmed that it should work, I re-created the form and gallery to see if the problem continued and it somehow works today. Strange things like that happen in this environment where the only fix is to just re-create it. I think when I duplicated the screen to test a different design approach, something in the underlying mechanics of the form got broken. Starting over removed that glitch.

Was this reply helpful? Yes No
Verified answer

Jonathan Manrique 2,682 on 22 Dec 2023 at 07:21:00

Like (0)

Report

Re: Dataverse Choice Column (Yes/No) with Toggle control in Power App

Hi @trstrean

The first thing is to determine the type of column

There are Boolean Option Sets and that is the one that allows you to use the toggle control.

If you use a Choice Option Set where there are also Yes/No as outputs, you cannot use the toggle control but must use a dropdown.

More or less how it works is like this, when you use boolean (yes/no), the database already saves by default the value you enter, and there are only two values.

In the case of Choice, the database seems to allow a blank third value unlike the boolean which does not and that is where the toggle control cannot be used.

There is a way to use it and it is by making conditionals and using the patch function

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
You can accept more than one post as a solution

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft on 22 Dec 2023 at 03:38:05

Like (0)

Report

Re: Dataverse Choice Column (Yes/No) with Toggle control in Power App

Hi @trstrean ,

It worked for me.

Best Regards,

Wearsky

Was this reply helpful? Yes No