Workflow UPSERT items fails to update and always inserts

Workflows
1

Hi,

I have a workflow step that is an upsert and it's refusing to update and alwasy insert a record, i have even manually set the Lookupvalue and it still inserts.

I'm looking up on the table with a string value. Any help would be grateful.

Tim.

Product_UPSERT_Workflow
Product_UPSERT_Workflow840×386 27.6 KB

2

Hi @Fordy,

Have you manually set the ItemId on the key-value pairs to ensure that is working as expected?

1 Like
3

Hi @Fordy! The behavior you're describing makes it sound like the filter that you're applying - ItemId equal to B0002GV480 - isn't returning a record that can be updated. Can you confirm with a separate query that such a record exists?