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?
Solved! Go to Solution.
@mqcp Patch('My Table', aRecord, {'Audit Status': 'Audit Status (My Table)'.Yes})
@mqcp Value means the Option Set Value.. what is your data source? and what are the choice column values in Completed column?
Here is a screenshot of my column in a dataverse table
so the formula would actually be:
Patch('My Table', aRecord, {'Audit Status': ____})
@mqcp are you using any dropdown with choice values for user selection.. or by default the value should be yes?
@mqcp Patch('My Table', aRecord, {'Audit Status': 'Audit Status (My Table)'.Yes})
User | Count |
---|---|
164 | |
90 | |
73 | |
64 | |
57 |
User | Count |
---|---|
213 | |
153 | |
96 | |
88 | |
66 |