Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Answered

Patching Yes/No Column OptionSetValue

(0) ShareShare
ReportReport
Posted on by 2
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
    Nandit 1,545 on at
    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!
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard

Featured topics