Hi @MudzaffarMansor,
Do you want to update the InventoryStatus column value (Option Set Value) of a record in your CDS entity using Patch function?
Is the InventoryStatus column a Option Set type column or Multiple Option Set type column in CDS Entity?
I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:
Set the OnSelect property of the "Patch" button to following:
Patch(
TaskLists,
LookUp(TaskLists, 'Primary Name'="1002"),
{
Approve_Status: "Rejected" /* <-- Approve_Status is a Option Set type column in my Entity*/
}
)
Please check if you have provided a proper value for the InventoryStatus column in your Patch formula. In other words, the value you provided must has been existed within the available values list of your InventoryStatus column.
Please also take a try to enable the "Use the Common Data Service experimental connector" option within Advanced settings of App settings of your app, then re-load your app, check if the issue is solved.
In addition, please take a try to re-create a new app on your side, then try above formula again, check if the issue still exists.
If the issue still exists, please consider submit an assisted support ticket through the following link:
https://powerapps.microsoft.com/en-us/support/pro/
Best regards,
Kris
