I am a total Dataverse table newby and I haven't used the Patch function very often. I'm using it in a couple of places in the app w/out any issues but one instance keeps me giving error. After reading a bunch of articles, I still can't figure out what's wrong. The error I get is a cryptic "An Unknow Error Occurred".
Here's my code, applied to the OnSelect property of a button:
Patch('DataverseTableName',
LookUp('DataverseTableName',ID=varTaskID),
{Column1:LookUp('UserList',Title=Dropdown_AssignedTo.SelectedText.Value).'User name:Email'.Value},
{Name:TextInput_TaskName.Text},
{Column2:Dropdown1.SelectedText.Value},
{Column3:Value(TextInput1.Text)},
{Column4:Dropdown2.SelectedText.Value},
{'Column5':Value(TextInput2.Text)},
{Notes:TextInput_Notes.Text},
{Completed:Checkbox1.Value},
{DateDue:Label_DueDate})
I am afraid the syntax is right... Checked it and rechecked it a bunch of times, so what else could be wrong?
