Update Choice field on Sharepoint

[ivpd]

Hi Community.!!

I have one SharePoint where the field Status is a Choice Option (with the options Rejected, Pending, Approved).

On the other hand, I am developing an app where the user can use the checkbox to upate the records.

I was working in the formula but was impossible to me. 

Please. Could you help me?

thank you.!!

[RandyHayes · Accepted solution]

@ivpd 

You will need to change your formula to the following to Patch a Choice column in SharePoint:

Patch('DocuSign User Access Review',
    LookUp('DocuSign User Access Review', ID=ThisItem.ID),
        {Status:
            {Value: "Pending",
             '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
            }
        }
    )
)

Notice also that you should consider using a lookup rather than a First(Filter statement.  The performance is better and both give you the same result.

Also consider that if your Gallery items are based on the datasource you have, you can shorten to this:

Patch('DocuSign User Access Review',
    ThisItem,
        {Status:
            {Value: "Pending",
             '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
            }
        }
    )
)

I hope this is helpful for you.