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

(0) Share

Report

Posted on by trstrean

185

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 with Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @trstrean ,

It worked for me.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Verified answer

Jonathan Manrique 2,695 on at

Like (0)

Report
Copy link

Link copied!

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
trstrean 185 on at

Like (1)

Report
Copy link

Link copied!

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
Suggested answer

PakWarrior 17 on at

Like (0)

Report
Copy link

Link copied!

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)

2 people found this reply helpful.

Was this reply helpful? Yes No