Power Platform Community Forum Thread Details

Hi, I'm trying to upsert in a dataverse table where I have setup an alternative key on a coloumn 'Name' that has a logical name as 'hh_name', the upsert action has a Row Id field which expects a guid, but I am passing my alternative key ie. (hh_name='ABC') and it always return - 404 - File or directory not found.

I have tried all possible combinations, for example using "" instead of '', not using (), using column name instead of logical name but without any success. My alternative key is active.

I have used a workaround that lists the rows and get guid that way, but I really want to use altenative keys for the sake of api calls Im goona make.