cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mqcp
Resolver I
Resolver I

manually enter value for yes/no column in formula bar

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? 

1 ACCEPTED SOLUTION

Accepted Solutions
Sunil-Narnaware
Solution Supplier
Solution Supplier

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

View solution in original post

6 REPLIES 6
Sunil-Narnaware
Solution Supplier
Solution Supplier

 

@mqcp try this.. 

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

 

@Sunil-Narnaware 

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

Sunil-Narnaware
Solution Supplier
Solution Supplier

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

@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
Solution Supplier
Solution Supplier

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

Sunil-Narnaware
Solution Supplier
Solution Supplier

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

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (2,344)