I've got two lists:
InventoryListOne and InventoryListTwo. In list One I have a column called Id Test with numbers in them, I've created 4 items, so the ID Test numbers run from 1 - 4. In list Two there's a column called DeviceId. On list Two I've created a Worklow and have a Query List item where I query List One and the ID Test column and save it to a variable called Inven_Number. Next I have a Set field value which is set to DeviceID, Equals Workflow Data and then Inven_Number but when I run the Workflow it just updates the DeviceID column to '1' regardless of what the number in ID Test is in list One? What am I doing wrong?