Power Platform Community Forum Thread Details

I'm trying to update data in SQL Server with a Patch Statement and I'm getting a "Network error when using Patch function: The specified record was not found."

The database table is pretty simple as is the patch statement:

        Patch(
            NA_BusinessUnit,
            LookUp(NA_BusinessUnit, RecID = hKey.RecID),
            {
                BusnsUnit:"Consumer"
            }
        );
 
When I select the Lookup statement, the IntelliSense does show me the value from the database. 
 
I've tried a Set statement above to set a variable to the record and then tried to use that as opposed to the lookup in the patch but that gives me a totally different error.
Set(hKey,LookUp(NA_BusinessUnit,HeaderID=HdrID&&OrderID=1));           
        Patch(
            NA_BusinessUnit,
            hKey,
            {
                BusnsUnit:"Consumer"
            }
        );
now when I hover over hKey I get a message about StatusDate - which isn't in my database table.
 
I've been staring at this for hours and can't seem to figure it out.
Any thoughts?
 