manually enter value for yes/no column in formula bar

(0) Share

Report

Posted on by mqcp

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:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sunil-Narnaware 681 on at

Like (0)

Report
Copy link

Link copied!
@mqcp try this..
Patch(aRecord, aCondition, {'Completed': {Value: "Yes"}})

Was this reply helpful? Yes No
mqcp 109 on at

Like (0)

Report
Copy link

Link copied!

@Sunil-Narnaware
This didn't work. What is "Value" meant to represent here?

Was this reply helpful? Yes No
Sunil-Narnaware 681 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
mqcp 109 on at

Like (0)

Report
Copy link

Link copied!
@Sunil-Narnaware
Here is a screenshot of my column in a dataverse table

so the formula would actually be:

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

Was this reply helpful? Yes No
Sunil-Narnaware 681 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Sunil-Narnaware 681 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No