Skip to main content

Notifications

Community site session details
Power Apps - Microsoft Dataverse
Answered

Patching Yes/No Column OptionSetValue

Like (0) ShareShare
ReportReport
Posted on 15 Oct 2024 22:06:42 by 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:
  • Verified answer
    Nandit Profile Picture
    1,563 Super User 2025 Season 1 on 16 Oct 2024 at 06:08:56
    Patching Yes/No Column OptionSetValue
     
    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!
     

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 17

#3
Fubar Profile Picture

Fubar 11 Super User 2025 Season 1

Overall leaderboard

Featured topics

Loading complete