Patching Yes/No Column OptionSetValue

Like (0) Share

Report

Posted on 15 Oct 2024 22:06:42 by kelseytran

2 Super User 2025 Season 1

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:

Tables

All responses (1)

Answers (1)

Verified answer

Nandit 1,563 Super User 2025 Season 1 on 16 Oct 2024 at 06:08:56

Like (1)

Report
Patching Yes/No Column OptionSetValue

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!