Hi @JohnBrown ,
Could you please share a bit more about the Reviewer column? Is it a LookUp column which references values from the Users Entity?
Could you please share a bit more about the ComboBox_Reviewer? Which formula do you put within the Items property of the ComboBox_Reviewer?
Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:
Set the Items property of the ExternalUser ComboBox to following:
Choices([@TaskLists].ExternalUser)
Set the OnSelect property of the "Submit" button to following:
Patch(
TaskLists,
Defaults(TaskLists),
{
'Primary Name': "PowerApps & Python",
ExternalUser: DataCardValue7.Selected
}
)
On your side, please make sure the Items property of the ComboBox_Reviewer to following:
Choices([@YourEntity].ReviewerColumn) /* <-- ReviewerColumn represents the LookUp column in your Entity */
Then modify your Patch formula as below:
Patch(
YourEntity,
Defaults(YourEntity),
{
...,
ReviewerColumn: ComboBox_Reviewer.Selected,
...
}
)
According to the error message that you mentioned, it seems to tell that there is something wrong with the value you provided for the "Access Mode" column (Option Set type column). Please check if you have provided a proper Option Set value for the "Access Mode" in your Patch formula.
More details about setting a value for a Option Set column, please check the following blog:
https://powerapps.microsoft.com/en-us/blog/option-sets-and-many-to-many-relationships-for-canvas-apps/
Please also check and see if the response within the following thread would help in your scenario:
https://powerusers.microsoft.com/t5/General-Discussion/Lookup-and-Load-a-user-record-from-CDS-into-powerApps-Form/m-p/365677
Best regards,
