web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / manually enter value f...
Power Apps
Answered

manually enter value for yes/no column in formula bar

(0) ShareShare
ReportReport
Posted on by 109

I want to do this to edit the yes/no choice column I have:

 

 

Patch(aSource, aRecord, {'Completed': yes})

 

 

 Obviously not by using the word "yes" but everything I've tried it complains about the type not being an "Option set value". What exactly am I meant to put where the "yes" is, in the formula bar, to make it change in my table? 

Categories:
I have the same question (0)
  • Sunil-Narnaware Profile Picture
    681 on at

     

    @mqcp try this.. 

    Patch(aRecord, aCondition, {'Completed': {Value: "Yes"}})

     

  • mqcp Profile Picture
    109 on at

    @Sunil-Narnaware 

    This didn't work. What is "Value" meant to represent here?

  • Sunil-Narnaware Profile Picture
    681 on at

    @mqcp Value means the Option Set Value.. what is your data source? and what are the choice column values in Completed column?

  • mqcp Profile Picture
    109 on at

    @Sunil-Narnaware 

    Here is a screenshot of my column in a dataverse table

     

    ASinTable.PNG

     

    so the formula would actually be:

     

    Patch('My Table', aRecord, {'Audit Status': ____})

     

  • Sunil-Narnaware Profile Picture
    681 on at

    @mqcp are you using any dropdown with choice values for user selection.. or by default the value should be yes?

  • Verified answer
    Sunil-Narnaware Profile Picture
    681 on at

    @mqcp Patch('My Table', aRecord, {'Audit Status': 'Audit Status (My Table)'.Yes})

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 541

#2
WarrenBelz Profile Picture

WarrenBelz 434 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 289

Last 30 days Overall leaderboard