Patching Yes/No Column OptionSetValue

(0) Share

Report

Posted on by kelseytran

2 Moderator

Hi,

I'm having an issue patching my Yes/No column values. I have several Yes/No data cards in my canvas app, but I'll use this one for an example.

Patch(
    'LOA Requests',
    Gallery1.Selected,
    {
        HasFMLAHoursAvailable: DataCardValue4.Selected.Value
    }
);

The value selected is 'Yes':

I don't get any errors when I submit the Patch function, but the record doesn't change to 'Yes' in the table:

I've tried several different variations of this code, but none work/give several errors. This is the only one that doesn't give any errors, it just doesn't do what I expect it to.

Any help is appreciated.

Thank you!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Nandit 1,568 Moderator on at

Like (1)

Report
Hi kelseytran,

I think your code will work if your replace your Dropdown with a Toggle control. As Yes/No column expects true or false.

For your current code to work, you will need to update the code to this:

Patch( 'LOA Requests', Gallery1.Selected, { HasFMLAHoursAvailable: If(DataCardValue4.Selected.Value = "Yes", true, false) } );

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No