How to Save Choice field value using UpdateIf/Patch functions

[SPDevOne]

Hi,

I have one button on click of it I would like to save choice field value. I have tried both the UpdateIf and Patch functions but not working.

Code of UpdateIf:

UpdateIf(Leaves,ID=ThisItem.ID,{Status:"Approved"})

Error:

"The type Text is invalid for column 'Status'. Record expected. The function 'UpdateIf' has some invalid arguments."

Code of Patch:

Patch(Leaves,Defaults(Leaves),{Status:"Approved"})

Error:

"The type of this argument 'Status' does not match the expected type 'Record'. Found type 'Text'. The function 'Patch' has some invalid arguments."

Please guide me for save choice field value.

[AarthiKanagaraj]

Hi FacundoGorla, 

It just worked like a charm , thanks for posting this . Its was a real help . 

Thanks ,

Aarthi

[shred21]

THANK YOU!!! Been searching for this answer for the past day. I plugged in your solution, updated for my specific data set, and BAM! it worked on the first go. 

WHY would MSFT make this so difficult to do? Not at all an intuitive code snippet, or one that could be figured out without some deep, wizard-level knowledge, so thank you very much for sharing!!  

[Pegger]

I am trying to apply this solution so that when a Radio button is selected, the value for the appropriate record is updated in SharePoint.  I am using a Patch statement within the OnSelect control, but I need some parts of the code within the Patch statement to refer to a dropdown value selection for filtering the correct SharePoint record AND the radio selected value the user selects.  See below code...

Patch(Country_Master,

First(Filter(Country_Master,Country='DropDown1'.Selected.Value)),

{Choice_Field:

{'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

Id: IF('Radio'.Selected.Value="Always",0,IF('Radio'.Selected.Value="Never",1)),

Value: 'Radio'.Selected.Value}

})

Unfortunately, I get a patch argument error.  Appreciate any guidance on this.

[KaupRene]

For me this worked

Patch('List';ThisItem;
{Status:
{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference";
Value:ListBox1.Selected.Value}})

[kevintroko]

Thanks, it worked, this solution is very difficult to come up with 

[hoorakhsh]

here is the best way to patch choice field:

LookUp(Choices([@M_req].MR_proiority),Value=Dropdown1.Selected.Value)

[Anonymous]

HI, The question is how can I save a default value if it is not selected but if it changes my value in the container that takes that value and the rest that and the rest that stays with the value shown.

please help me

[Sidhant_02]

Thanks @v-micsh-msft,
This is the solution that I was looking for Michael, in my case I was creating a new record and wanted to assign a Choice column value to the new user (my choice column was Role: Employee, Administrator,Manager) so I used the above code and when I checked the new record was assigned with the Choice column (0th Index value which is Employee)

New Record was assigned with the Choice first value:

Thanks @SPDevOne  for posting this query

Regards,
Sidhant

[Neil-cxy]

It works fine as below:

Patch(databaseList,LookUp(databaseList, ID =Form1_CompEdit.LastSubmit.ID), {

             Status:First(["Identified"])

            });